LOOKUP in Script Logic

[Former Member]

Dear experts,

I am doing a look up in different application for multiple measures. Also for a DATASRC member, I need to look up at the TOT_SRC level for which I am doing CALC_DUMMY_ORG

Is it supported in BPC NW? The SAP 420 book says it's not supported. If it so, then what's the alternative approach?

I know in MS, we have SUB/ENDSUB to group logic instructions and can invoke wherever we want. Is it supported on NW?

My code is like the below

*LOOKUP TAUX

*CALC_DUMMY_ORG

*ORG DONNEES_SRC = PARENTH1

*WHERE TYPE_TAUX = PCT_TAUX_AUG, SAL_MOY, ECHELON, SAL_MAX

*WHERE CENTRE_COUTS = NA_CENTRE_COUTS

*ENDCALC

*DIM CENTRE_COUTS = "NA_CENTRE_COUTS"

*DIM CLASSE_TAUX=%CLASSE_TAUX_SET%

*DIM DEVISE_ENTREE="CAD"

*DIM DONNEES_SRC = "TOTAL_SRC"

*DIM TEMPS = %TEMPS_SET%

*DIM TITRE_DEMPLOI="NA_TITRE_DEMPLOI"

*DIM VERSION=%VERSION_SET%

*DIM PCTTAUXAUG:TYPE_TAUX = "PCT_TAUX_AUG"

*DIM AVGSAL:TYPE_TAUX = "SAL_MOY"

*DIM ECHELON:TYPE_TAUX = "ECHELON"

*DIM SALMAX:TYPE_TAUX = "SAL_MAX"

*ENDLOOKUP

Appreciate any advice.

Prabhakar

[Former Member · Accepted solution]

Hi Prabhakar

Could you explain a bit further what you are trying to do with the DUMMY_ORG? Is this in your source or in your target app?

For the Lookup I think this should work?

*LOOKUP TAUX

*DIM TAUX:CENTRE_COUTS = "NA_CENTRE_COUTS"

*DIM TAUX:CLASSE_TAUX=%CLASSE_TAUX_SET%

*DIM TAUX:DEVISE_ENTREE="CAD"

*DIM TAUX:DONNEES_SRC = "TOTAL_SRC"

*DIM TAUX:TEMPS = %TEMPS_SET%

*DIM TAUX:TITRE_DEMPLOI="NA_TITRE_DEMPLOI"

*DIM TAUX:VERSION=%VERSION_SET%

*DIM TAUX:PCTTAUXAUG:TYPE_TAUX = "PCT_TAUX_AUG"

*DIM TAUX:AVGSAL:TYPE_TAUX = "SAL_MOY"

*DIM TAUX:ECHELON:TYPE_TAUX = "ECHELON"

*DIM TAUX:SALMAX:TYPE_TAUX = "SAL_MAX"

*ENDLOOKUP

Cheers

Sabine

[Former Member]

HI all,

Thanks for looking at this.

I figured out that, NW doesn't support CALC_DUMMY_ORG, and we can do a LOOKUP at parent member in NW.

Also SUB/ENDSUB are not supported in BPCNW 7.5. The only way to achieve this is having multiple .LGF files for each piece of code and calling them using *INCLUDE.

Thanks