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
7
votes
3 answers

Database selection for a web-scale analytics application

I want to build a web-application similar to Google-Analytics, in which I collect statistics on my customers' end-users, and show my customers analysis based on that data. Characteristics: High scalability, handle very large…
Yasei No Umi
  • 1,574
  • 9
  • 23
7
votes
1 answer

Does CQRS With OLTP and OLAP Databases Make Sense?

I have several OLTP databases with API's talking to them. I also have ETL jobs pushing data to an OLAP database every few hours. I've been tasked with building a custom dashboard showing hight level data from the OLAP database. I want to build…
Muhammad Rehan Saeed
  • 35,627
  • 39
  • 202
  • 311
7
votes
3 answers

MS Analysis Services OLAP API for Python

I am looking for a way to connect to a MS Analysis Services OLAP cube, run MDX queries, and pull the results into Python. In other words, exactly what Excel does. Is there a solution in Python that would let me do that? Someone with a similar…
ktdrv
  • 3,602
  • 3
  • 30
  • 45
7
votes
5 answers

Can you recommend a PostgreSQL Visual Database Designer for Linux?

When I'm in Windows, I use the excellent MicroOLAP Database Designer for PostgreSQL, but its not open source or multiplataform. Do you know or can recommend me an alternative to this software, that I can use in Linux? EDIT: Just to clarify, I don't…
ramayac
  • 5,173
  • 10
  • 50
  • 58
7
votes
3 answers

MDX date range query with a missing boundry date

I need an MDX query for Mondrian filtered by date, where one or both of the boundry dates may not exist. I'm using the query below that works as long as both 2013-01-01 and 2013-01-08 dimensions exist. If one of the two dates does not exist then…
Dynamite
  • 93
  • 4
7
votes
1 answer

Python Cubes OLAP Framework - how to work with joins?

I'm trying to use python's olap framework cubes on a very simple database, but I am having some trouble joining tables. My schema looks like this: Users table ID | name Products table ID | name | price Purchases table ID | user_id | product_id |…
user1491915
  • 1,067
  • 1
  • 14
  • 19
7
votes
1 answer

Connecting to Database Cube that uses MySQL database from PHP (using JDBC)

My database team has set up a database Cube using MySQL database. I need to connect to this Cube from PHP and get the data using MDX queries. I can't find how to do that. Could someone please help me with this ASAP? Reference document :- Creating…
ilight
  • 1,622
  • 2
  • 22
  • 44
6
votes
2 answers

Pre-aggregated datastructure in clojure

In OLAP-cubes it's possible to do very quick look ups on large amounts of aggregated data. The major reason for this is that one pre-aggregates data in operations which are easy to combine upwards (mainly +, -, mean, std, max, min and some…
claj
  • 5,172
  • 2
  • 27
  • 30
6
votes
2 answers

How is BI related to data mining?

I'm a little confused on how to connect BI with data mining. Can BI be termed as some kind of a manifestation of data mining? How different is a BI tool like Microsoft Analysis Services from a data mining tool like Weka? I guess BI involves more of…
Arnkrishn
  • 29,828
  • 40
  • 114
  • 128
6
votes
4 answers

Are Mondrian / OLAP the wrong tool for joining large dimensions/sets?

Summary: Most of the examples I've seen of MDX joins have involved joining relatively small sets, say with tens or hundreds of items each. But I find myself also wanting to try joining (in particular "non-empty joining") sets that have thousands or…
Chris
  • 9,986
  • 8
  • 48
  • 56
6
votes
1 answer

best data structure for multidimensional data?

I would like to implement a simple, in-memory OLAP cube storage engine for read and write (writeback) - functionally similar to SSAS cube with multiple dimensions but one measure and only with 1 type of aggregation (sum). As in OLAP cube each axis…
voltaire
  • 213
  • 2
  • 8
6
votes
0 answers

Open .ODC connection in R

I have an .odc (office data connection) that connects Excel to a Web Service (MSBI, Web PowerBI). It's working fine. I open the odc file, Excel opens up and it is connected to the data source. How can I open this connection directly from R? The odc…
Dan
  • 1,711
  • 2
  • 24
  • 39
6
votes
1 answer

Efficient way to process a multidimensional cube

I am building a multidimensional cube using SSAS, I created the partitions based on a date column, and defined a partition for each day. Source data size is bigger than 2 TB. While deploying and processing the the cube, if an error occurred all…
Yahfoufi
  • 2,220
  • 1
  • 22
  • 41
6
votes
2 answers

Filtering results from ClickHouse using values from dictionaries

I'm a little unfamiliar with ClickHouse and still study it by trial and error. Got a question about it. Talking about the star scheme of data representations, with dimensions and facts. Currently, I keep everything in PostgreSQL, but OLAP queries…
Ilya Konyukhov
  • 2,666
  • 1
  • 12
  • 21
6
votes
1 answer

Gremlin OLAP queries on AWS Neptune

In the AWS Neptune documentation it says it is Apache TinkerPop Gremlin compatible but it only refers to online transaction processing (OLTP) type of graph traversal queries. I haven't seen anything about long-running online analytical processing…
onurmatik
  • 5,105
  • 7
  • 42
  • 67
1 2 3
…
99 100