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

What is the difference between cubes and the Unified Dimensional Model (if any)?

I'm currently researching SQL Server 2008 as a business intelligence solution, and currently looking at Analysis Services (and I'm pretty new to business intelligence as a whole...) I'm a bit confused by some of the terms in SSAS, particularly the…
ngm
  • 7,277
  • 1
  • 53
  • 62
3
votes
1 answer

Check if SSAS Cube is available i.e. processed

I am looking for a method to check if a cube is accessable i.e. it is processed and not broken. Example: I got a working cube and i full process a shared dimension so that the cube gets broken. Is there any mdx or xmla method of finding out what…
tuxmania
  • 906
  • 2
  • 9
  • 28
3
votes
2 answers

How many Axis can we use in MDX practically?

I heard about there are around 128 Axis in MDX. AXIS(0) or simply 0 – Columns AXIS(1) or simply 1 – Rows AXIS(2) or simply 2 – Pages AXIS(3) or simply 3 – Sections ………. ………. So far I have used only two of them, Column (0) & Row (1). I am just…
Aditya
  • 2,299
  • 5
  • 32
  • 54
3
votes
2 answers

Model a relationship between two fact tables

I have a Sales fact table, an Orders fact table (both line level detail), and two date roleplaying dimensions (from the Date dimension) for Order Date and Transaction Date. I'm trying to get to a point where you can view sales measures by order date…
Lefty
  • 426
  • 3
  • 10
3
votes
0 answers

Passing Measures as parameters in a Named Set - MDX

I am using SSAS 2012. Lets say I have a date dimension [Date].[Calendar Month].[Month]. I have several measures like [Sales], [Purchases], [Commission] etc. I want to create a Named Set that calculates non-empty months as a Calculated Member in…
Merin Nakarmi
  • 3,148
  • 3
  • 35
  • 42
3
votes
1 answer

icCube with olap4php

We started to build a PHP application to connect to icCube and I want an example for olap4php, because I couldn't find it anywhere in the icCube documentation. In particular, I need the Provider to use in building connection object to icCube. //…
user3086436
  • 41
  • 1
3
votes
4 answers

Get SSAS cube last process time

In Excel I make an Analysis Services connection to a data cube. I would like to be able to show a user how current the data is by showing them when the last cube processing time occurred. Making an analysis services connection to the cube in SQL…
Kyle Weller
  • 2,533
  • 9
  • 35
  • 45
3
votes
1 answer

Sql Server SSAS MDX Query

I have a table, simplified as follows - FactSales: Date Reference Amount TypeId Seller 1/10/2013 A1 100 1 100 3/10/2013 A2 200 1 200 5/10/2013 A1 -100 2 …
TheITGuy
  • 722
  • 4
  • 15
3
votes
1 answer

SSAS - Passing MDX Report Parameter to MDX DataSet Query

In my MDX report based on cube, the input help for date must be a calendar, therefore Date/Time type of parameter is essential. The field in time dimension by which I filter data is Integer. Example value: 20130827. My dataset query looks like…
Artur Chmielewski
  • 43
  • 2
  • 5
3
votes
4 answers

Difference between hierarchy and levels

I have just started working on Mondrian. I am having a hard time understanding hierarchies and levels. What is Difference between a level and a hierarchy of a dimension in a cube ? Why do we need to have level inside a hierarchy while building a…
cjava
  • 656
  • 1
  • 8
  • 22
3
votes
2 answers

MDX Filter by Members

This is more of a general MDX question. I want to filter those dates from the reporting date.fiscal hierarcy. I was previously using a calculated member but I just put it in the query, it doesnt return any results. SELECT { …
uh_big_mike_boi
  • 3,350
  • 4
  • 33
  • 64
3
votes
1 answer

Analysis Service. Performance issue when I process dimension second time

I am working with Analytics app which can build and process DM and Cube. User can select dimensions/attributes/measures/hierarchies they want to see in Cube. My cube loading/processing flow when I first time create and load cube 1) Create DS, DSV,…
Andriy Kuzmych
  • 193
  • 2
  • 11
3
votes
1 answer

Analysis services custom authentication

I have made a web application to a company that provides users to input all invoices their company have paid. The company has departments in all cities and users can only see the data related to their cities. Now I designed an OLAP cube to provide…
facot
  • 221
  • 3
  • 7
  • 12
2
votes
1 answer

Switching to US English msmdsrv.rll Analysis Services

I'm using Analysis Services for a web application I'm building, I have my Analysis Service running, I included a PivotGrid from DevExpress on a web page, I checked on SQLServer that my cube is displaying information, and it does, but when I run my…
Leonardo Raygoza
  • 469
  • 2
  • 5
  • 16
2
votes
1 answer

Date/Time Dimension in Cube

I have a Date Dimension called Dim_Date in my Data Warehouse. Now the issue is that my Date Dimension is only populated till 31st Dec 2011. My cube is built in SSAS. Is there any way I can populate my Date Dim for another 5 years? When I try to…
ace_mccloud
  • 497
  • 1
  • 8
  • 25
1 2 3
…
54 55