Stack Overflow
Stack Overflow

Questions tagged [rolap]

ROLAP (relational online analytical processing) is designed to allow analysis of data through the use of a multidimensional data model. ROLAP data are stored in relational database and are queried by SQL queries (usually transformed from MDX queries by OLAP engine).

ROLAP (relational online analytical processing) is designed to allow analysis of data through the use of a multidimensional data model. ROLAP data are stored in relational database and are queried by SQL queries (usually transformed from MDX queries by OLAP engine).

45 questions
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
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
4
votes
1 answer

Can any dimension be added to a SSAS CUBE dynamically

We build an SSAS ROLAP cube where data source is memSQL. The cube is built using Visual Studio 2019 and the driver used to connect to memSQL data source is "MySQL .NET Provider 8.0.19". The cube is built and processed successfully. As it is a ROLAP…
Koushik Chandra
  • 1,565
  • 12
  • 37
  • 73
3
votes
1 answer

CUBE + outer join = extra NULL row

When I use PostgreSQL's CUBE on a query with an OUTER JOIN, I get an extra all-NULL row that can't be distinguished from the cube's own "everything combined" all-NULL result. CREATE TABLE species ( id SERIAL PRIMARY KEY, name …
Catherine Devlin
  • 7,383
  • 2
  • 25
  • 17
3
votes
1 answer

How to use a PostgreSQL DB as XMLA datasource?

Basis: PostgreSQL database with normal and reporting data Downloaded the Mondrian zip from here I have a client pivot grid component (DevExtreme Web) As i understand it so far, i have to use a OLAP-server that functions as connector between MDX…
Spenhouet
  • 6,556
  • 12
  • 51
  • 76
2
votes
0 answers

Open Source OLAP Framework for Java?

I have been using NReco which provides "C# in-memory OLAP cube for fast data aggregation and pivot reports generation" for a little while now. The goal now is to port the application to Java. What I am looking for is to: Add an OLAP layer on top of…
Jeff Diederiks
  • 1,315
  • 13
  • 20
2
votes
1 answer

What could be incorrect in this multidimensional model?

I want to build a simple multidimensional data model by using the star schema in a relational database (ROLAP). For that I create a fact table and two tables of dimensions. Firstly I copy the data from the operational source and handle this data…
user1134181
2
votes
1 answer

ROLAP not working - how to design the cube/DSV for ROLAP?

I'm trying to configure storage mode ROLAP for a partition in an existing SSAS cube. The cube is a little messy in that the measure group is defined by a named query (as opposed to a table) and the dimensions are defined in several different data…
sepang
  • 4,640
  • 4
  • 23
  • 23
2
votes
1 answer

In-Database Memoization - a good idea? Any experiences?

I have an idea I have yet to implement, because I have some fear I may be barking up the wrong tree... mainly because Googling on the topic returns so few results. Basically I have some SQL queries that are slow, in large part because they have…
Tom Lianza
  • 4,012
  • 4
  • 41
  • 50
2
votes
1 answer

how to find shared dimensions in two or more cubes in Mondrian

i have many cubes A B C ,... and i want to find all the common dimensions between these cubes by Mondrian notice shared dimensions in each cube could have different names so using of cube.getDimensions().getUniqeName() Or…
samira
  • 117
  • 9
1
vote
1 answer

MDX query to group on year of date dimension with specific date range

I have SQL query SELECT YEAR(DATE),SUM(AMOUNT) FROM TABLE WHERE DATE BETWEEN '2017-09-01' AND '2018-09-30' GROUP BY YEAR(DATE). This will give me sum of amount for 2017 and 2018 for selected date range. Same I am trying in mdx query with date…
Hardik Shah
  • 83
  • 2
  • 5
1
vote
2 answers

Difference between CUBE and WITH CUBE

I found in MSSQL exists both SELECT , sum(measure) as measure FROM fact-table GROUP BY WITH CUBE and SELECT , sum(measure) as measure FROM fact-table GROUP BY CUBE () I…
DDS
  • 2,340
  • 16
  • 34
1
vote
1 answer

Difference between a data warehouse and a MOLAP server

What is the difference between a data warehouse and a MOLAP server? Is the data stored at both the data warehouse and on the MOLAP server? When you pose a query, do you send it to the data warehouse or the MOLAP server? With ROLAP, it kind of makes…
user2725580
  • 1,293
  • 2
  • 17
  • 21
1
vote
1 answer

What is diffrent between Time dimension And Standart dimension in Mondrian?

I have fact table with date_id column and date table with year, month, day columns. I can create a dimension with one dimension type. What influences the choice of the type? I dont see the diffence between this types in results.
Nodon
  • 967
  • 11
  • 24
1
vote
2 answers

How to write query without "Cube" function in oracle?

I am working at ROLAP on Oracle and i have this Fact Table : Sales(market_id,item_id,sale), and i have this query : SELECT market_id,item_id,SUM(sale) FROM Sales GROUP BY CUBE(market_id,item_id); Is there another way to get the same results but…
Sawan
  • 162
  • 1
  • 10
1
2 3