September 28, 2015 at 4:44 am
Hello there
I'm having DWH which is fully SCD2 - both fact tables and dimensions are equipped with valid_From/valid_to, but some unknow reason when i process the cube, then it grabs everything that is needed from fact table, but dimension is grabbed only the very first value, not changed. Example below:, am i missing something?
Dimension:
ID (PK) name valid_from(PK) valid_to
1 A 2015.01.01 2015.09.25
2 B 2015.01.01 2099.12.31
1 Ax 2015.09.26 2099.12.31
fact
FKEY value Effectidate
1 1000 2015.01.01
1 2000 2015.09.26
2 3000 20015.09.01
expected result ( join is on ID and valid_from=effectidate)
A 1000
Ax 2000
B 3000
I got :
A 3000
B 3000
For some reason, as you can see, MSAS is grabbing only A, but also I need Ax for values after 09.26.
I've enabled 'Ignore error' option and cube processes well, btu most likely i';m missing something?
many thanks in advance, Mikel
September 29, 2015 at 5:33 am
Hi Mikel,
This has been covered before on these boards: http://www.sqlservercentral.com/Forums/Topic1065481-17-1.aspx
SSAS won't just "know" about SCD2, you have to tell it and ensure that your logic is in place.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply