Skip to Content
0

How to use Non Cumulative Cubes in Hana

Dec 26, 2016 at 11:30 AM

264

avatar image

Hi

I am trying to implement the Non cumulative Cube (Inventory Cube) functionality in Hana. 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

Here directly importing the BW Model (Non Inventory Cube) in Hana is not possible as the Non Cumulative BW Cube in Hana can be imported only from BW 7.4 version or higher whereas we are on BW 7.3 SP08 in which the Non Cumulative Key Figure fails to appear

Is there any way around to deal with Non Cumulative Key figure in Hana with BW 7.3 or can they be dealt with the Scripted View in Hana where the Aggregation part is the road block

Regards

Kunal

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

1 Answer

Diego Seben
Dec 28, 2016 at 05:01 PM
0

Hi Kunal,

It seems this is available only from BW 7.4, read SAP note 2032830 - External SAP HANA view: Inventory key figures (non-cumulative key figures)

Regards,

Diego Seben

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Diego

Appreciate your response I totally agree with your point & I have already gone through the Note 2032830, but since upgrading the BI from 7.3 to 7.4 is quite a big thing likely to say not practical in a short span. I had gone through bunch of SAP Notes & Blogs but didnt found the solution for this, even raising an incident I got the same response as of yours.

so I just wanted to make sure whether something exists with the 7.3 Version of BW or before 7.4 this was not possible at all

0

Hi Diego,

We are on SAP BW on HANA 7.5 but we are not able to seen the non cumulative key figures in external calculation views of ADSO.

Can you please suggest on this if is there any prerequisites are there .

Regards,

Prasad V

0