LOOKUP issue with calculated member

[Former Member]

Hi Experts,

I am getting error while using lookup function in custom script logic. I want to read value from calculated members, but it doesn’t work fine. I try to read data from NT_REP_MUVELETI_TERV model, if I use calculated member in LOOKUP on A_NT_MUV_TERV dimension (this is the T_IMP_OSSZEG member) the result is zero, but I use the base member (OSSZEG_TELEPI_ALT) the code works fine.

Other interesting thing: reading from calculated members is work with ERTEKTIPUS dimension in this model (but there are other models, where it isn’t working…)

Why work "read from calculated member" for one dimension and why not for other dimension?

Atteched the code, log, dimension hierarchy, BPC, BW versions

Any ideas are welcome

Thanks

Norbert

BPC code - read from calculated member, result is zero

*XDIM_MEMBERSET ANYAG = "NT_ANYAG_065"

*XDIM_MEMBERSET A_LOGISZTIKA = "A_LO_BR_SZAR_MENNY""

*XDIM_MEMBERSET DUMMYACCOUNT = "DUMMY_ACCOUNT"

*XDIM_MEMBERSET DUMMYENTITY = "DUMMY_ENTITY"

*XDIM_MEMBERSET ERTEKTIPUS = "KALK"

*XDIM_MEMBERSET IDO_HONAP = BAS(2014.TOTAL)

*XDIM_MEMBERSET KH_UZEM = "DUMMY_UZEM"

*XDIM_MEMBERSET KOLTSEGHELY = "342_74621”

*XDIM_MEMBERSET KTGH_KULDO = "DUMMY_KTGHELY_KULDO"

*XDIM_MEMBERSET MUNKAMUVELET = "D_MUNKAMUVELET"

*XDIM_MEMBERSET NT_TABLA = "D_NT_TABLA"

*XDIM_MEMBERSET PROFITCENTER = "D_PROFITCENTER"

*XDIM_MEMBERSET TERMEK = "D_TERMEK"

*XDIM_MEMBERSET VERZIO  = "VERZIO_T01"

*LOOKUP NT_REP_MUVELETI_TERV

*DIM ONKTG:A_NT_MUV_TERV = "T_IMP_OSSZEG"

*DIM ERTEKTIPUS = "T_ERTEK"

*DIM MUNKAMUVELET = "D_MUNKAMUVELET"

*DIM NT_GEPCSOP_ANYAG = "332_64111"

*DIM NT_TABLA = "0300_K1"

*DIM NT_TECHNOLOGIA = "TT_134"

*ENDLOOKUP

*WHEN DUMMYACCOUNT

*IS *

*REC(EXPRESSION=LOOKUP(ONKTG), A_LOGISZTIKA="ERTEK")

*ENDWHEN

*COMMIT

Result:

LGX:

*XDIM_MEMBERSET ANYAG = "NT_ANYAG_065"

*XDIM_MEMBERSET A_LOGISZTIKA = "A_LO_BR_SZAR_MENNY""

*XDIM_MEMBERSET DUMMYACCOUNT = "DUMMY_ACCOUNT"

*XDIM_MEMBERSET DUMMYENTITY = "DUMMY_ENTITY"

*XDIM_MEMBERSET ERTEKTIPUS = "KALK"

*XDIM_MEMBERSET IDO_HONAP = BAS(2014.TOTAL)

*XDIM_MEMBERSET KH_UZEM = "DUMMY_UZEM"

*XDIM_MEMBERSET KOLTSEGHELY = "342_74621"

*XDIM_MEMBERSET KTGH_KULDO = "DUMMY_KTGHELY_KULDO"

*XDIM_MEMBERSET MUNKAMUVELET = "D_MUNKAMUVELET"

*XDIM_MEMBERSET NT_TABLA = "D_NT_TABLA"

*XDIM_MEMBERSET PROFITCENTER = "D_PROFITCENTER"

*XDIM_MEMBERSET TERMEK = "D_TERMEK"

*XDIM_MEMBERSET VERZIO = "VERZIO_T01"

*LOOKUP NT_REP_MUVELETI_TERV

*DIM ONKTG:A_NT_MUV_TERV = "T_IMP_OSSZEG"

*DIM ERTEKTIPUS = "T_ERTEK"

*DIM MUNKAMUVELET = "D_MUNKAMUVELET"

