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

how can I do OLAP cube incremental processing?

I have one multidimensional OLAP Cube for Sales.But I have huge database.Firstly I done olap cube full processing .But everytime it will do full so it will take lots of time.I have to do incremental processing.But I dont have any expirence for this…
Sezer Erdogan
  • 167
  • 1
  • 9
  • 34
3
votes
1 answer

Filter dimension hierarchically

I have a table that holds categories. Categories can be top-level and independent, or they can be a sub-category: MyCategory MyCategoryId Int -- PK Name Character Varying 50 -- descriptive "Name" of the category ... MyParentCategoryId Int…
Stu
  • 15,675
  • 4
  • 43
  • 74
3
votes
1 answer

How to get back aggregate values across 2 dimensions using Python Cubes?

Situation Using Python 3, Django 1.9, Cubes 1.1, and Postgres 9.5. These are my datatables in pictorial form: The same in text format: Store table ------------------------------ | id | code | address | |-----|------|---------------| | 1 |…
Kim Stacks
  • 10,202
  • 35
  • 151
  • 282
3
votes
1 answer

How to use search in MDX that returns matches from two keywords

I am new to mdx. Is there any way to search and return matches from two keywords using MDX like we use in MySQL using LIKE '%iphone' AND LIKE '%samsung'? My MDXcode is: SELECT NON EMPTY {[Measures].[Average Price]} ON COLUMNS, Filter({[Product…
MidhunKrishna
  • 611
  • 7
  • 18
3
votes
1 answer

OrientDB and OLAP?

What is the status of OrientDB support for higher level structures such as cube cells, dimensions, OLAP/BI in general? Analytical functions/window functions? These are common in high-end databases (Oracle, MSSQL, Postgres). Thanks.
Hristo Stoyanov
  • 1,508
  • 3
  • 15
  • 24
3
votes
1 answer

Partition and process SSAS cube for huge data

I've a SSAS cube with rigid relationship. Daily I get data from source for last 2 months only. My cube have data since 2010 onwards. I am planning to partition that cube and then process it. My questions are I know that in rigid relationship I've…
Zerotoinfinity
  • 6,290
  • 32
  • 130
  • 206
3
votes
2 answers

Non aggregate measure in cube

I have a FactTable with Flag, this flag is to differentiate records and its of boolean datatype. I have to get this field in the cube. I have created non aggregatable measure for this flag, but it shows blank/null when cube is browsed. I do not want…
Harsha
  • 113
  • 9
3
votes
1 answer

Microsoft SSAS OLAP Connection from Java Code

I am new to the concept of OLAP DB. Please excuse me if I missed out something in the Connection String. I am trying to connect to connect to Microsoft Analysis Server(which is in different Domain) from my System. While Connecting I am getting below…
siddhartha chakraborty
  • 425
  • 1
  • 5
  • 12
3
votes
1 answer

MDX How do you create a variance and variance % in a report

Using AdventureWorksDW2008R I have the following DataSet SELECT NON EMPTY { [Measures].[Sales Amount], [Measures].[Total Product Cost], [Measures].[Internet Sales Count] } ON COLUMNS, NON EMPTY { ([Order Date].[Calendar Year].[Calendar…
John
  • 275
  • 1
  • 4
  • 14
3
votes
1 answer

Many-to-Many-to-Many Relationship in SQL Server Analysis Services; Second Many-to-Many Relationship Not Working

Preface SQL Server 2008 R2 Standard Edition, Multidimensional Cube In my data warehouse I have the following tables: Dimensions DimPartnership - Groupings of Partners DimPartner - Groupings of Investors (can be in multiple partnerships) DimInvestor…
Michael
  • 1,556
  • 13
  • 25
3
votes
1 answer

How to slice a data cube in Birt designer?

I created a data cube in Birt designer with the following data : Measure : turnover Dimensions : product, location and time I have now a three-dimensional OLAP data cube I want to display in a two-dimensional array. My problem here is I don't…
JFX
  • 33
  • 5
3
votes
1 answer

How to get Dimension Breadcrumb in Excel pulling from Microsoft SSAS

TL;DR: How can I enable the option to precede the hierarchy name by the dimension name? I am trying to implement a change that appears in one of the cubes I am working on based on the same dimension in another cube. When a user creates a pivot table…
Gilbrilthor
  • 432
  • 4
  • 14
3
votes
1 answer

Structuring a cube with paths from a fact table to a dimension via two alternative intermediate dimensions

I'm unsure how to configure a cube in SSAS for a complex case that I can simplify as follows: A fact table stores data about a Sale. A dimension called Promotion records details of the marketing activity that generated the Sale A dimension called…
MattClarke
  • 1,647
  • 1
  • 11
  • 32
3
votes
1 answer

Python Cubes Olap Framework Date PointCut

So i am trying to implement some BI with Python Cubes Framework and i am running into some problems. Basically i am trying to do a "simple" PointCut/slice and dice and i am not having any luck with it. I am using a PostgreSQL database with PostGis.…
psychok7
  • 5,373
  • 9
  • 63
  • 101
3
votes
1 answer

How do I get Excel to use Formatted_value in SSAS cube

TL;DR: What (Where) do I need to make changes in order to instruct Excel to use the format string to format the values pulled from the cube? I have a SSAS cube that adds some calculated measures onto an existing user-defined function. On top of…
Gilbrilthor
  • 432
  • 4
  • 14
1 2 3
…
54 55