Questions tagged [OLAP] (26)

0
answer

OLAP. How to sort the hierarchy?

Hi all. Write a query against the olap cube for Team Foundation Server. Get what you need ( the child elements of the specified element). But it's all sorted by default. I would like to sort by hierarchy (ie parent, then its child, then the next parent and so on) The query is now as follows:SELECT {[Measures].[Complete]} ON...
Cleveland.Hoppe asked April 2nd 20 at 16:23
1
answer

How to fill in the empty lines of non-existent values?

There is a table that contains several hundred thousand records quantity changes (changes = date of entry in the table). The third field is the change on the date How to fill in the data for all the numbers, using data of the number for which they are? So now we have: Used SQL2014/2016 UPD: thought that such a thing can be ...
Leonor24 asked March 21st 20 at 13:43
0
answer

MS Analysis periodically rebuilds the indexes. How to track\monitor?

Periodically in terms of analysis cube to Microsoft Analysis Service deals with rebuilding indexes that shifts the computation time of the cube for an hour or two compared to the usual preparation time. Is there a way to track prerequisites to the conversion index or track the fact of starting such a conversion? To keep the...
shaniya.Gutmann asked March 19th 20 at 09:41
1
answer

How to deploy a cube in Analysis Services?

Hello! There is a server which is ms server Analysis services service. Objective: to deploy an olap cube is a multidimensional data project using VS on this server. - From client computers via MSSQL Server Management Studio cannot connect to bdscan this server, but not to Analysis Services! - From client computers via Excel...
colin_Tillman asked March 18th 20 at 20:07
1
answer

How to create a fact table and dimension tables?

The tables from the original DB: n. Navaneetham: attributes. 1. Posts: employee_id (FK), title, took the (date), left (date); 2. Employees: employee_id (PK), datardina, name, surname, gender, hired (date); 3. Departments: idotea (PK), Nathanael; 4. Department-Employee: employee_id (FK), idotea (FK), otata before (date); 5. ...
Neoma_Gislason99 asked March 17th 20 at 12:19
1
answer

Selection business intelligence tools with postgresql?

Good day! In order not to reinvent the wheel, it was decided to use some ready-made system BI to create reports, dashboard, OLAP, and data mining. Sorry, couldn't find the right information online. Requirements are: support of postgresql, linux, work via the web interface and not too high price. Currently trying to work on ...
ashtyn_Block asked October 10th 19 at 11:50
2
answers

MongoDB and OLAP

Required according to available information about the company's customers to perform OLAP processing of data to build reports, use different methods of data mining (to build decision trees, carry out clustering, etc.). I read about mongodb attracts by its simplicity, ability to map/reduce (I think it is easier to build all ...
Lavon.Graham asked October 10th 19 at 05:59
4
answers

What are OLAP systems data clustering in database?

It is necessary in real time to analyze a large number of constantly changing data in multiple tables linked by relationships. I know about Microsoft SQL Server Data Mining algorithms. Has anyone faced similar kind of tasks? What solution can you recommend?
darron.Weima asked October 7th 19 at 19:02
2
answers

[OLAP],[SSAS] report on the new\past clients?

There is a database of trading firms. There is a list of facts of sales of goods to customers (with links to customer, product type, just like in Northwind). On top of this configured a OLAP cube in SSASthrough it managers look there any otchetik. The challenge is to extend the functionality of the reporting system by intr...
annett asked October 3rd 19 at 06:50
3
answers

What are the advantages of data warehouses and OLAP terms of business and information systems?

Hi all. Books on OLAP articulate a standard set of theses, supporting OLAP/XA. For example: - quick analysis (not more than 5 seconds to process). - ensuring the logical/statistical analysis. - multidimensional representation of data (+hierarchy). - you can access data regardless of their volume. etc. But how, in simple wo...
alexandre_Greenfelder asked October 2nd 19 at 14:34