*DIM NT_GEPCSOP_ANYAG = "332_64111"

*DIM NT_TABLA = "0300_K1"

*DIM NT_TECHNOLOGIA = "TT_134"

*ENDLOOKUP

*WHEN DUMMYACCOUNT

*IS *

*REC(EXPRESSION=LOOKUP(ONKTG), A_LOGISZTIKA=ERTEK)

*ENDWHEN

*COMMIT

-------------------------------------------------------------------------------------------------------------------------------------

LOG:

LOG BEGIN TIME:2015-02-27 09:53:00

FILE:\ROOT\WEBFOLDERS\BONAPLAN \ADMINAPP\LO_TERVEZES\TEST.LGF

USER:EXT-LAJOSN

APPSET:BONAPLAN

APPLICATION:LO_TERVEZES

[INFO] GET_DIM_LIST(): I_APPL_ID="LO_TERVEZES", #dimensions=15

ANYAG,A_LOGISZTIKA,DUMMYACCOUNT,DUMMYENTITY,ERTEKTIPUS,IDO_HONAP,KH_UZEM,KOLTSEGHELY,KTGH_KULDO,MEASURES,MUNKAMUVELET,NT_TABLA,PROFITCENTER,TERMEK,VERZIO

#dim_memberset=14

ANYAG:NT_ANYAG_065,1 in total.

A_LOGISZTIKA:A_LO_BR_SZAR_MENNY,1 in total.

DUMMYACCOUNT:DUMMY_ACCOUNT,1 in total.

DUMMYENTITY:DUMMY_ENTITY,1 in total.

ERTEKTIPUS:KALK,1 in total.

IDO_HONAP:2014.01,2014.02,2014.03,2014.04,2014.05,...12 in total.

KH_UZEM:DUMMY_UZEM,1 in total.

KOLTSEGHELY:342_74621,1 in total.

KTGH_KULDO:DUMMY_KTGHELY_KULDO,1 in total.

MUNKAMUVELET:D_MUNKAMUVELET,1 in total.

NT_TABLA:D_NT_TABLA,1 in total.

PROFITCENTER:D_PROFITCENTER,1 in total.

TERMEK:D_TERMEK,1 in total.

VERZIO:VERZIO_T01,1 in total.

REC :LOOKUP(ONKTG)

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY LOOKUP DATA FROM APPLICATION: NT_REP_MUVELETI_TERV

QUERY TIME : 2.00 ms. 98  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

4  RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 4  RECORDS ARE GENERATED.

DATA TO WRITE BACK:

ANYAG   A_LOGISZTIKA   DUMMYACCOUNT            DUMMYENTITY   ERTEKTIPUS      IDO_HONAP       KH_UZEM          KOLTSEGHELY            KTGH_KULDO     MUNKAMUVELET NT_TABLA          PROFITCENTER   TERMEK VERZIO SIGNEDDATA

NT_ANYAG_065  ERTEK   DUMMY_ACCOUNT          DUMMY_ENTITY KALK     2014.05            DUMMY_UZEM    342_74621            DUMMY_KTGHELY_KULDO           D_MUNKAMUVELET         D_NT_TABLA      D_PROFITCENTER           D_TERMEK            VERZIO_T01      0.00

NT_ANYAG_065  ERTEK   DUMMY_ACCOUNT          DUMMY_ENTITY KALK     2014.06            DUMMY_UZEM    342_74621            DUMMY_KTGHELY_KULDO           D_MUNKAMUVELET         D_NT_TABLA      D_PROFITCENTER           D_TERMEK            VERZIO_T01      0.00

NT_ANYAG_065  ERTEK   DUMMY_ACCOUNT          DUMMY_ENTITY KALK     2014.07            DUMMY_UZEM    342_74621            DUMMY_KTGHELY_KULDO           D_MUNKAMUVELET         D_NT_TABLA      D_PROFITCENTER           D_TERMEK            VERZIO_T01      0.00

NT_ANYAG_065  ERTEK   DUMMY_ACCOUNT          DUMMY_ENTITY KALK     2014.09            DUMMY_UZEM    342_74621            DUMMY_KTGHELY_KULDO           D_MUNKAMUVELET         D_NT_TABLA      D_PROFITCENTER           D_TERMEK            VERZIO_T01      0.00

4  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :0.00  ms.

