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
1 answer

Why doesn't my second "Rows" field roll up into the first in PivotTable?

I'm developing a cube, and using PivotTable to play with said cube. I have this issue and I don't know if I'm seeing this because: This is just the way it is, or I'm missing something in my cube relationships, or I'm missing something in excel. I…
user992228
  • 39
  • 1
  • 1
  • 4
0
votes
1 answer

Change viewing quarters in visual Business Intelligence Projects

I have Business Intelligence Projects project in VS. I create cube, and when I'm browsing data and generate raports I have quarters in format 1,2,3,4. I want to show quarters in format Q1, Q2, ... When I'm changing quarter format I still get quaters…
Mr Jedi
  • 33,658
  • 8
  • 30
  • 40
0
votes
1 answer

Real time analytics with cassandra

I watched this video on doing analystics with cassandra. I was pretty interested in the segment from 12.10 to 15.10 I didn't understand the last row key Θ , what did it signify. And given that all row keys are the where clauses and all cf are groub…
S Kr
  • 1,831
  • 2
  • 25
  • 50
0
votes
1 answer

How get org.olap4j.metadata.Cube from Mondrian OlapConnection

I develop the web application with Mondrian OLAP engine with Olap4j and should present/display data to user. From Java code i create OlapConnection and try get all cubes from database. OlapConnection c = (OlapConnection)…
kidar2
  • 124
  • 4
  • 14
0
votes
2 answers

MDX Inner Join returns duplicate rows and inflates measures

I have two tables in my cube that I am joining on by ZIP but end up with duplicate records because there are multiple rows per ZIP. TABLE_A ZIP CATEGORY TYPE VALUE90 VALUE75 33211 TOYS TRAINS GT LT 33211 TOYS …
tcash21
  • 4,880
  • 4
  • 32
  • 39
0
votes
1 answer

how to apply an aggregation function over a measure dynamically passed to a stored procedure?

I am trying to do spit by dimension on an analytic view within a stored procedure, and I want to pass the measure on which I will apply the aggregation function dynamically. So I did the following: create procedure procHO (in currentMeasure…
Mohamed Ali JAMAOUI
  • 14,275
  • 14
  • 73
  • 117
0
votes
1 answer

Distinct Values in OLAP Cube Pivot Table

I regularly interact with massive OLAP based Pivot Tables. Usually these are more or less undocumented. And thus they are difficult to really wrap my head around and use effectively. One of my strategies for learning what data is being presented is…
Tom M.
  • 139
  • 1
  • 2
  • 10
0
votes
1 answer

Select average sales count over 3 month period in MDX

I have a problem with the following query: Month to month comparison. Compare the sales of a current month with three other numbers: a. The previous month. b. The average of the previous three months. c. The average of the three month…
thewikus
  • 445
  • 1
  • 5
  • 16
0
votes
1 answer

how to join more than two mdx queries

i need two join 6 queries in mdx which are fetching result from olap cube . problem is that all queries have different where condition and i want to join them on the basis of rows. the query is WITH MEMBER MEASURES.CONSTANTVALUE AS 0 SELECT…
user407269
  • 763
  • 2
  • 6
  • 8
0
votes
1 answer

Dynamic OLAPCube Flex

I'm trying to push data into an OLAPCube in flex. The data coming in is flat and nothing else is known before hand. How do I have flex automatically create dimensions and such so that I can bind something to the cube? Using a flex chart, it's as…
user208148
0
votes
1 answer

Need Assistance in selecting a service to take data from SSAS

I have a project coming up, and we need a service which can talk to SSAS to bring the data to the front end. After some research initially SSRS was selected , but then SSRS is limited to only IE browser. Could any one of you please let me know…
Vidya
  • 126
  • 2
  • 4
  • 16
0
votes
0 answers

Local Cube - Is there a reason to use OLTP's grain?

I am building a local OLAP cube based on data gathered from several OLTP sources. Please note that I am doing this programmatically and do not have access to tools like SSAS or MDX-based tools. My requirements are somewhat different than the…
JAGAnalyst
  • 320
  • 1
  • 2
  • 10
0
votes
1 answer

How can i create and use generic calculation for statistical function Stdev ?

How can create generic calculated member which i can reuse in order to calculate the statistical deviation on any logical related dimension(s) and measurement ? I need to be able to select any dimension and measure. I found related discussion here…
dferidarov
  • 602
  • 4
  • 15
0
votes
1 answer

How does declaring the hierarchy and level in SSAS help to improve MDX Query performance?

I use SSAS in SQL Server 2008 R2 and I'm reading the book Professional Microsoft SQL Server Analysis Services 2008 with MDX Wrox Programmer to Programmer. In chapter 5 on page 132 it says that declaring "hierarchies and level" is better for query…
Ardalan Shahgholi
  • 11,967
  • 21
  • 108
  • 144
0
votes
1 answer

Is using Views with SQL Join Queries in OLAP Cube a good practice?

I'm trying to create my first olap cube schema for Mondrian server. I came up with creating a view as a fact table with several joins to put foreign keys into it, let's say it looks like this: SELECT call.id, record.user, topic.id, session.id,…
user2659701
1 2 3
…
54 55