Skip to Content
avatar image
Former Member

We are doing a inventory implementation in SAP BW on HANA 7.5 SPS4

Hi All,

We are doing a inventory implementation in SAP BW on HANA 7.5 SPS4.we have created a calculation view for master data and we need to join the transaction data with master data in separate calculation view but we are not able to find the non cumulative key figures in external view of ADSO.

Can you please help us in this regard.

Regards,

Prasad V

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 15, 2017 at 09:16 PM

    Non-cumulative key figures are not supported in external HANA views generated for an infoProvider, However you can generate external HANA views for a BEx query if the underlying infoProvider is exposed to external view before. But there are several restrictions especially on time characteristics (Pls Check this SAP Note : 2032830)

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi All,

      I have created the bex query and selected the external hana view but data preview of that view is showing zero values but query was displaying data perfectly.

      Is there any settings need to be checked.

      Regards,

      Prasad V

  • Jun 19, 2017 at 01:54 PM

    Hi Prasad,

    Consider using cumulative key figures instead on non-cummulative key figures. That way, you don't have to worry about quiet time for the 2LIS_03_BX. Just use the _BF and _UM extractors.

    Inventory can the be summed for any point in time by selecting time range (Beginning of time through Desired Date)

    2LIS_03_BX can still be used for creating point in time snapshots (at month end, for example)

    These snapshots cannot be used to tie to general ledger, in materiel movement documents are "back dated".

    Good luck, and let us know what you do.

    John Hawk

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi John,

      We used same extractors only but in our scenario

      We have generated the external hana view using the inventory cube type ADSO.and we designed the master data in Separate calculation view and we need to join the external hana view generated by inventory ADSO with master data view in one calculation view and upon that created composite provider after that we will create BEX query in our scenario.

      but after changing the parameter RS2HANA_VIEW_SET = X the non cumulative keyfigures are not enabled in view.

      Can you please suggest on this.

      Regards,

      Prasad V