SCRIPT RUNNING TIME IN TOTAL:2.00 s.

LOG END TIME:2015-02-27 09:53:02

BPC 2 second - read from base member - result is good

*XDIM_MEMBERSET ANYAG = "NT_ANYAG_065" //BAS(T_NT_CIKK)

*XDIM_MEMBERSET A_LOGISZTIKA = "A_LO_BR_SZAR_MENNY""

*XDIM_MEMBERSET DUMMYACCOUNT = "DUMMY_ACCOUNT"

*XDIM_MEMBERSET DUMMYENTITY = "DUMMY_ENTITY"

*XDIM_MEMBERSET ERTEKTIPUS = "KALK"

*XDIM_MEMBERSET IDO_HONAP = BAS(2014.TOTAL)

*XDIM_MEMBERSET KH_UZEM = "DUMMY_UZEM"

*XDIM_MEMBERSET KOLTSEGHELY = "342_74621" //<ALL>

*XDIM_MEMBERSET KTGH_KULDO = "DUMMY_KTGHELY_KULDO"

*XDIM_MEMBERSET MUNKAMUVELET = "D_MUNKAMUVELET"

*XDIM_MEMBERSET NT_TABLA = "D_NT_TABLA"

*XDIM_MEMBERSET PROFITCENTER = "D_PROFITCENTER"

*XDIM_MEMBERSET TERMEK = "D_TERMEK"

*XDIM_MEMBERSET VERZIO  = "VERZIO_T01"

*LOOKUP NT_REP_MUVELETI_TERV

*DIM ONKTG:A_NT_MUV_TERV = "OSSZEG_TELEP_ALT"

*DIM ERTEKTIPUS = "T_ERTEK"

*DIM MUNKAMUVELET = "D_MUNKAMUVELET"

*DIM NT_GEPCSOP_ANYAG = "332_64111"

*DIM NT_TABLA = "0300_K1"

*DIM NT_TECHNOLOGIA = "TT_134"

*ENDLOOKUP

*WHEN DUMMYACCOUNT

*IS *

*REC(EXPRESSION=LOOKUP(ONKTG), A_LOGISZTIKA="ERTEK")

*ENDWHEN

*COMMIT

RESULST

LGX:

*XDIM_MEMBERSET ANYAG = "NT_ANYAG_065"

*XDIM_MEMBERSET A_LOGISZTIKA = "A_LO_BR_SZAR_MENNY""

*XDIM_MEMBERSET DUMMYACCOUNT = "DUMMY_ACCOUNT"

*XDIM_MEMBERSET DUMMYENTITY = "DUMMY_ENTITY"

*XDIM_MEMBERSET ERTEKTIPUS = "KALK"

*XDIM_MEMBERSET IDO_HONAP = BAS(2014.TOTAL)

*XDIM_MEMBERSET KH_UZEM = "DUMMY_UZEM"

*XDIM_MEMBERSET KOLTSEGHELY = "342_74621"

*XDIM_MEMBERSET KTGH_KULDO = "DUMMY_KTGHELY_KULDO"

*XDIM_MEMBERSET MUNKAMUVELET = "D_MUNKAMUVELET"

*XDIM_MEMBERSET NT_TABLA = "D_NT_TABLA"

*XDIM_MEMBERSET PROFITCENTER = "D_PROFITCENTER"

*XDIM_MEMBERSET TERMEK = "D_TERMEK"

*XDIM_MEMBERSET VERZIO = "VERZIO_T01"

*LOOKUP NT_REP_MUVELETI_TERV

*DIM ONKTG:A_NT_MUV_TERV = "OSSZEG_TELEP_ALT"

*DIM ERTEKTIPUS = "T_ERTEK"

*DIM MUNKAMUVELET = "D_MUNKAMUVELET"

*DIM NT_GEPCSOP_ANYAG = "332_64111"

*DIM NT_TABLA = "0300_K1"

*DIM NT_TECHNOLOGIA = "TT_134"

*ENDLOOKUP

*WHEN DUMMYACCOUNT

*IS *

*REC(EXPRESSION=LOOKUP(ONKTG), A_LOGISZTIKA=ERTEK)

*ENDWHEN

*COMMIT

-------------------------------------------------------------------------------------------------------------------------------------

LOG:

LOG BEGIN TIME:2015-02-27 09:33:37

