Hi Team,
As I see in SAC model the account-measures are stored by default with decimals . In our case we the are measure with Currency.
I have changed the decimal places to this account key figure to 2 decimals , but still values are distributed/ stored with 7 decimals in model after inputting the rounded values from Story at higher node of the hierarchy , the lower leaf members in the model are stored with 7 decimals.
So when we are exporting the data from SAC to BW via Data export services feature via SDA , the data getting replicated to HANA tables same decimal's 7 . When we load the data to BW objects (ADSO) mapped the SAC measure with Amount Info object. In BW, the amount key figures are stored with 2 decimals , due to this during the load the values are getting rounded and stored in BW ADSO table. So due to rounding/truncation the BW values are not machining with SAC values. d
So not sure how to overcome this issue? can you advise ?
Please note that this SAC data is going to be combined with exiting data in SAP BW, so we are using same Amount key figure using to store this SAC forecaster data.
Example : Planned in SAC value 50,000 however in BW it becomes 49,997.86