Native HANA MDX Lookup/Destination_app Function?

[former_member192555]

Hi Guys,

I have a BPC 10.1 SP10 on HANA and I would like to make some tests what is the difference between using MDX tuples vs. WHEN/IS/REC/ENDWHEN. As well as IIF vs REC( A>B ? C : D).

I have enabled the ENABLE_HANA_MDX and ENABLE_NATIVE_HANA_MODEL. Do you know if I need to switch K2_CALC_ENGINE as well?

Do you know what else is recognised as native HANA MDX functions aside from the SE37/BAPI_MDPROVIDER_GET_FUNCTIONS? Are there a LOOKUP/Destination_APP equivalents for MDX?

I also wonder what will be the difference if a particular logic script is written entirely in MDX or in combination with the standard SQL statements.

[former_member192555]

Ok, so ai am playing with simplified function and trying to use LookupCube. However, it is saying that INPUTCURRENCY is not part my current model when I try to validate it. Do you know if this functions works?

*Function TRANSLATION(%CURR%)

(LookupCube(Rates,([R_ENTITY].[Global],[R_ACCOUNT].[AVG],[CATEGORY].[ACTUAL],[INPUTCURRENCY].[%CURR%],[TIME].[2015.01]))

*ENDFUNCTION

*Function TRANSLATION_QUOTES(%CURR%)

(LookupCube("Rates","([R_ENTITY].[Global],[R_ACCOUNT].[AVG],[CATEGORY].[ACTUAL],[INPUTCURRENCY].[%CURR%],[TIME].[2015.01])")

*ENDFUNCTION

[TIME].[#2015.12] = TRANSLATION_QUOTES(USD)