Holding the value

[ravikrishna23]

Hi..

Consider the scenario
cash Paid out for Sept'10 = 200 $
Now I would like to retain this value as Previous Month Cash paid once the Month changes to Oct.

I cannot go for the calculations again becoz the values will be different.

Can someone help me out...

Thanks

[rkaif]

You can have a Control Cube or a Lookup cube to store the value of Previous Month Cash paid

[ravikrishna23]

Thanks for the quick response..
However, the issue is that we do not have a TIME dimension in this cube...
ofcourse, we are capturing the dates for the records but there is no specific time dimension... and it is not possible to insert the time dimension too

Could you please suggest me if there is any other alternative or can we still go ahead with the lookup cube method...

[rkaif]

Your question is not very clear to me. It will be helpful if you could post some screen shots or upload your Cube file here.

Please read the topic "Request for assistance guidelines" http://forums.olapforums.com/viewtopic.php?f=3&t=1037 and explain your problem clearly.