Stack Overflow
Stack Overflow

Questions tagged [olap-cube]

An OLAP cube is a multidimensional database that is optimized for data warehouse and online analytical processing (OLAP) applications.

An OLAP cube is a multidimensional database that is optimized for data warehouse and online analytical processing (OLAP) applications.

An OLAP cube is a method of storing data in a multidimensional form, generally for reporting purposes. In OLAP cubes, data (measures) are categorized by dimensions. OLAP cubes are often pre-summarized across dimensions to drastically improve query time over relational databases. The query language used to interact and perform tasks with OLAP cubes is multidimensional expressions (MDX). The MDX language was originally developed by Microsoft in the late 1990s, and has been adopted by many other vendors of multidimensional databases.

820 questions
85
votes
3 answers

Data Warehouse vs. OLAP Cube?

Can anyone explain what is really distinction between Data Warehouse and OLAP Cubes? Are they different approach for same thing? Is one of them deprecated in comparison with other? Are there any performance issues in one of them? Any explanation is…
veljasije
  • 6,722
  • 12
  • 48
  • 79
18
votes
4 answers

Build a basic cube with numpy?

I was wondering if numpy could be used to build the most basic cube model where all cross-combinations and their computed value are stored. Let's take the following example of data: AUTHOR BOOK YEAR SALES Shakespeare …
David542
  • 104,438
  • 178
  • 489
  • 842
11
votes
1 answer

Process update is taking longer than Process full

I have a cube which has few big dimensions. It is currently taking 2 hours to Process Full. I have now partitioned the cube and followed below strategy: Process Update dimensions Process data Partition (only needed partition) Process index…
Zerotoinfinity
  • 6,290
  • 32
  • 130
  • 206
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
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
7 answers

alternatives to jpivot?

JPivot, even with all it's functionality, seems a bit outdated... last version at http://sourceforge.net/projects/jpivot/ is from 2008-03-17... is there any other lightweight client olap cube browser, that could take advantage of modern RIA kits,…
opensas
  • 60,462
  • 79
  • 252
  • 386
9
votes
2 answers

How to automatically refresh sql server olap cube

I have built a cube in visual studio and deployed to SSAS. How can I get the data refreshed using a nightly sql batch job or some other means? TIA
Graeme
  • 2,597
  • 8
  • 37
  • 50
8
votes
1 answer

Connecting to a SSAS cube using R

Is it possible to query a SQL Server Analysis Services cube using R? I have this cube on a different external Server and i am working from my machine but i have admin privileges on the Server with my domain account. To put it simply, i want to…
Johannes Wentu
  • 931
  • 1
  • 14
  • 28
8
votes
2 answers

Can OLAP CUBE be done in HBase?

Is there any way to create CUBE DIMENSIONS in HBase or OLAP with it? I want to create CUBE DIMENSIONS kind of application with my HBASE or HIVE and connect that with SSAS for reporting purpose, is that possible? If soo please guide me with some…
sudheer
  • 338
  • 1
  • 6
  • 17
7
votes
1 answer

SSAS cube with multiple DB

I have 3 databases with the same structure, but different data, since they are from different clients. Now, I have an existing SSAS project. Its Data Source Views, Cubes and Dimensions can only use or access one DB. What I want is to be able to use…
Raii
  • 303
  • 1
  • 4
  • 15
7
votes
3 answers

Why to build a SSAS Cube?

I was just searching for the best explanations and reasons to build a OLAP Cube from Relational Data. Is that all about performance and query optimization? It will be great if you can give links or point out best explanations and reasons for…
MSU
  • 415
  • 3
  • 6
  • 13
5
votes
5 answers

How are most people using MDX queries? Should I be using MDX results to drive a web UI?

I'm trying to do some analysis for an upcoming project. It has something to do with trending, charting and analysis; so think MAX, MIN, AVG, SUM etc over a period of time. Say we have an OLAP cube that's setup to figure out these calculations…
topwik
  • 3,487
  • 8
  • 41
  • 65
5
votes
2 answers

OLAP cube - PHP and MongoDB

I need to create an analytics system. I already built the system using MognoDB and PHP but without using OLAP. Now my queries are really the best I can get, but the system is really slow because no cube. It can take a minute to load a report for the…
Eli_Rozen
  • 1,301
  • 4
  • 20
  • 31
5
votes
2 answers

Analysis Services .abf file database restore

I am really really new to SQL Server, I know how to do a query and other simple stuff and recently my company was bought by another one, we had a Cube Server which was accessed by a excel file via olap using the analysis services from sql server…
Otavio Hurtado Paoleschi
  • 53
  • 1
  • 3
5
votes
3 answers

A connection cannot be made. Ensure that the server is running

When I am trying to process dimensions after creating a data source view I get the error: The project could not be deployed to the server because of the following connectivity problems : A connection cannot be made. Ensure that the server is…
mnv
  • 53
  • 1
  • 1
  • 6
1
2 3
…
54 55