On-Line Analytical Processing, a class of systems designed for fast calculation, reporting and analysis of aggregate figures.
10
votes
3answers
158 views
Is backing a website by a SQL Server 2012 OLAP cube considered reasonable?
I have been tasked with architecting a solution for a large retail chain. They want to allow each of its 1.2 million customers to log on to a web site to see the distribution of recent purchases ...
0
votes
0answers
37 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?
1
vote
0answers
40 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
30 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
26 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 ...
3
votes
1answer
75 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 ...
1
vote
0answers
36 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
171 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
68 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
46 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
73 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
176 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.
...
3
votes
1answer
216 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?
2
votes
0answers
87 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
101 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
434 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 ...
1
vote
1answer
325 views
SSAS Modelling - many to many with one dimension
I'm having bit of a hard time modelling an OLAP cube.
My analogy is this: I have a list of students. Each one has one Major subject of study, and zero or more minors, up to five in total.
The raw ...
3
votes
3answers
249 views
Handling attributes that are time-variant in a Datamart
I have looked through the entire list of sites, and this is I think the best match. This is not really about database administration, more like database design. Please excuse me and point me to the ...
6
votes
3answers
527 views
What advantages does in-memory OLAP have over traditional systems with significant memory?
Do in-memory OLAP engines have advantages over the traditional OLAP engines backed by enough RAM to contain the entire cube(s)?
For example, if I use a MOLAP engine (SSAS) and GB / TB of RAM where ...
3
votes
1answer
161 views
Connect tables in a cube based on historical data
So this may be the wrong place, and may seem pretty basic, but I'm new to building up cubes, so please forgive me.
Imagine a setup described by the following:
CREATE TABLE [dbo].[Orders] (
...
5
votes
1answer
162 views
How to report on sparse areas of sparse fact table
A source system tracks student attendance for a school district by reporting absence events. Attendance on any particular day can be determined by examining three datasets: school calendar, student ...
6
votes
1answer
724 views
Medians, Modes, Percentiles and OLAP
I'm newbie trying to wrap my head around OLAP, and I have a few questions.
Question 1: Can an OLAP cube store medians, modes, percentiles?
Question 2: Can an user-written MDX query return a summary ...
1
vote
2answers
616 views
How does an OLAP cube database differ from an RDBMS?
Is a cube database, simply an RDBMS—such as PostgreSQL or MySQL—configured for OLAP via a star or snowflake schema? Or is a cube database different from an RDBMS, and if so how?
2
votes
1answer
230 views
OLAP Cube Database - need a to find a consultant / alternative to cognos express
I have a client that has about 10 staff. They want to add business intelligence services to an existing mysql relational database.
It is a database containing purchasing and readership data for ...
1
vote
1answer
559 views
Design of fact table(s) and dimensions tables for data warehouse
Hi i'm newbie in Datawarehousing, how would you model this in a Data Warehouse:
i wish design the Data Warehouse which give the answers of statistics relating to a baseball league
For players
in ...
3
votes
2answers
389 views
Combining retail sales and payment OLAP cubes
I'm using SQL Server 2005 Standard Edition Analysis Services (SSAS). I'm trying to build cubes from a retail OLTP database that can answer these kinds of questions:
List down all products that were ...
