Skip to Content
avatar image
Former Member

How to report multiple versions of data saved in a cube?

Hi:

I have some data in a DP planning area. On a regular basis, I want to save this data and export to a cube through the standard export process from DP Planning area to cube. Each export of the data is a version of the data (not to be confused with planning version). Management wants to be able to compare these versions and see how some of the key figure quantities have changed from one version to the next.

How to design a reporting solution so that a user can see previous versions? Could you elaborate the BW parts of the solution?

Is this a pretty common requirement and if so what is the common solution?

Note that the volume of data is not very high. The number of characteristics in the planning area is about 10 and the number of CVCs is about 200. Having said that, this is critical for management as it supports their S&OP process.

Please give your suggestions. Thanks.

Satish

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 09, 2011 at 10:53 PM

    Hi,

    BW /BI team can help you with this very easily. Its a simple extract to create a WebEx Query & you can compare the data of different versions there.

    Hope this helps,

    Regards,

    Nawanit

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 09, 2011 at 03:23 PM

    Is this still open? If yes let me know it. I can give you some advise on this

    regards

    Aban

    Add comment
    10|10000 characters needed characters exceeded