FILE:\ROOT\WEBFOLDERS\BONAPLAN \ADMINAPP\LO_TERVEZES\TEST.LGF

USER:EXT-LAJOSN

APPSET:BONAPLAN

APPLICATION:LO_TERVEZES

[INFO] GET_DIM_LIST(): I_APPL_ID="LO_TERVEZES", #dimensions=15

ANYAG,A_LOGISZTIKA,DUMMYACCOUNT,DUMMYENTITY,ERTEKTIPUS,IDO_HONAP,KH_UZEM,KOLTSEGHELY,KTGH_KULDO,MEASURES,MUNKAMUVELET,NT_TABLA,PROFITCENTER,TERMEK,VERZIO

#dim_memberset=14

ANYAG:NT_ANYAG_065,1 in total.

A_LOGISZTIKA:A_LO_BR_SZAR_MENNY,1 in total.

DUMMYACCOUNT:DUMMY_ACCOUNT,1 in total.

DUMMYENTITY:DUMMY_ENTITY,1 in total.

ERTEKTIPUS:KALK,1 in total.

IDO_HONAP:2014.01,2014.02,2014.03,2014.04,2014.05,...12 in total.

KH_UZEM:DUMMY_UZEM,1 in total.

KOLTSEGHELY:342_74621,1 in total.

KTGH_KULDO:DUMMY_KTGHELY_KULDO,1 in total.

MUNKAMUVELET:D_MUNKAMUVELET,1 in total.

NT_TABLA:D_NT_TABLA,1 in total.

PROFITCENTER:D_PROFITCENTER,1 in total.

TERMEK:D_TERMEK,1 in total.

VERZIO:VERZIO_T01,1 in total.

REC :LOOKUP(ONKTG)

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY LOOKUP DATA FROM APPLICATION: NT_REP_MUVELETI_TERV

QUERY TIME : 2.00 ms. 98  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

4  RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 4  RECORDS ARE GENERATED.

DATA TO WRITE BACK:

ANYAG   A_LOGISZTIKA   DUMMYACCOUNT            DUMMYENTITY   ERTEKTIPUS      IDO_HONAP       KH_UZEM          KOLTSEGHELY            KTGH_KULDO     MUNKAMUVELET NT_TABLA          PROFITCENTER   TERMEK VERZIO SIGNEDDATA

NT_ANYAG_065  ERTEK   DUMMY_ACCOUNT          DUMMY_ENTITY KALK     2014.05            DUMMY_UZEM    342_74621            DUMMY_KTGHELY_KULDO           D_MUNKAMUVELET         D_NT_TABLA      D_PROFITCENTER           D_TERMEK            VERZIO_T01      6901505.84

NT_ANYAG_065  ERTEK   DUMMY_ACCOUNT          DUMMY_ENTITY KALK     2014.06            DUMMY_UZEM    342_74621            DUMMY_KTGHELY_KULDO           D_MUNKAMUVELET         D_NT_TABLA      D_PROFITCENTER           D_TERMEK            VERZIO_T01      6860028.45

NT_ANYAG_065  ERTEK   DUMMY_ACCOUNT          DUMMY_ENTITY KALK     2014.07            DUMMY_UZEM    342_74621            DUMMY_KTGHELY_KULDO           D_MUNKAMUVELET         D_NT_TABLA      D_PROFITCENTER           D_TERMEK            VERZIO_T01      4054605.98

NT_ANYAG_065  ERTEK   DUMMY_ACCOUNT          DUMMY_ENTITY KALK     2014.09            DUMMY_UZEM    342_74621            DUMMY_KTGHELY_KULDO           D_MUNKAMUVELET         D_NT_TABLA      D_PROFITCENTER           D_TERMEK            VERZIO_T01      3284178.57

4  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :0.00 ms.

SCRIPT RUNNING TIME IN TOTAL:2.00 s.

LOG END TIME:2015-02-27 09:33:39

A_NT_MUVTERV dimension

ERTEKTIPUS DIMENSION

BPC

[former_member186338 · Accepted solution]

Hi Tibor,

Please look on the following notes:

1)2061621 - *LOOKUP function return zero when dimension member is set as parent node

2)2082344 - *LOOKUP function returns zero when dimension is defined as parent member

But I prefer to use PUSH approach with *DESTINATION_APP

Vadim