On-Line Analytical Processing, a class of systems designed for fast calculation, reporting and analysis of aggregate figures.
0
votes
0answers
26 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
27 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
26 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 ...
3
votes
1answer
173 views
How do I display subtotals in cube browser in SSAS 2012 (Sql Server Data Tools)?
Apparently this feature was available in previous versions but has now been removed.
What are some alternatives?
3
votes
1answer
57 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 ...
0
votes
0answers
23 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 ...
1
vote
0answers
34 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 ...
6
votes
2answers
146 views
SSIS Validation slow. OLTP OLAP running on same server
I have four identical servers 2 are used in production and the other two are demo machines/emergency fail over boxes. The more powerful machine a 16 core 127 gigs of Ram hosts both our Datawarehouse ...
0
votes
1answer
64 views
Is it possible to drop data from OLAP database (and to keep definitions)?
[SQL Server Analysis Services from MS SQL Server 2008 R2 Standard]
Our OLAP DB takes data from OLTP DB. We want to make some changes to its structure and to do this - it would be helpful if we could ...
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 ...
2
votes
0answers
68 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 ...
0
votes
1answer
151 views
Storing 5TB web server access log vs OLAP DB
We have over 5TB compressed web server log in a HDFS and we often analyse using Hadoop.
It is painful to run map reduce on 5TB of data and most importantly, not many developer are familiar with it.
...
2
votes
0answers
83 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
94 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 ...
1
vote
3answers
395 views
Oracle OLAP option
I'm considering giving a try to the Oracle OLAP option. Can anyone share their experiences with it? I didn't find much discussion/blog activity on the subject.
In particular, I'm interested in ...
