Hi Gurus,
I have a simple D-cube for Sales.
Sales versions, Time, Flag for Actual /Forecast.
With every completed month, I want to update the cube intersection input value from 'Forecast' to 'Actuals'.
The intersection is based on Month and version. The cube already has the input as 'Forecast' till the year end. How do I automate the change from 'Forecast' input to 'Actuals' input as each month closes?
Did thought about D-Links and Allocation Tables but I am not sure how to achive this at the cube intersection..
Apprecaite your response.
Thanks.