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
2
votes
2 answers

MDX: Filtering repeated

I would like to write an MDX query that only show values when a specific repeated dimesions are repeatid more tha one. That is my mdx query: SELECT NON EMPTY { [Measures].[Value] } ON COLUMNS, NON EMPTY { ([Dim Result].[Sample Number].[Sample…
Ibon
  • 41
  • 5
2
votes
1 answer

(SQL Server Analysis Services) MDX query to get immediate parent?

Desired result When a cube is deployed and browsed, I wish to see only an immediate manager of an employee. The cube result shows all managers of a paticular employee, like below: Abbas, Sanchez, 825 Abbas, Welcker, 825 Abbas, Abbas, 825` I…
user4296898
2
votes
1 answer

Multiple Joins from one Dimension Table to single Fact table

I have a fact table that has 4 date columns CreatedDate, LoginDate, ActiveDate and EngagedDate. I have a dimension table called DimDate whose primary key can be used as foreign key for all the 4 date columns in fact table. So the model looks like…
user330612
  • 2,189
  • 7
  • 33
  • 64
2
votes
1 answer

Sort Olap cube by totals

I have an Olap pivot. I tried sorting by smallest to largest of 2014 Total. It works fine for the first measure values (Gross Written Premium GWP). But if I try to sort the next one (Gross Earned Premium GEP), the sorting for GWP revert to the…
gemmo
  • 1,286
  • 2
  • 16
  • 33
2
votes
1 answer

Conditional Color formatting in SSAS Cube

I have a star schema with a fact table containing the following: ID BIGINT IDENTITY, FK_Dimension1 BIGINT, FK_Dimension2 BIGINT, dataValue NUMERIC(20, 8), classification NVARCHAR(20) The classification defines the security…
Greg the Incredulous
  • 1,676
  • 4
  • 29
  • 42
2
votes
3 answers

Create member with description in MDX

This is a pretty straight forward question that may or may not be possible but, when you create a measure in a SSAS 2005 cube, there is a description property which can be set, which we've been using in the client application that consumes the…
Dan Kennedy
  • 800
  • 1
  • 6
  • 13
2
votes
1 answer

What is the best partitioning strategy for multiple distinct count measures in a cube

I have a cube that has a fact table with a month's worth of data. The fact table is 1.5 billion rows. Fact table contains the following columns { DateKey,UserKey,ActionKey, ClientKey, ActionCount } . The fact table contains one row per user per…
user330612
  • 2,189
  • 7
  • 33
  • 64
2
votes
4 answers

In SQL Server Business Intelligence, why would I create a report model from an OLAP cube?

In Business Intelligence Developer Studio, I'm wondering why one would want to create a report model from an OLAP cube. As far as I understand it, OLAP cubes and report models are both business-oriented views of underlying structures (usually…
ngm
  • 7,277
  • 1
  • 53
  • 62
2
votes
1 answer

Unbalanced hierarchy referencing same Attribute

I'm planning to create a dimension Location in my existing cube, based on a production database. The problem is that this database consists of a hierarchy with a selfreferencing object, a table called locations: +----+----------+------------+ | id |…
Menno
  • 12,175
  • 14
  • 56
  • 88
2
votes
2 answers

How to process SSAS cube structures concurrently from PowerShell script using Mircrosoft.AnalysisServices namespace

TL;DR: Is there a way for a PowerShell script calling Microsoft.AnalysisServices functions to process multiple cube structures concurrently? I have a Microsoft SSAS cube that needs several measure groups processed before the rest of the cube is…
Gilbrilthor
  • 432
  • 4
  • 14
2
votes
3 answers

Unit Testing SQL Server OLAP Cubes Using C#

I have a SSAS cube which needs to be tested. I want to insert some values into my test database and then trigger cube to be processed on my test database and then write tests again dimensions/measures and cube itself based on the values inserted…
Sandra
  • 63
  • 3
  • 14
2
votes
1 answer

SSAS - Many to many bridge table with queryable dimension attribute

I'm working on a scenario where I have a bridge fact table joining two dimensions, but the bridge table also has data that I would like to be able to use as an attribute in my query. I believe essentially what needs to happen is for the bridge…
skaaks
  • 153
  • 1
  • 7
2
votes
1 answer

Error while processing the cube: There is not enough space on the disk

I am getting following error while processing SSAS cube using powershell script. Error is "There is not enough space on the disk." However there is 2 TB memory allocated on the server and the estimated cube size is not more than 8 GB. Can some one…
lch
  • 193
  • 1
  • 10
  • 20
2
votes
2 answers

When do i need to process a cube?

I have a SSAS 2008 Cube. I've just inserted some more data (4 million transactions) in to the fact table and the dimensions are still good too. I've accidentally refreshed my Excel pivot table and noticed that my new data is there - I thought I had…
Warren
  • 1,984
  • 3
  • 29
  • 60
2
votes
1 answer

Creating a new cube with Saiku plugin on Pentaho

I have installed Pentaho Community Edition 5.0.1 and successfully created a new data source from a MySQL database (both hosted on my PC).I now want to perform OLAP analysis on this data, but am not entirely sure how to proceed (So please provide…
BOENDAGGER
  • 423
  • 5
  • 21
1 2 3
…
54 55