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
14
votes
9 answers

OLAP Cube deployment issues

I'm really new to this, so I am probably making a simple mistake. I need to make an OLAP cube using a remote database. After I set up the dimensions and measures and create the cube, I can not get the cube to launch to the local server. I keep…
Daniel Martin
  • 570
  • 1
  • 9
  • 18
13
votes
9 answers

Browsing OLAP cubes

Does anybody know any fine open source cube browser? Ideally, it would be something built with plain javascript. Does it even exists? I'm planing to use it with classic asp agains a SQL database.
opensas
  • 60,462
  • 79
  • 252
  • 386
13
votes
1 answer

R clients to OLAP MDX servers

Has anyone tried to access an OLAP server offering a XMLA API (such as Mondrian) from R? I'd love to run MDX queries from R against Mondrian and retrieve result sets.
Xavier Guardiola
  • 2,699
  • 3
  • 19
  • 11
12
votes
2 answers

Why use ROLAP instead of plain MySQL?

Are there any performance advantages in using a ROLAP server such as Mondrian on top of a MySQL database, as opposed to simply querying the MySQL database? I am asking this in the context in which most of my queries will be relatively simple (such…
Epicurus
  • 2,103
  • 7
  • 29
  • 39
12
votes
2 answers

What should I have in mind when building OLAP solution from scratch?

I'm working for a company running a software product based on a MS SQL database server, and through the years I have developed 20-30 quite advanced reports in PHP, taking data directly from the database. This has been very successful, and people are…
Søren Haagerup
  • 377
  • 1
  • 4
  • 11
12
votes
1 answer

MDX Calculated Member CrossJoin question

I have an MDX query with the following calculated member: with member [Measures].[BBOX] as Count( Filter( CrossJoin([Dim Response].[Response ID].Children, [Dim Question].[Question Text].Children), [Measures].[Question Bottom Box]…
Ryan
  • 121
  • 1
  • 3
12
votes
2 answers

Is a star schema a denormalized schema?

An OLAP database consists of data in denormalized form. This means data redundancy and this data redundancy helps retrieve data through less number of joins, hence facilitating faster retrieval. But a popular design for OLAP database is…
Victor
  • 16,609
  • 71
  • 229
  • 409
12
votes
2 answers

How does NUMA architecture affect the performance of ActivePivot?

We are migrating an ActivePivot application to a new server (4 sockets Intel Xeon, 512GB of memory). After deploying we launched our application benchmark (that's a mix of large OLAP queries concurrent to real-time transactions). The measured…
Jack
  • 145
  • 1
  • 1
  • 11
12
votes
2 answers

What is the best approach to get from relational OLTP database to OLAP cube?

I have a fairly standard OLTP normalised database and I have realised that I need to do some complex queries, averages, standard deviations across different dimensions in the data. So I have turned to SSAS and the creation of OLAP cubes. However to…
dan
  • 5,664
  • 8
  • 45
  • 59
11
votes
4 answers

Database warehouse design: fact tables and dimension tables

I am building a poor man's data warehouse using a RDBMS. I have identified the key 'attributes' to be recorded as: sex (true/false) demographic classification (A, B, C etc) place of birth date of birth weight (recorded daily): The fact that is…
morpheous
  • 16,270
  • 32
  • 89
  • 120
11
votes
2 answers

OLAP - Calculate run-off triangles, sample data and cube included (PostgreSQL/Mondrian)

Reality description: We do have a list of projects. In every project there is a lot of accounts. You can do a lot of actions on every account. I do have the following dimensions and fact table defined (simplified): Dimensions and attributes: …
Tomas Greif
  • 21,685
  • 23
  • 106
  • 155
10
votes
1 answer

Does spring-boot support any dynamic OLAP report generation tool?

I need to add OLAP report support into my existing spring boot web application. I have come across multiple BI tools like BIRT, JasperServer Report and Saiku but for all of them, I have to use an already created cube. In case, there is any…
Dharita Chokshi
  • 1,133
  • 3
  • 16
  • 39
10
votes
7 answers

In memory OLAP engine in Java

Is there an in memory OLAP (slice and dice data) Java library. (The equivalent of Microsoft Analytic Services). Especially would like to hear if anyone has used one for real.
Dan
  • 9,681
  • 14
  • 55
  • 70
10
votes
3 answers

Python: interact with complex data warehouse

We've worked hard to work up a full dimensional database model of our problem, and now it's time to start coding. Our previous projects have used hand-crafted queries constructed by string manipulation. Is there any best/standard practice for…
bukzor
  • 37,539
  • 11
  • 77
  • 111
10
votes
1 answer

Reasons against using Elasticsearch as an OLAP cube

At first glance, it seems that with Elasticsearch as a backend it is easy and fast to build reports with pivot-like functionality as used in traditional business intelligence environments. By "pivot-like" I mean that in SQL-terms, data is grouped by…
user1091141
  • 581
  • 7
  • 19
1
2
3
…
99 100