The tag has no wiki summary.

learn more… | top users | synonyms

3
votes
1answer
227 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
27 views

Shared measures in fact tables

I'm working on a star-schema and trying to find a best practise for the database design. I have three (at this moment) dimension tables for several facts. Most of the facts look-a-like (meaning ...
0
votes
0answers
9 views

Managing schema migrations in Mondrian

Managing schema changes across dev, stg, prd is something we do well in our home-grown solution today. Specifically, at least one downstream team consumes our star schema. They're considering ...
0
votes
0answers
20 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 ...