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

How to make calculate measures faster in SSAS

I have a bunch of calculated measures which I understand are executed only at query time. Unlike the derived measures which are pre-aggregated during cube processing time and thereby giving a better query performance the calculated measures aren't…
user330612
  • 2,189
  • 7
  • 33
  • 64
0
votes
2 answers

How to filter a measure based on another measure

I have a dimension table called DimUser that has 1 row per user. I have a measure based on this dimension called "USER COUNT" which is count of rows of the DimUser table. I also have a calculated measure called "ACTIVE DAYS" which returns no of days…
user330612
  • 2,189
  • 7
  • 33
  • 64
0
votes
1 answer

Change Dates to numbers

This is the script: SELECT {[Measures].[Internet Order Count]} ON COLUMNS ,Descendants ( [Date].[Calendar].[Month].[August 2006] ,[Date].[Calendar].[Date] ,self ) ON ROWS FROM [Adventure Works]; It returns this: Can I change the…
whytheq
  • 34,466
  • 65
  • 172
  • 267
0
votes
1 answer

Adding YTD, YTG column to Excel OLAP Pivot

I have an Excel pivot table connecting to an OLAP cube with a report looking something like Jan Feb Mar .........Dec Revenue 55 32 65..........45 I'd like to add extra columns YTD and YTG etc. These are already calculated…
user2999794
  • 13
  • 2
0
votes
0 answers

oalp cube update with IIf in DMX

I need MDX query that will return 1\0 if the cube is up to date. Something like: case when LAST_DATA_UPDATE > now() then 1 else 0 end I have the script that returns currently the 2 arguments but I cannot put them in an IIF statement? Any help would…
Yoni
  • 1
  • 1
0
votes
1 answer

Perform drill across in MDX (SSRS) / joining two fact tables on one conformed dimension

How can I join two fact tables in MDX by means of one conformed dimension? For example (in SQL) I have 2 fact tables: shipment_facts, return_facts and one common dimension product, it would be: SELECT COALESCE (shp.product, rtn.product) as…
Yeti
  • 13
  • 3
0
votes
1 answer

HEAD function inside aggregation function SUM

How do I change this script so that HEAD is not inside the aggregation function SUM? The reason I'd like to do this is that I'm being warned that: Function 'Head' was used inside aggregation function - this disables block computation mode WITH …
whytheq
  • 34,466
  • 65
  • 172
  • 267
0
votes
2 answers

Using a Dimension Property as a Measure

In my product dimension, I have an attribute called CustomerRating which is a string. Possible values are "1", "2", "3", and "4". I want to turn this attribute into a Measure that averages ratings for collections of products. with member…
John G
  • 3
  • 2
0
votes
2 answers

Calculation in SSAS Cube not working for zero data values

I am working with a SSAS 2008 R2 cube and interrogating the data through Excel 2010. In the cube I have a calculation to conditionally format the data. The logic is if a measure contains a specific value for the fact being viewed, then the fact…
Greg the Incredulous
  • 1,676
  • 4
  • 29
  • 42
0
votes
1 answer

Ordered Set is ordered in slicer but not ON ROWS

We have this named set: CREATE SET CURRENTCUBE.[Geography Alphabetical] as { ORDER( [Geolocation].[Geography].[Geography Country].MEMBERS, [Geolocation].[Geography].CURRENTMEMBER.NAME,BASC) }, DISPLAY_FOLDER = 'Geography Sets'; If we pull this…
whytheq
  • 34,466
  • 65
  • 172
  • 267
0
votes
1 answer

[Measures].[First4Days] for each month ON ROWS

How do I replace the following placeholder with a measure that returns the sum of the [Measures].[Internet Sales Amount] for the first 4 days of each month that are on the rows? WITH MEMBER [Measures].[First4Days] AS SUM(1)…
whytheq
  • 34,466
  • 65
  • 172
  • 267
0
votes
1 answer

Previous Equivalent MTD Across Multiple Months

If today's date is 11 July 2008 then the MTD sum is for the range {01 July 2008 - 11 July 2008}. The previous equivalent MTD period in June is {01 June 2008 - 11 June 2008}. The previous equivalent MTD period in May is {01 May 2008 - 11 May 2008}. I…
whytheq
  • 34,466
  • 65
  • 172
  • 267
0
votes
0 answers

Multiple referenced dimensions using same intermediate dimension

SQL Server 2008 R2 I've got a fact table that links to a dimension. That dimension has multiple date_ids for different dates, start, end etc. So in the dimension usage screen there are various incarnations of the date dimension linked to the…
nickb
  • 1
  • 3
0
votes
2 answers

Denormalization database

I was taking a look at Star Schema Benchmark and then I was thinking is it possible to denormalize all tables from the SSB? So database size will increase a lot but potentially the performance will grow up. Is that right? Is it possible? Thanks and…
p.magalhaes
  • 7,595
  • 10
  • 53
  • 108
0
votes
1 answer

Mondrian Schema uniqueMembers

I am using Mondrian with Pentaho and Saiku to do OLAP analysis on a MySQL database. I have a data warehouse with 2 dimensions (beneficiary and member) linking to a fact table. Beneficiary has the following fields: beneficiary_type1,…
BOENDAGGER
  • 423
  • 5
  • 21
1 2 3
…
99 100