Dear Friends,
I posted a question in Microsoft Forums, and I describe here the solution founded
Problem:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1720487&SiteID=1
Solution:
I created a view in database filtering only the valid dates in the table Time.
The datasource view in Analysis Services:

Exploring Data in TIME dimension:Exploring DATA in CASHFLOW Dimension:

And the named calculation to calculate the difference between current and previous:
And in the brower of the cube:
Please let me know if you think that could be a better solution!
Regards!
No comments:
Post a Comment