Thursday, July 12, 2007

SSAS - Slowly Changing Values

Dear Friends,
This post could be very controversy… I hope to receive comments from you…

The Problem

The Solution
Using the Transform Slowly Changing Dimension, I think the performance would be worst (but maybe I’m wrong), and is more useful when you need the Data in the IS. So, inside of one of the best books I have in home, MDX Solutions (, I found the solution for my problem in the page 84 (Chapter3)

The data inside my FactTable that has the values to create historical data in MDX:

I hope the get comments to it!
Thanks and regards!

No comments:


Related Posts Plugin for WordPress, Blogger...