Replacing *LOOKUP with MDX Tuples

[former_member192555]

Hi,

I am working on BPC NW 10.1 on HANA and experience substantial degradation of the performance when there is a *LOOKUP function in use. When it is from other models, I am not aware if we can use MDX Tuples to replace LOOKUPS, but when it is in the same model, it is a good option.

Do you know how I can change the following code to MDX Tuples lookup when it is within the same model?.

*LOOKUP PROJECT_PLANNINT

*DIM IN:ACCOUNT = AC_101000

*DIM IN:PROJECT = PROJECT.PARENT //Don't how to refer to member property in MDX Tupple

*DIM IN:CURRENCY = LC

*DIM IN:AUDITTRAIL = INPUT

*DIM IN:CATEGORY = FORECAST

*DIM IN:TIME = TIME.YEAR_INP //Don't how to refer to member property in MDX Tupple

*ENDLOOKUP

//MDX Tuple equivalent will be

([ACCOUNT].[AC_101000],[CURRENCY].[LC]....)

I don't know how I can refer to Member's property like in PROJECT and TIME dimensions. Do you know how?

[former_member186338 · Accepted solution]

You can't use "member property in MDX Tuple"

I suspect that the whole code is not optimized... Please post the full code in line with:

[former_member192555 · Accepted solution]

Vadim, I have a question regarding MDX Tuples, not about optimizing any code. If it is not possible, I will close this discussion.

[former_member186338 · Accepted solution]

I have already answered your question: You can't use "member property in MDX Tuple"

[former_member192555 · Accepted solution]

ok, thanks. This is the correct answer then.