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