cancel
Showing results for 
Search instead for 
Did you mean: 

data in planning books and aggregates not matching

Former Member
0 Kudos

Hi All,

I am doing my BI reports using 9A_MALO and 9A_MALA.

Somehow the data of the planning books and data in the aggregates in APO system is not matching. Is there a way we can run some check so that data is refreshed in the aggregates for BI reports to extract?

many thanks for the help...

Tanu

Accepted Solutions (1)

Accepted Solutions (1)

aparna_ranganathan
Active Contributor
0 Kudos

Tanu

From your question i understand you are pulling data to BW from APO planning area at aggegate levels MALO and MALA. One reason why your data in the planning book and data in the aggregate cubes are not matching could be because the demand supply / stock situation could have changed after the last pull to BW. Pull the data again to BW and check .

Also checking the data in the cube is little bit tricky. For example the quantity you see in a single bucket in SNP could be represented as multiple lines in BW cube.

Thanks

Aparna

Answers (1)

Answers (1)

Former Member
0 Kudos

I think you are fecthing data directly from PA for BeX reporting.

Check for one produc-location. - maske none is changing data.

We have used in past and it was matching for MALO and MALORE.