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 call measures on Mondrian?

I'm try to create simple Mondrian schema with OLAP connection, but I have a problem. I have two Measures. But when I called it, it just call one measures. I'm new on Mondrian and OLAP. My schema look like this.
newbie
  • 61
  • 2
  • 10
0
votes
1 answer

select total amount no matter what filter applied in MDX Statement

i have some Measure, let's say [Measure].[m1]. Furthermnore there is i dimension [Dim1] with 3 different Hierachies [H1],[H2],[H3]. The Hierachies are just some kind of categories so the Sum of m1 on H1 equals Sum of m1 on H2 and H3 as well. i want…
tuxmania
  • 906
  • 2
  • 9
  • 28
0
votes
1 answer

Build summary table with dimension values in measures

I recently engaged in OLAP and encountered the following problem. First, some of the domain. There are auctions in which people can participate (Members). Auctions are created by users (Organizers) who turn belongs one of the Retailers. There is…
Maxwell
  • 95
  • 7
0
votes
2 answers

Basic questions regarding Data Warehousing

I'm wanting to use OLAP cubes and have to first design a data warehouse. I am going for the star-schema. I'm a little confused about how to convert from a normal database to a data warehouse, especially with regards to foreign keys between dimension…
Matt
  • 6,787
  • 11
  • 65
  • 112
0
votes
1 answer

Multidimensional database...how is data stored in it?

Just wondering how is data actually stored in a multidimensional database. All the references that I saw show a cube for 3-dimension, just to imagine its fine, but in actual it has to be 2-D only, having foreign key relationship rite? Thanks,
Hemal
  • 265
  • 1
  • 7
  • 17
0
votes
1 answer

Constructing Calculated Measures in MDX for different measures using same columns in a fact table

i have a fact table with 2 columns corresponding to dimensions Dim1, Dim2. In the same table i have 4 other columns Value_Type(int), INT_VALUE(int), FLOAT_VALUE(float), TEXT_VALUE(string). There are a number of measures which are identified by…
kosmipt
  • 5
  • 2
0
votes
1 answer

Reason of why OLAP in HBase is possible

OLAP directly upon most of the noSQL databases is not possible, but from what I researched it's actually possible in HBase, so I was wondering what features does HBase have in particular that distinguishes it from the others allowing us to do this.
user3323032
  • 135
  • 3
  • 13
0
votes
1 answer

How to use the CUBEMEMBERPROPERTY function

In cell A1 we have this: =CUBEMEMBER("OurCube","TAIL([Date].[Date - Calendar Month].[Calendar Day].MEMBERS,1).item(0)","TargetMember") It works fine and returns a single member that is yesterday. In A2 we have a formula that is attempting to…
whytheq
  • 34,466
  • 65
  • 172
  • 267
0
votes
2 answers

Vectorwise vs OLAP

Would it be preferable to use the Vectorwise based system for efficient data analysis as contrast to OLAP cubes. I have the idea that vector-wise single instruction, multiple data (SIMD) could be good but don't have much good material and resources…
irfan Munir
  • 151
  • 3
  • 17
0
votes
0 answers

Linking a cube fact to itself

I have a fact table with the following structure: PeriodID, AccountID, FlagID, Value1 PeriodID, AccountID and FlagID all link to different dimensions Value1 is a numeric value, with a Sum() measure specified on it in the cube Assume the following…
user1365247
  • 337
  • 7
  • 17
0
votes
1 answer

Using a named set to filter out dimensional date data

I have created a set to filter out the entire date dimension to it's respective measure: CREATE SET DatesAvailable AS NonEmpty ([Date].[Hierarchy].[Day].MEMBERS, Measures.CURRENTMEMBER); I would like for the filter to be applied automatically…
dirtyw0lf
  • 1,899
  • 5
  • 35
  • 63
0
votes
2 answers

Poor performance of calculated measures in Tableau from an OLAP Cube datasource

Hello Tableau experts! I'm fairly new to Tableau and I'm currently working on a report with a connection to an OLAP cube. However, I'm getting some strange performance with some of the calculated measures that I have created. My query at this point…
user3485250
  • 1
  • 1
0
votes
0 answers

Cube: Passing one dimension current member inside the argument of another dimension

In OLAP cube, while creating calculated measures, is it possible to pass the current member of one dimension (say [Dimension_Two]) as a parameter of Lead() or Lag() functions for another dimension ([Dimension_One])? Something like this: Sum(…
pso
  • 819
  • 12
  • 25
0
votes
0 answers

Can I process an OLAP cube through GUI

I have a program which uses a multidimensional database and I need to add a feature to the GUI for the users to process the cubes through it. Is there a library to do this? Thanks
Ignacio Coto
  • 63
  • 6
0
votes
2 answers

MDX Query Join Two Dimensions

I have an MDX query as follows: WITH MEMBER [MatCode] AS [Product].[Material] SELECT ([MatCode]) on 0, ([Activity].[ActivityCode].[T-50051151]) ON 1 FROM [Cube] This returns a value such as: MatCode T-50051151 Null Which tells…
neeko
  • 1,930
  • 8
  • 44
  • 67
1 2 3
…
99
100