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
1
vote
1 answer

Mondrian - Cannot find MDX member exception

I'm running mondrian as a standalone on mysql. I'm getting the exception mondrian.olap.MondrianException: Mondrian Error:Cannot find MDX member '[Measures]'. Make sure it is indeed a member and not a level or a hierarchy. when i run any MDX…
Arvindkumar
  • 184
  • 2
  • 16
1
vote
4 answers

Custom ROLAP Data Source in SSAS

I am trying to build an OLAP datasource from a bunch of binary files, and our current model just isn't working. We are using SSAS as our analysis / reporting model for our results, but aren't able to get the performance we want out of SQL. Our…
Tom Laughlin
  • 73
  • 9
1
vote
1 answer

Date range query with mondrian and olap4j

I am using olap4j to query a mondrian cube. I have defined a standard TimeDimension in my schema xml: …
yosi
  • 639
  • 1
  • 12
  • 21
1
vote
1 answer

Updating a SSAS partition slice in SSIS

I have an SSAS cube that has two partitions, one in MOLAP and the other in ROLAP. On my ROLAP partition, I have the slice set with the last 5 members of my Time dimension. Each night when the cube is processed, I need to update the slice for my…
mclark1129
  • 7,532
  • 5
  • 48
  • 84
0
votes
1 answer

Storing large amounts of demographic data so it can be easily analysed - OLAP, ORM, custom solution?

We're building a database of demographics data for analysis; this data is all over the place, from crime data to census data to other stuff. We want to be able to dig in via geography, metric, or time period, and while we've done a lot of…
Craig Saboe
  • 101
  • 1
0
votes
1 answer

Create a report with an query

I have a problem. Consider the following fact and dimension tables in a ROLAP system that collects values of harmful substances measured in foods that are sold in supermarkets. Fact table: • Contaminants (TimeID, ShopID, FoodID, substance,…
Test
  • 571
  • 13
  • 32
0
votes
1 answer

Mondrian tries to optimize Segment.load weirdly resulting in partial or fully empty results

I feel like I am missing something: I have simple MDX query and rather simple Mondrian code, yet, it still behaves weirdly - that is the results of the query differ depending on whether XML schema contains unrelated to query dimension(s). At this…
SitaNVGS
  • 40
  • 1
  • 5
0
votes
1 answer

SSAS ROLAP dimension isn't processed until manually browsed

I'm converting an existing SSAS project to use proactive caching, and I've run into an issue when I attempt to query the cubes. I've converted the dimensions to ROLAP, and the measure groups to HOLAP. When I query the cubes, I get a "key not found"…
Julian Goldsmith
  • 198
  • 8
0
votes
1 answer

MDX - Sum at lowest time, then Max it out

I have; a Time dimension (Year, Month, Day, Hour), a Product dimension (Product, Feature) and a User dimension (User) The measure I have available is: Used (Number of features that are in use) What I want to do, is to display the Max of concurrent…
goddva
  • 141
  • 5
0
votes
0 answers

Query optimization beyond indexes

I wrote this query that 'cubes' some data writing partial totals: select upper(coalesce(left(k.SubStabilimento,12),'ALL')) as Stabilimento, sum(k.PotenzialmenteInappropriato) as Numeratore, …
DDS
  • 2,340
  • 16
  • 34
0
votes
1 answer

Two Dimensional Database Design -SQL or JSON

I need a database design advice. I am currenty using SQLite ( or i can switch to any other database for those tables) I have A,B,C,D columns with rows from 24 to 1008 . X represents whether the column empty or not. my first idea-> I can do…
emre deli
  • 83
  • 1
  • 9
0
votes
1 answer

Mondrian with cassandra

I'm trying without success use a cassandra database with mondrian, there's some way to make it work? or it's just impossible cause mondrian only works with relational database? my code works with mysql Connection connection = new Connection(); …
Stenio Galvao
  • 23
  • 8
0
votes
1 answer

MDX query to sum measure of items containing dimension member

This MDX query: WITH MEMBER [Measures].[# answered] AS ([Dispozice].[Dispozice].[ANSWERED], [Measures].[# hovorů]) SELECT {[Measures].[# hovorů], [Measures].[# answered]} ON COLUMNS, CrossJoin([Datum vytvoření.Po dnech].[Rok].[2017],…
Jakub Truneček
  • 8,800
  • 3
  • 20
  • 35
0
votes
0 answers

Datawarehouse, ROLAP and Storage Space

I have a star-schema with n dimensions and one fact table. Now I want to calculate the total amount of space is needed to save all the data from the star-schema in a ROLAP-Cube. Is there like a formula or something?
Hammelkeule
  • 197
  • 5
  • 17
0
votes
2 answers

What is the difference between ROLAP and a Data warehouse?

I am really confused between the definition of ROLAP and a Data warehouse. When we load aggregate data in relational tables can we call this ROLAP? Or is ROLAP a reporting tool?
pika
  • 53
  • 2
  • 10
1
2
3