cancel
Showing results for 
Search instead for 
Did you mean: 

Diffrence in data between the datasource and planning book

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

former_member583013
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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

0 Kudos

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

Former Member
0 Kudos

Hi somnath,

Thanks for you valuable reply, it has helped in solving our pupose.

Thanks to Sunitha and Harish for the valuable answers.

Regards,

Raj

Answers (1)

Answers (1)

Former Member
0 Kudos

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?