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

Empty cells/offset in the report: how to define a dimension and hierarchy in the cube?

I want to analyze some dynamics of the some process. For that I use Saiku analytics plugin CE for Pentaho Business Intelligence Server CE 5.0.1. There is a table of facts and a table of dimensions that using to perform some aggregations. Dimensions…
user1134181
0
votes
1 answer

How to hide non-existents members in dimension?

I have two dimensions: Mall, Gallery. First mall have gallery #1-3, second mall have gallery #4. How to hide gallery #4 for first mall and gallery #1-3 for second mall?
Nodon
  • 967
  • 11
  • 24
0
votes
1 answer

ROLAP columnar Database

We have a very simple use-case but we are having a hard time choosing the best DB solution that fits our needs. The requirement: An OLAP DB that allows us to query millions of records by different properties(thousands), and can hold one primary key.…
fdnieves
  • 41
  • 6
0
votes
1 answer

is there a way to convert data from SSAS dimensional representation back into relational representation?

I was wandering, if there was a way to reverse engineer an SSAS OLAP cube back into its original relational representation. Is such a thing possible?
Eugene Goldberg
  • 14,286
  • 20
  • 94
  • 167
0
votes
1 answer

Optimize set calculation in mondrian

I have a MDX query, and I am executing it on Mondrian engin. WITH MEMBER [Measures].[HC Threshold] AS Val(StrToMember("[HC Threshold].[HC Threshold].[All].[25000]").Name) ,FORMAT_STRING = "$#,0" SET ClaimantsSet AS Order ( …
user1196985
  • 120
  • 10
0
votes
1 answer

tabular in-memory vs multidimensional and molap-mode

I have a question regarding the ssas-models tabular and multidimensional cube. I've read that both models can work in a real-time-mode (direct query mode & rolap). My questions concerns the tabular model in in-memory-cache-mode and the…
Hans Dampf
  • 67
  • 7
0
votes
1 answer

Advice on creating analytical query (SQL) generator

We are migrating from Microsoft's Analysis Services (SSAS) to HP Vertica database as our OLAP solution. Part of that involves changing our query language from MDX to SQL. We had a custom MDX query generator which allowed others to query for data…
Charlie Brad.
  • 1
  • 1
0
votes
1 answer

Use CSV or Text file as a data source for SSAS cube

Can we have a CSV or Text file as a data source for SSAS cube. I deal with lots of data and maintain SSAS cubes (ROLAP) for analyzing the same. The data(~2 GB) comes in every hour as a formatted text file which I upload to a DB which acts as a data…
user4676671
  • 1
0
votes
2 answers

Surrogate Keys in a Data Warehouse

I understand the general concept of a surrogate key in a DWH environment. But there are two aspects I don't understand and couldn't find information about: Is it common practice that a surrogate key is unique in the whole DWH or unique in one…
user3364656
  • 279
  • 2
  • 4
  • 9
0
votes
3 answers

Cube design - ROLAP considerations vs. MOLAP

Does anyone have resources that give a list of things to consider when designing a ROLAP cube, as opposed to MOLAP (I'm doing it in Pentaho, but I guess the principles are not dis-similar for other implementations). For example, I'm thinking of…
davek
  • 22,499
  • 9
  • 75
  • 95
0
votes
2 answers

what-if analysis on Rolap Or Molap & how?

i would like to simulate what-if analysis on a OLAP cube For example, i would like to know the impact on departmental resource budgets by moving employees between departments or the movement in cost of manufacture if a product is moved from one…
Chikawi
  • 1
  • 4
0
votes
2 answers

How would I write a SQL query to bring back all levels of product categorization accommodating unknowns?

I know the question might have not been too clear but I'll try to explain things better: I'm building a data warehouse and am working on building a Product dimension table for my ROLAP. The dimension will include the Product, Brand, Client. So in…
Joel R.
  • 189
  • 3
  • 17
0
votes
1 answer

How can i write a dimension with snow flake schema ? . Details below

There are three tables - 1) Student - My fact Table (References Addresses with FK ADDRESS_ID 2) Addresses - This table Contains FK COUNTRY_ID references COUNTRY 3) Country - this has a NAME COLUMN which i would display. (PK IDENTIFIER) I have…
Rajeev A N
  • 105
  • 3
  • 9
0
votes
1 answer

SAS: Proc Olap. Non-nway aggregation

I want to make Rolap-cube. After creation of tables, i use macro-generation to write Aggregation statement in proc olap. And see warning and error like this: WARNING: You cannot use NAME "DEFAULT" in the AGGREGATION statement for a non-NWAY …
gaussblurinc
  • 3,642
  • 9
  • 35
  • 64
-1
votes
1 answer

Can we integrate Pentaho and Google Visualization API or to flex?

I have developed one Mondrian schema and cube. I have deployed schema file in Pentaho BI server. I would like to know is it possible to connect these Pentaho schemas and UI technologies like Google Visualization API or Adobe Flex? While searching…
Shekhar
  • 11,438
  • 36
  • 130
  • 186
1 2
3