cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member220487
Active Participant
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

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

regards

Aban

Former Member
0 Kudos

Aban:

Yes it is open. Your question is the only response so far.

Satish