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

Is there a (open-source) MDX-based in-memory OLAP server?

I was wondering if there is a in-memory OLAP server which can handle MDX. I found the Wikipedia article. But it says nothing about in-memory functionality... The only one I know of them is Mondrian, which is also one of the two open-source solutions…
DennisH
  • 383
  • 3
  • 11
10
votes
4 answers

Any scalable OLAP database (web app scale)?

I have an application that requires analytics for different level of aggregation, and that's the OLAP workload. I want to update my database pretty frequently as well. e.g., here is what my update looks like (schema looks like: time, dest, source…
charlie111
  • 121
  • 1
  • 5
9
votes
1 answer

Calculated Member for last-child in non-time dimensions?

In a SSAS cube, how do I create measures that are aggregated as LastChild for a non-time dimension? The source data has many versions of the same business record on any given day. The time dimension has a granularity of DATE, not seconds &…
Mark
  • 9,320
  • 6
  • 57
  • 70
9
votes
6 answers

Simulated OLAP

We have a client that has Oracle Standard, and a project that would be ten times easier addressed using OLAP. However, Oracle only supports OLAP in the Enterprise version. Migration to enterprise is not possible I'm thinking of doing some manual…
juan
  • 80,295
  • 52
  • 162
  • 195
9
votes
4 answers

Query OLAP Mondrian (MDX, XMLA) with a Python interface?

Actually I'm using R + Python with RPY2 to manipulate data and ggplot to create beautiful graphics.. I have some data in a PostgreSQL database, and I'm using psycopg2 to query data. I'm starting a thesis, and in the future I need an OLAP cube to…
reyman64
  • 523
  • 4
  • 34
  • 73
9
votes
4 answers

How to determine which SSAS Cube is processing now?

There is a problem when several users can process the same cube simultaniously and as a result processing of cube fails. So I need to check if certain cube is processing at current moment.
Alekzander
  • 866
  • 3
  • 12
  • 12
8
votes
3 answers

Building OLAP style applications with SalesForce/Apex

We are considering moving a planning and budgeting app to the Salesforce platform. The existing app is built on a dimensional data model, and has extensive ad-hoc query capability implemented through star joins. We see how the platform will allow…
Old Man
  • 3,295
  • 5
  • 23
  • 22
8
votes
3 answers

Connect to Power BI XMLA endpoint with Python

Since the announcement about XMLA endpoints, I've been trying to figure out how to connect to a URL of the form powerbi://api.powerbi.com/v1.0/myorg/[workspace name] as an SSAS OLAP cube via Python, but I haven't gotten anything to work. I have a…
Alexis Olson
  • 38,724
  • 7
  • 42
  • 64
8
votes
4 answers

Any Python OLAP/MDX ORM engines?

I'm new to the MDX/OLAP and I'm wondering if there is any ORM similar like Django ORM for Python that would support OLAP. I'm a Python/Django developer and if there would be something that would have some level of integration with Django I would be…
Bartosz Ptaszynski
  • 726
  • 7
  • 8
8
votes
1 answer

java.lang.IllegalArgumentException: Unable to PTableType enum for value of 'MATERIALIZED VIEW' Exception with Phoenix and Hbase

I am very much new to Saiku. I am trying to integrate the saiku with phoenix. Phoenix intern connect with HBase. I created a schema and when the Saiku tries to load phoenix schema xml, Am triggered with below error. I am working restless to figure…
venky
  • 400
  • 1
  • 6
  • 19
8
votes
2 answers

How do you design an OLAP Database?

I need a mental process to design an OLAP database... Essentially for standard relational it'd be (loosely): Identify Entities Identify Relationships Identify Properties of Entities For each property: Ensure property can be related to only one…
stevenrcfox
  • 1,547
  • 1
  • 14
  • 37
8
votes
1 answer

Can RethinkDB handle large data sets (TB+) and serve as DB for an OLAP app?

Can RethinkDB handle large data sets (i.e. multiple tera bytes ) effectively to serve as DB for an analytics application ?
JE42
  • 4,881
  • 6
  • 41
  • 51
8
votes
4 answers

Is there a data structure / library to do in memory olap / pivot tables in Java / Scala?

Relevant questions This question is quite relevant, but is 2 years old: In memory OLAP engine in Java Background I would like to create a pivot-table like matrix from a given tabular dataset, in memory e.g. an age by marital status count (rows are…
Eran Medan
  • 44,555
  • 61
  • 184
  • 276
7
votes
1 answer

What advantages does in-memory OLAP have over traditional systems with significant memory?

Do in-memory OLAP engines have advantages over the traditional OLAP engines backed by enough RAM to contain the entire cube(s)? For example, if I use a MOLAP engine (SSAS) and GB / TB of RAM where the entire cube (or even star-schema) is RAM…
kermatt
  • 1,585
  • 2
  • 16
  • 36
7
votes
1 answer

non-Windows OLAP desktop client?

Working with SSAS 2008 in an environment with mostly Mac desktops. Use DbVisualizer and Aqua Data Studio for writing relational queries, but need a native desktop app to write MDX queries and view results from OLAP sources. VMWare / Parallels is not…
kermatt
  • 1,585
  • 2
  • 16
  • 36
1 2
3
…
99 100