The tag has no usage guidance.

learn more… | top users | synonyms

4
votes
1answer
327 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 ...
3
votes
0answers
531 views

How to insert values into Bridge Table in star schema?

I am modelling my database with respect to star schema with bridge tables. My master Table looks like below. I need to convert this format to star schema. MasterTable StudentNumber | Subject1 | ...
1
vote
0answers
79 views

how many fact tables do I need given I want to build an OLAP for Quotation Line Item and Purchase Order Line Item report?

My client wants a report that looks something like this on a daily basis. +---------------+-------------------------+-----------------+---------------------+-------------+ | ProductNumber | ...
0
votes
0answers
3 views

Replicator service for OLAP star schema

We have a table which has dimensions as its own column. That table needs to be converted to a star schema for OLAP. We cannot use degenerate dimensions. MySql is our datasource of the existing table. ...
0
votes
0answers
19 views

How many degenerated dimensions should be stored in Fact table

How many degenerate dimension should actually be stored in a fact table? I am building a star schema and have to store some columns (10 of them to be precious) which are on a per transaction level. ...
0
votes
0answers
37 views

SSAS bridge table with Slowly changing dimensions

I am designing a datamart using the basic principles of Kimball for use in SSAS. I have a many many to many attribute relationships (multi-valued dimension objects), however I have a few questions: ...