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
1 answer

How to make a calculated member in MDX for SSAS?

I have a problem in my calculation and can't solve. Example: Our company sells about 100 products, divided into categories and product ID. Product ID is the smallest granularity. I need to show how this product list we sell in each city. See the…
Lucas Motta
  • 135
  • 2
  • 11
0
votes
1 answer

How to filter out rows from a pivot table built from a cube, based on the value of a measure

I have a Pivot table built from a SSAS cube. I visualize 1 measure and aggregate it by dimension 1 on rows. Let's say i get 20 rows, each with its own value. I want to see only those rows with the TOP 5 values. How can I do this with Excel 2013…
Johannes Wentu
  • 931
  • 1
  • 14
  • 28
0
votes
1 answer

Is it possible to create an efficient UDF alternative to Excel's CUBEVALUE function?

We'd like to create a simpler alternative to Excel's CUBEVALUE function for retrieving data from an OLAP server. The details aren't critical, but briefly, our function will "know" the source connection and accept a very simple ticker-like parameter…
bright
  • 4,700
  • 1
  • 34
  • 59
0
votes
1 answer

Creating a calculated member containing the number of years between two dates

I have a cube with two dates - Date of Birth and Date of Purchase. I would like to create a calculated member which produces the age in years based on these two dates. I can already do this in the dataset once the query has been run however I would…
user3644997
  • 89
  • 1
  • 9
0
votes
1 answer

Execution order of crossjoined hierarchies

If I create a set of tuples via the following crossjoin which hierarchy is joined to which first? hierA * hierB * hierC If I know that the count of non empty members in A and B are significantly less than the count of members in C then should this…
whytheq
  • 34,466
  • 65
  • 172
  • 267
0
votes
2 answers

Limiting date range using Filter

Without using the colon operator how do I filter the set AllDates to just 05Jan2005 to 10Jan2006? WITH SET [AllDates] AS [Date].[Date].[Date].MEMBERS MEMBER [Measures].[DTkey] AS [Date].[Date].CurrentMember.Member_Key MEMBER…
whytheq
  • 34,466
  • 65
  • 172
  • 267
0
votes
2 answers

Calculating total Amount of Internet Sales (AdventureWorks data) MDX

How can I count the total number of sales in the "FactInternetSales" table for the selected member of the DATES hierarchy? ( [Order Date].[DATES].CURRENTMEMBER, COUNT(DISTINCT([Fact Internet Sales].[Sales Order Number].[Sales Order Number] ) this…
Vil
  • 135
  • 1
  • 2
  • 12
0
votes
1 answer

Requirements on Time dimension to enable YTD operators

I am looking for references that can answer the following two questions: Does YTD work for all versions of Mondrian? What are the requirements on the Mondrian and physical schema to enable the YTD operator in MDX queries?
Forward
  • 9
  • 2
0
votes
1 answer

Data Warehousing - OLAP operations

I would like to know how to find the standard deviation of final scores from a Data warehouse (represented by a schema) representing a universities gradebook using OLAP Operations (slicing,drilling), I cannot post the image for the schema because I…
user3526532
  • 1
  • 1
0
votes
1 answer

Aggregation for calculated members

I'll represent AW prototype of my task to make it easy to reproduce. It's not a real environment. I want to distinct count my products these have no sells, so create calc member: WITH MEMBER [Measures].[Dead products count] AS …
user1464922
  • 371
  • 1
  • 3
  • 10
0
votes
0 answers

Saiku report is exporting to excel with uncorrect values

I've got a problem with exporting saiku reports to excel. For example in saiku I've got a table like this Text1 521 Text2 75 Text3 0 .... And after export to excel it looks like Text1 521.000000123 Text2 75.0000000123 Text3 1.23e-8 Where can be…
Danila Zharenkov
  • 1,720
  • 1
  • 15
  • 27
0
votes
0 answers

OLAP skip level hierarchy

I have cube: and dimention HealthRecord with attributes AppointmentID, CourseID, PatientID. I set NullProcessing = Preserve for CourseID and AppointmentID attributes. I add Patient, Course for him and Appointment in that course. I add HealthRecords…
smg
  • 1,096
  • 2
  • 11
  • 27
0
votes
2 answers

mdx query is taking for more time than sql

i have converted sql analysis to mdx analysis and found that mdx is far more expensive in term of execution time than sql. below is the sql which i am trying to convert to mdx select inc.incident_id,inc.incident_start_time,…
Ranjeet Paswan
  • 111
  • 10
0
votes
1 answer

General way of pointing at All member of a hierarchy

In our cubes it is somewhat hit and miss what the "All" member of each hiearchy is called: For different hierarchies: HierX = [All] HierY = [All Y] HierZ = [All] HierJ = [All Js] So sometimes the cube developer has left the default and other…
whytheq
  • 34,466
  • 65
  • 172
  • 267
0
votes
1 answer

MDX: iif condition on the value of dimension

I have 1 Virtual cube consists of 2 cubes. Example of fact table of 1st cube. id object_id time_id date_id state 1 10 2 1 0 2 11 5 1 0 3 …
Versus
  • 11
  • 1
  • 5
1 2 3
…
99 100