On Dec 30, 3:35 am, JB wrote:
> When adding a bit flag to show which slowly changing dimension value is the
> current one, I find that I then have to include this flag's value in all my
> MDX queries (for each SCD) - is this how it should be done?
> Many thanks.
You shouldn't have to do this. Your slowly changing dimension should
have a business key, which isn't unique, and a synthetic key, which is
unique. When you join the dimension to a measure group, you should
join the slowly changing dimension using the synthetic key. This
means that you will need to either update your fact table to include
the synthetic key as a foreign key, or change your fact table to a
view, which dynamically determines the correct synthetic key based on
the business key and date range.
There are lots of OLAP and data mining demonstrations on
http://RichardLees.com.au/Sites/Demonstrations
Richard
http://RichardLees.com.au
FAQ
Search
Profile
Private Messages
Log in
