on 02-09-2011 1:42 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Is this still open? If yes let me know it. I can give you some advise on this
regards
Aban
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
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.