Page 1 of 1
Holding the value
Posted: Fri Oct 01, 2010 2:27 pm
by 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
Re: Holding the value
Posted: Fri Oct 01, 2010 4:47 pm
by rkaif
You can have a Control Cube or a Lookup cube to store the value of Previous Month Cash paid
Re: Holding the value
Posted: Mon Oct 04, 2010 7:44 pm
by 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...
Re: Holding the value
Posted: Mon Oct 04, 2010 10:22 pm
by 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.