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
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1820942&SiteID=1

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 (
http://eu.wiley.com/WileyCDA/WileyTitle/productCd-0471748080.html), 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:

LinkWithin

Related Posts Plugin for WordPress, Blogger...