Stack Overflow
Stack Overflow

Questions tagged [olap-cube]

An OLAP cube is a multidimensional database that is optimized for data warehouse and online analytical processing (OLAP) applications.

An OLAP cube is a multidimensional database that is optimized for data warehouse and online analytical processing (OLAP) applications.

An OLAP cube is a method of storing data in a multidimensional form, generally for reporting purposes. In OLAP cubes, data (measures) are categorized by dimensions. OLAP cubes are often pre-summarized across dimensions to drastically improve query time over relational databases. The query language used to interact and perform tasks with OLAP cubes is multidimensional expressions (MDX). The MDX language was originally developed by Microsoft in the late 1990s, and has been adopted by many other vendors of multidimensional databases.

820 questions
0
votes
2 answers

SCD type 2 with parent-child hierarchy aggregation issue

We have a staff dimension that has a self-reference for managers (Parent-Child relationship) that we built the hierarchy on it. DimStaff table: | SurrogateKey | BusinessKey | Employee Name | ManagerBusinessKey | StartDate | EndDate | | 1…
GoodHeartedOne
  • 95
  • 7
0
votes
0 answers

Excel MDX - Count of dates selected in slicer

I'm using Excel to connect to an OLAP cube and building a report to show actual hours charged to a project. I need to create a measure now to perform some calculation on the actual hours for which I need to get the number of days that the user is…
Predator
  • 469
  • 2
  • 6
  • 20
0
votes
2 answers

SSAS CUBE Calculated member based on different members in dimension and different measures

I am new to SSAS, I am creating a cube and I need to have a calculated member.The complexity is I have property name as one dimension which has members like "a,b,c,d". Each of this member will be having one value per date in a measure called…
kannan
  • 87
  • 8
0
votes
1 answer

How do I access these xml files from some other machine?

I need to access the cubes through olap4j API in java application. XML cubes files will be available in some other IP server. For Example, XML files will be in 192.168.1.1 IP and C:\Program Files\Apache Software Foundation\Tomcat…
user3027299
  • 217
  • 1
  • 4
  • 7
0
votes
2 answers

MDX Create Member using dimension filters

I am trying to create a measure in MDX cube with dimension filters. The below code works. CREATE MEMBER CURRENTCUBE.[Measures].[SOda] AS ( [Measure].[SOda_pre], [Case].[Outage Cause].&[CustomerA], [Case.[SO Filter].&[1] ) When I add…
user3358114
  • 1
0
votes
1 answer

Creation of offline cubes from pivot table[Automation]

I have a pivot table on which i can slice data based on 3 different users so i create the offline cube for each of them independently using Analyse->OLAP Tools->Offline OLAP. So i need to repeat this process 3 times since at one time i only select…
rnjai
  • 1,065
  • 2
  • 17
  • 32
0
votes
2 answers

How to display 0 instead of empty cell when browsing a cube in ssas without using mdx?

I need to display 0 instead of empty cell when browsing a cube in excel. I used mdx functions like: IIF(ISEMPTY(Measure) = True , 0, Measure) but, i don't like this solution. I need to find, if there is another solution more simple than this one. If…
user3296310
  • 1
  • 1
  • 4
0
votes
2 answers

Insert Transactional Data to Cube

I am new to the data warehouse and currently working on this project. Is there any way to insert new data transactional to existing cube? With tools or with MDX query maybe?
Baroque
  • 3
  • 2
0
votes
1 answer

Are attributes of a dimension in hierarchical order?

Do the different 'attributes' of a dimension of an OLAP cube have to have a hierarchical order? If not, would the corresponding cube store the results for each possible combination of the dimension attributes? Let us assume a cube with only two…
ateich
  • 203
  • 3
  • 5
  • 16
0
votes
1 answer

Linking time dimension with fact table

I'm trying to add a time dimension in BIDS 2008, creating it does fine, but I can't seem to link it to my fact table. The fact table has a field name openDate which is a DATE field (not NULL), in the dimension usage tab I add it and define a regular…
R X
  • 281
  • 2
  • 11
0
votes
1 answer

Get PowerView to work with existing cubes on SQL Server 2008 R2

I've been doing some research into the setup required to get PowerView to connect to existing cubes sitting on a SQL Server 2008 R2 instance. Can anyone confirm that the following is right (or correct me if I'm wrong)? I believe I need the…
hello-klol
  • 735
  • 10
  • 20
0
votes
1 answer

Simple query conversion from sql to mdx

select MAX(InsertionDT),TaskStatus,tasksubstatus from TransTasksFFMS_GVT where TaskCode = 323155 group by TaskStatus,tasksubstatus To use this query in the cube browser I have created a name query and used it as a dimension and it…
Farah
  • 55
  • 10
0
votes
1 answer

How to get around SQL Server Analysis Services 2 billion distinct value limitation on a column

What is a best practice to get around SSAS 2 billion distinct value limitation on a column. My data set grows by 2 billions rows every 10 month and one of the measures in the cube is a row count that runs on the PK. Because adding partitions does…
ack
  • 31
  • 8
0
votes
3 answers

OLE DB error: OLE DB or ODBC error: Login failed for user 'JOE-PC\SQLAnalysis'

I am learning how to create Data Warehouse. I am following to this tutorial. I have created database in SQL Server. In BIDS, I have added that database as datasource. Then added data source view. Then cube with its dimensions. Created hierarchy as…
Joe Richard
  • 1,520
  • 7
  • 20
  • 31
0
votes
0 answers

Indexing Fact table - suggestions

Alright, my fact table is about 40m rows big and has a total of 6 foreign key columns and one timestamp column. Three Dimensionsens are 100.000 to 200.000 (i.e. Customer) rows big, one ~20.000 and the other two ~3.000. Now I am looking on a good way…
user2428207
  • 825
  • 4
  • 16
  • 29
1 2 3
…
54 55