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
5
votes
0 answers

Dimensional modeling for dynamic tree relational structures

I am planning to render a database which relates several nodes parenthood in an E/R fashion as an OLAP cube. My model contemplates a tree which needs to be dynamic, configurable. In order to end up with a dimensional representation of the database,…
Whimusical
  • 6,401
  • 11
  • 62
  • 105
5
votes
1 answer

Filtering MDX query with current year & month using Now()

How can I filter data in MDX with current Year & Month? What I did so far is: WHERE strtomember{ [Time Dim].[FSCL YEAR].&["+Format(now(), "yyyy")+"], [Time Dim].[FSCL MONTH].&["+Format(now(), "m")+"] } but it is not working.
Aditya
  • 2,299
  • 5
  • 32
  • 54
4
votes
3 answers

Optimize top N queries

I am facing a hard time optimizing a query like SELECT RESULT_ID FROM RESULTS WHERE SOURCE = 1 AND GROUP=2 AND SCORE1 BETWEEN 20 AND 100 ORDER BY SCORE2 LIMIT 450; on a 40 million rows innodb table. The query may have to sort upto 15 million…
Prince
  • 145
  • 1
  • 7
4
votes
3 answers

How to calculate the likely size of an OLAP cube

Does anyone know a method to use to get a rough size of an OLAP cube based on a star schema data warehouse. Something based on the number of dimensions, the number of records in the dimension tables and the number of fact records and finally the…
NER1808
  • 1,829
  • 2
  • 33
  • 45
4
votes
1 answer

Multiple member mdx query returns error (permission to access the specified member)

I want to mention that I'm new to SSAS and MDX. In the past several days I've been dwelling with an excel generated query that errors out. The problem is that a query is generated by excel when trying to read data from an online cube data source…
lerys
  • 61
  • 1
  • 5
4
votes
1 answer

SSAS processing fails when attribute value duplicated (which is actually okay)

This has been an issue with SSAS since forever, but it's been a pain and I don't understand why it happens. On the first build of a cube, I will get an error like the following: Errors in the OLAP storage engine: A duplicate attribute key has been…
Curt
  • 5,518
  • 1
  • 21
  • 35
4
votes
1 answer

Obtaining data with mysql or R of a MSOLAP provider

I have an OLAP cube in excel with a MSOLAP but queries are too slow, so I would like to connect me from mysql or R. I have the following connection properties: Provider=MSOLAP.4;Persist Security Info=True;User ID=anuser;Initial…
Yaneth Gil
  • 61
  • 6
4
votes
3 answers

SSAS measure value aggregate error

I have a Fact table with the following rows When I process my cube I want results like this : However when procession my cube I get the following results: I have fee rate (hourly rate) as a measure but it is summing the values when LineID is the…
evoandy
  • 630
  • 4
  • 16
  • 31
4
votes
1 answer

Time dimension not working in SQL Server Analysis Services

My fact table has a "Date" column that I have used as a foreign key to the Time Dimension table I used SSAS to create for me in the datasource. However when I deploy the cube and browse it, adding the time dimension attributes or any of its…
Cranialsurge
  • 6,104
  • 7
  • 40
  • 39
4
votes
3 answers

XML parsing failed at line 1, column 9: DTD is prohibited

I have configured HTTP access for SQL Analysis server as stated in below article, https://technet.microsoft.com/en-us/library/gg492140(v=sql.105).aspx Finally I have configured the msmdpump.dll for my SQL Analysis service, and i am trying to load…
Pranath
  • 321
  • 1
  • 4
  • 13
4
votes
1 answer

Connecting to Analysis Services from R or Nodejs

I am trying to connect Analysis services from either through R or Nodejs. For R, I have found the following library: https://github.com/overcoil/X4R For Nodejs, I have found the following library: https://github.com/rpbouman/xmla4js Analysis…
user3057556
  • 141
  • 2
  • 9
4
votes
2 answers

Merge 2 facts in cube?

Is it possible to merge 2 facts tables to create a cube in a Mondrian schema example the case of sales and cost ?
Fierto
  • 59
  • 6
4
votes
3 answers

Star schema [fact 1:n dimension]...how?

I am a newcomer to data warehouses and have what I hope is an easy question about building a star schema: If I have a fact table where a fact record naturally has a one-to-many relationship with a single dimension, how can a star schema be modeled…
Mike Gates
  • 1,874
  • 3
  • 21
  • 40
4
votes
4 answers

SSAS Cube reprocessing fails - then succeeds if I try again

So I'm basically brand new to the concept of BI, and I've inherited an existing ETL process that is a two step process: Loads the data into a database that is only used by the cube processing Starts off the SSAS cube processing against said…
EdgarVerona
  • 1,488
  • 1
  • 15
  • 23
4
votes
2 answers

mondrian.xml schema files pentaho location

I'm creating cubes (xml schemas) via schema-workbench or ivy schema editor. When I'm publishing it, I would like to know where the schemas (mondrian.xml files) are actually saved,What is the location of these files? Thanks,
matlabit
  • 838
  • 2
  • 13
  • 31
1
2
3
…
54 55