EPM old Vaue Retrieval in EPM 10.0 SP29

[former_member574967]

We have a scenario below in our project:

Our end - users work on EPM excel sheet to retrieve the old data from BPC and then they do the comparison with third party data.

For Ex. For June there is 37M records , if they change/update the data in BPC cube via DM package or Input form, for June from 37M to 38M, it is difficult to retract in BPC and show in reports the old value (37M for june) as it get overwritten or added.

They do not have version added in the system as they do not want to change anything that in existing.

IS there any way where we can see this old value prior to update?

[former_member186338 · Accepted solution]

There is no way to see the old value before update!

Only in some specific cases you can use special AUDITTRAIL member to post update results. In this case you can see original values with original AUDITTRAIL - for example UPLOAD

Sample:

You upload third party data into audittrail UPLOAD

Then in DM package you perform some reclassification, posting result to audittrail: ADJUSTMENTS

And you can still compare UPLOAD with original data.

[former_member574967 · Accepted solution]

Thanks a Lot Vadim !! This answers my question.

[former_member186338 · Accepted solution]

P.S. Please change your name to the real one! "M S" is violating forum rules. I will not answer next time!

[former_member574967 · Accepted solution]

done ! Thanks.