Can this be done with cubes?

Please let me know if this can be done with cubes, or if I need to approach the problem differently.

I have some part information with a cost and date associated with it. I want to be able to look at the price year to year to see how it changes.

I believe this means I need a calculation, and the calculation must cross time periods. Ultimately, I would like to look at this by year, quarter, or month. Is this even possible?

Thanks for your feedback!

Yes it's possible.

First see my post in my blog, and next try to give more details about what you need!!

http://pedrocgd.blogspot.com/2007/07/ssas-slowly-changing-values.html

regards!!

|||My measure table is part data. I have a few dimensions--what part of our organization purchased the part, the company that sold us the part, and of course, time.

Our goal is to analyze part cost over time. The desired calculation is change in part cost from time period A to time period B. We would like the user to be able to select a time period A and time period B (for example, Quarter 1 of 2007 and Quarter 2 of 2007), and then see the change in part cost over time.

Also, my goal is to be able to show this value rolled up in the dimensions above, by organization and company we purchased the part from.

Hopefully this helps. If you want more information, please let me know. Thanks for your help.
|||

Hi John,

Maybe you should have a look at this:

http://sqljunkies.com/WebLog/mosha/search.aspx?q=relative+time&p=1

HTH,

sql