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

SQL: alternatives and substitutions for GROUPING SETS and PIVOT

I've got code like this: SELECT id, YEAR(datek) AS YEAR, COUNT(*) AS NUM FROM Orders GROUP BY GROUPING SETS ( (id, YEAR(datek)), id, YEAR(datek), () ); It gives me this output: 1 NULL 4 2 NULL 11 3 NULL 6 NULL NULL…
Katt
  • 29
  • 10
0
votes
2 answers

currency conversion in olap (script mdx)

Task is in terms of currency. in the cube should remain only two dimensions: initial currency and the final. I think it can be done in this way: SCOPE([Dim Time].[Y-Q-M-D].Members,[Convert Currency].[Member Id].Members,[Source Currency].[Member…
Asia-ami
  • 3
  • 2
0
votes
1 answer

Deployment Failed in SQL Server Data Tools - Business Intelligence Visual Studio 2012

I made an olap cube but unfortunately cannot deploy it. Can somebody tell me why does the deployment failed? I am badly stuck at this and have no experience of working on it before
Haseeb Jadoon
  • 450
  • 6
  • 20
0
votes
1 answer

How to calculate average based on distinct counts in MDX

My SSAS cube has the following fact and dimensions with the columns as shown below FactActivity DateKey, UserKey, ActivityKey, ActivityCount DimDate DateKey, Date, Week, Year DimUser UserKey, UserName, Gender DimActivity ActivityKey, ActivityName I…
user330612
  • 2,189
  • 7
  • 33
  • 64
0
votes
0 answers

How do I calculate the sum of population of a group of city in MDX?

I need to create a Calculation in the SQL Server Data Tools. Imagine that in my OLAP structure I have a City and a Seller Dimensions, and a fact. And in the City Dimension I have a city, a state, and a Population, and this is a Measure in a…
Lucas Motta
  • 135
  • 2
  • 11
0
votes
1 answer

Get difference between first and last measure values in a date range - MDX

I want to get the first value and last value of a selected measure between a specified date range. Example: If I have a query that returns values between 10 Nov and 17 Nov, I want to subtract the value at 17 Nov from the value at 10 Nov. I tried…
Mo T
  • 440
  • 2
  • 9
  • 30
0
votes
1 answer

Arbitrarily picking a dimension to add members to

The following script gives exactly the result I want. It feels like a hack as I've added the custom members VALUE and VALUE_MTD onto the hierarchy [Customer].[Country]. I've chosen this hierarchy arbitrarily - just not used [Measures] or…
whytheq
  • 34,466
  • 65
  • 172
  • 267
0
votes
2 answers

Measure lacking context

I am struggling to force the measure CountTopPromos to be contextual. Currently it is calculating a count of all the tuples in TopX. Against the version of AdWrks that I am running this is 14. How do I force a context, of the current year, onto the…
whytheq
  • 34,466
  • 65
  • 172
  • 267
0
votes
1 answer

MDX Selective Summation for a Normalization Problem

I'm new to MDX and have a problem regarding filtering out values from a summation. We want to perform normalization calculations, specifically a quantity (q) divided by a basis (b) to get an Intensity (I). The formula is fairly simple I=q/b. OUR…
Stin
  • 863
  • 10
  • 13
0
votes
2 answers

MDX queries. How can to solve "IN" in "where" part

I have sql query and i need this query execute in olap cube . select count(distinct mi.id) from [MTD_DEV].[dbo].[MenuItemAttributes] as m inner join [dbo].[MenuItemOlds] as mi on mi.id = m.MenuItemId inner join [dbo].[RestaurantlistItems]…
Andrey Solovyov
  • 3
  • 2
0
votes
1 answer

Mdx Queries calculate Percentage

I have the following msx query to calculate the percentage daily for the current month: with member [Measures].[Percent] as ([Date].[Day].currentmember, [Measures].[Number of Calls]) / ([Date].[Month].currentmember,…
Ali Baghdadi
  • 648
  • 1
  • 5
  • 17
0
votes
1 answer

how create and query a cube olap

how can I create a cube olap with oracle, how load the data from sources tou the dimentions and the fact table in the cube and how can I query this cube within a java Application. thanks for your help
SAIDI Belkacem
  • 338
  • 4
  • 13
0
votes
2 answers

MDX Query, how to select first and last year of an event's period

I have a publications datamart from teachers of my university, I would like to select the list of teachers with how much books they wrote and in period while them publicated the books. Example Teacher - Last Year of pubblication - Number of…
Neo87
  • 63
  • 1
  • 11
0
votes
1 answer

Combine 2 mdx queries

I have 2 MDX queries from the same cube. Both use the same measure but with different time sets (both the time sets are same dimension but different hierarchies). I want to join them in the same table results, so it will present the 2 measures (cut…
Yoni
  • 1
  • 1
0
votes
1 answer

Excel Pivot Table on Analysis Services - Element Name Ordering

If you connect an Excel pivot table to anlysis services, the Dimension in the field list show all their available attributes (that then can be pulled into the pivot). Our client wants these attribute names to appear in the selection list in a…
Matthias
  • 353
  • 2
  • 11
1 2 3
…
99 100