This post could be very controversy… I hope to receive comments from you…
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!