on 07-31-2007 3:19 PM
Hi All,
I have loaded the historical data from an infocube into my planning area then i generated the forecast. In our planning book we have provided some keyfigs like market intelligence etc.,. i have written a macro to add the baseline forecast and market intelligence and saved into a seperate keyfigure, i have defined the macro as a default macro and the macro execution is at "details only". everything is working fine in my planning book.
After extracting the data from my planning area into a datasource, the data is not matching between planning book and the datasource <b>only for the keyfigures which i have written macros.</b>
Please let me know where i have gone wrong and what are other settings to be made to replicate the same data into my datasource.
Hi,
Please note that system never execute the macro while extracting data from planning area to infocube.If you want that data to be saved it is
necessary to copy the values to a "non-calculated" liveCache keyfigure.
Each time, you will reenter in the planning book, the new value
calculated will be displayed, it won't be the real current value
from the livecache, it is not inside until you saved.
If you don't save this result, this is only visible on the grid but not
in the planning area and livecache.
Everytime planning book is opened the values for keyfigures which is calculated from macro are re-calculated. If you save these values and
immediately afterwards extract the data, those numbers will be the
same. However, maintaining new values in the planning book without
saving would result in "differences" ...
A DEFAULT macro is also launched while starting the Planning book.
Please read carefully the note #674238.
Regards,
Sunitha.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Thanks for your prompt and helpful reply . I have read through the solution but would need a bit of more clarity on it.
Do you mean to say that i need to add additional key figures in the planning book to copy the macro results or do i need to judiciously place the macros in default , level or start.
could you throw some more light on this, so that i can get the exact data in the datasource.
Regards,
Raj
Hi Raj,
Put the logic for default macro (summation) in a separate macro. Execute that macro as a background job at appropriate details level prior to data extraction. For the purpose of performance you may lik to create a data view with just the required keyfigures, specific time horizon and place the background job macro in that data view.
This should take care of your requirement.
Thanks,
Somnath
Did you ensure the planning book (planning area) is replicated to the data source just after the macro is run and saved
Do you have the similar bucket profiles in the book and the planning area/datasource?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.