Skip to Content
0

Inventory Data Flow in SAP HANA

Jan 05, 2017 at 08:07 AM

49

avatar image

Hello All,

We are trying to Import Non-Cumulative BI Cubes in Hana which are used in the Inventory for calculating the Final stock balance based upon the Inflows & Outflows. When these BI Cubes are Imported into Hana via “Import BW Objects in HANA” the Non-Cumulative Key Figure (Total Stock Balance) fails to appear in HANA contributing to the fact that these Non-Cumulative Key Figures are calculated on the Fly outside BW

We are unable to directly importing the BW Model (Non Inventory Cube) into Hana as we are on BW 7.3 SP08 and direct import is possible only from the version BW 7.4

The only solution we have got so far is to calculate the Non cumulative Key figure in Hana using a script view.

I have successfully achieved to calculate the Non cumulative balance at the end of each day. But due to the Aggregation at the end in Hana the Non Cumulative calculated Key Figures gets aggregated at the end which makes the whole calculation incorrect

Need your suggestion in this case where we can Import these Cubes in Hana with the Non-Cumulative Key Figure (Final Stock Balance) or any other work around where these Non-Cumulative Key Figures could be emulated in Hana

Current BW Version :- BW7.3 SP08

Current Hana Version:- SP12

Kindly let me know your thoughts.

Regards,

Vinoth V

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers