Skip to Content
avatar image
Former Member

Diffrence in data between the datasource and planning book

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 31, 2007 at 02:37 PM


    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.



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Somnath Manna

      Hi somnath,

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

      Thanks to Sunitha and Harish for the valuable answers.



  • avatar image
    Former Member
    Aug 01, 2007 at 08:39 AM

    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?

    Add comment
    10|10000 characters needed characters exceeded