On-Line Analytical Processing, a class of systems designed for fast calculation, reporting and analysis of aggregate figures.

learn more… | top users | synonyms

3
votes
1answer
219 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
1answer
25 views

Combining data of multiple rows in view

I have a table that holds timetracking data of users and looks somewhat like this: projectid activityid worklocationid year week day hours 1 22 21 2014 37 ...
2
votes
0answers
151 views

Geographic Hierarchies in a OLAP Cube / Data Warehouse

Are the following geographic hierarchies correct? Do any US/Canadian area codes cross state/province lines? Do any US/Canadian counties cross state/province lines? Are there countries with counties ...
2
votes
0answers
177 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
57 views

how declaring `hierarchies and level` in SSAS help to improve MDX Query performance?

how declaring hierarchies and level in SSAS help to improve MDX Query performance? I use SQL Server 2008 R2 and I use SSAS and I reading book Professional Microsoft SQL Server Analysis Services 2008 ...
1
vote
0answers
117 views

Need to write MDX for time dimension in Mondrian

This is my Dimesion and Measure: <Dimension type="TimeDimension" foreignKey="ReqDateKey" name="Date"> <Hierarchy name="YQMD" hasAll="true" allMemberName="All Dates" ...
1
vote
0answers
65 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
148 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
18 views

Many people, one event, multiple factors - OLAP

Have a modeling problem here... first the back-story... We deal with accident data on our project, 1 vehicle-crash can have multiple people and vehicles involved, and many associated factors across ...