Stack Overflow
Stack Overflow

Questions tagged [olap]

Online Analytical Processing (OLAP) is a category of software tools that provides analysis of data stored in a database, optimized for querying and reporting. OLAP tools enable users to analyze different dimensions of multidimensional data stored for rapid access. For example, it provides time series and trend analysis views.

Online analytical processing (OLAP) is an approach to swiftly answer multi-dimensional analytical (MDA) queries. OLAP is part of the broader category of business intelligence, which also encompasses relational reporting and data mining.

The term OLAP was created as a slight modification of the traditional database term OLTP (Online Transaction Processing). OLAP is a technology that is optimized for querying and reporting, instead of transaction processing. The source data for OLAP is Online Transactional Processing (OLTP) databases that are commonly stored in data warehouses. OLAP data is derived from this historical data, and aggregated into structures that permit sophisticated analysis.

OLAP technologies are used for organizing large business databases and support business intelligence. The OLAP databases are divided into one or more cubes designed the way data is retrieved and analyzed.

Business Intelligence and OLAP

Business Intelligence(BI) helps the business to see the big picture based on the aggregated data, broken down on by any number of variables. Business Intelligence extracts data from OLAP and then analyze it. In this way the business can answer questions like "How do the total sales of all products for 2007 compare with the total sales from 2006?".

References:

1686 questions
0
votes
2 answers

Mondrian Rollup Total with a dimension

I want mondrian to rollup as per my dimension table. For example fact_table(id int, dim_id) 1 2 2 2 3 1 4 3 dimension_table( dim_id, value) 1 first_value 2 second_value The last value in fact_table is delibrately not in the list of…
jaipster
  • 11,967
  • 2
  • 21
  • 24
0
votes
1 answer

Microsoft OLAP based DW Solution

We are trying to build a data warehouse prototype and we are architecting in the below way Source - > Staging DW (via ETL) -> Prod DW (via ETL) -> OLAP Cube (SSAS) -> BI Tool In the past when I have worked on other warehouses, the BI tool usually…
Bond
  • 1
0
votes
1 answer

Send Excel file to customer with OLAP connection

Is there a way to send an Excel file with OLAP (SSAS) data to a client and hide the OLAP fieldlist? We tried to copy/paste the data to another Excel file but we loose the layout by doing this. Maybe there's a better way?
Ronald Kraijesteijn
  • 5
  • 5
0
votes
1 answer

Which one is correct to retrieve the data using the MDX query?

For example, I am interested in [Measures].[Internet Sales Amount] in the intersection with [Geography].[All Geographies].[Canada].[Alberta] and [Product].[Product Categories].[All Products].[Accessories], I use the MDX query below to get the…
injoy
  • 3,993
  • 10
  • 40
  • 69
0
votes
1 answer

Group by months in a time hierarchy using MDX

I have a dimension with the following levels: Years Months Days I want to get some data by months regardless of the year, i.e. weddings in January. If I have: January 2011 - 43 January 2012 - 20 January 2013 - 30 What I want is: January - 93 Is it…
vjsp
  • 1
  • 1
0
votes
1 answer

SSAS custom group by query

My fact table looks like this yesterday a yesterday a yesterday a yesterday b yesterday b yesterday c today a today a today b today b tommorow a tommorow a tommorow c tommorow d In the end I need an Excel report like this …
Michal Sznajder
  • 9,338
  • 4
  • 44
  • 62
0
votes
1 answer

Inserting values from two different tables into another in MySQL

I want to fill one of my tables with values form two different tables (it's going to be a dimension for my OLAP cube). So I have tables Birth_Act ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, citizen_id INT, birth_date DATETIME, place…
Bes Sa
  • 83
  • 1
  • 3
  • 13
0
votes
1 answer

calculating the difference of the same measure with a 'different definition' in MDX

I want to calculate the difference of the same measure but with a 'different definition' This is what I tried but it doesn't work: WITH MEMBER [Measures].[Births] AS '[Measures].[type], [dimType].[TypeL].[Births]' MEMBER [Measures].[Deaths] AS…
Bes Sa
  • 83
  • 1
  • 3
  • 13
0
votes
1 answer

designing Olap cube dimensions and facts for population growth cube

I want to create an Olap cube for Population Growth. I have a MySQL database with table: Act ( id INT NOT NULL AUTO_INCREMENT, birth_date DATETIME, death_date DATETIME, place VARCHAR(20) ); and I want it to be my dimension for table…
Bes Sa
  • 83
  • 1
  • 3
  • 13
0
votes
1 answer

Combining three EXISTS

How do we get the intersection of the following three sets? //A SELECT {} ON 0, EXISTS( [Customer].[Customer].[Customer].MEMBERS , {[Product].[Product Categories].[Category].&[1]} , "Internet Sales") ON 1 FROM [Adventure…
whytheq
  • 34,466
  • 65
  • 172
  • 267
0
votes
1 answer

SSAS: distribution of measures over percentage

I am running a SSAS cube that stores facts of HTTP requests. The is a column "Time Taken" that stores the milliseconds a particular HTTP request took. Like... RequestID Time Taken -------------------------- 1 0 2 10 3 …
Alex
  • 1,997
  • 1
  • 16
  • 31
0
votes
1 answer

SSAS - "Count" measure with multiple members

I am new to SSAS and I'm having some trouble with a "count of rows" measure. I'm doing this all with named queries from a MySQL database and have created two logical tables in my DSV. The first table is called "Person" and has a primary key of…
SeeBeeOss
  • 79
  • 11
0
votes
2 answers

Second Ordered set is not ordered

In an Excel OLAP Pivot I have the following custom set called "EventsOrdered": ORDER( {[DimensionEvents].[Events].[Event].members}, SUM ( TAIL([Date].[Date - Calendar Month].[Calendar Month].members, 12), …
whytheq
  • 34,466
  • 65
  • 172
  • 267
0
votes
1 answer

No such tuple on axis 0 error on iReport

How can I get measures value on iReport? select [Reg].[region].Children * { [measures].[mtot], [measures].[wtot] } on columns, [Title].[titlekhas].Children on rows from report1 There is my MDX query. I have try add fields on…
newbie
  • 61
  • 2
  • 10
0
votes
1 answer

MDX sorting by dimension (string) value

I am trying to write an MDX query which selects top 100 rows by dimension or measure value. Fragment on a query NonEmpty([Domain].[Domain].[Domain].Members , { [Measures].[Total - Domains] } ) I can use topcount and get top 100 rows by…
johnc
  • 1
  • 2
1 2 3
…
99
100