On-Line Analytical Processing, a class of systems designed for fast calculation, reporting and analysis of aggregate figures.
3
votes
1answer
68 views
Should I snowflake or duplicate it across my facts?
I'm building up a data warehouse to be used by SSAS to create cubes on, and I'm debating between two possible schemas.
In my warehouse, I've got two different fact tables that tracking daily changes ...
2
votes
0answers
72 views
What does a multidimensional cube's internal structure look like?
We all know what a relational data model looks like, and most know what a star schema looks like, but what about the structure of a multidimensional database (OLAP cube)? I am assuming it is some sort ...
2
votes
0answers
85 views
Semi-additive measures for other dimensions
I am looking for a way to do semi-additive aggregations on a non-time dimension. The model I am working with is similar to a snapshot inventory warehouse. Specifically I am analyzing processes ...
1
vote
0answers
35 views
How to remove a many to one relation?
I'm currently designing the OLAP cube for my bachelor year major project. It is some how like as given below on the figure.
Here call_date includes date of the call and call_time is of 86400 column ...
1
vote
0answers
45 views
How to calculate run-off triangles?
(Note: This is copy of my question on StackOverflow here.)
Reality description:
We do have a list of projects. In every project there is a lot of accounts. You can do a lot of actions on every ...
1
vote
0answers
98 views
ETL import more dimensions from only 1 column
I was requested at work to learn ETL. I have already created a database without using ETL with some dimensions and consolidations, etc, containing above 1 billion numerical values. Now I have to ...
0
votes
0answers
34 views
When to use MOLAP or Tabular
What choice and factor do I need to consider if I gonna have my data mart database to use SSAS MOLAP or tabular?
Is there a guideline in what context to use MOLAP or tabular?
0
votes
0answers
30 views
How to handle “many columns” in OLAP RDBMS
I have a fact that has around 1K different numerical attributes (i.e. columns). I would like to store this in to a column-oriented DB and perform cube analysis on it.
I tried to design a star ...
0
votes
0answers
27 views
How do I define a Standard Deviation function in Pentaho Schema Workbench
I'm building an OLAP Analysis with Pentaho's BI Suite (Community Edition). Many of my measures are standard deviations of the variables in my fact tables.
Does someone has a tip on how to define a ...
0
votes
0answers
24 views
Refresh ORACLE OLAP cube
I am new at Oracle OLAP programming, and just wanted to know about Cube´s Data Update.
For example, right now I maintained and processed the cube for 2012 data; 2013 data is ready on the fact table ...
