MS SQL Server OLAP - Data copy from one member to another

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Data copy from one member to another

Handerson

2005-04-26, 3:23 am

Hi,

I need to copy all data from one member to another member from the same
dimension.

To be more specific, I have a category dimension with these members:

Category
->Budget
->Forecast

And I want to start my Forecast with the Budget data from last year * 1.05.
Because I will change the values from forecast I can't just put a formula
(forecast = budget *1.05, if I do that the cube will always show the formula
values and not some new values that I want to enter).

Is there a easy way to do that? Any tip will be great.

Thanks,
Handerson

Sponsored Links