Script Logic LOOK UP with multiples values selection by DM

[former_member450322]

BPC NW 10.1, BW 750 SP 08, Engine JAVASCRPT

In the model PLANNING we have the following dimensions: ACCOUNT (A),AUDITRAIL (D), TIME (T), CATEGORY (C), ENTITY (E), CURRENCY (R), DIVISION (User Def2), COMPANY (User Def3). We use this model to planning next year expenses. Some expenses are budgeted in currencies other than the local currency. Records in the currency of the transaction will be restated in local currency using rates registered inthe model rates. We prepare possiles scenaries at diferents exchange rate

We want to calculate the amount in Local Currency using DM. The formule is going to be AMOUNT in LC= =AMOUNT in USD_T/ (Rate USD_T/LC)). When user enter or change any rate in currency transaction would ask the new records in LC using a DM.

The Script

IN UJKT we test this script with Data Region:

TIME=2022.01
CATEGORY=Plan

The script logic works ok whith only one member selected in time

RESULT in UJKT:

LGX:

*XDIM_MEMBERSET CATEGORY = Plan

*XDIM_MEMBERSET RPTCURRENCY = USD_T

*XDIM_MEMBERSET AUDITTRAIL = BAS(Input)

*XDIM_MEMBERSET TIME = 2022.01

*LOOKUP Rates

*DIM TIME=2022.01

*DIM CATEGORY= Plan

*DIM R_ACCOUNT="CLO"

*DIM R_ENTITY="Global"

*DIM RATEUSD_T:INPUTCURRENCY="USD_T"

*DIM MEASURES="PERIODIC"

*ENDLOOKUP

*WHEN RPTCURRENCY

*IS USD_T

*REC(EXPRESSION = %VALUE%*LOOKUP(RATEUSD_T),RPTCURRENCY =VES)

*ENDWHEN

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

LOG:

FILE:\ROOT\WEBFOLDERS\DESARROLLO \ADMINAPP\Planning\TEST.LGF

USER:WMORENO

APPSET:DESARROLLO

APPLICATION:Planning

[INFO] GET_DIM_LIST(): I_APPL_ID="Planning", #dimensions=9 ACCOUNT,AUDITTRAIL,CATEGORY,COMPANY,DIVISION,ENTITY,MEASURES,RPTCURRENCY,TIME #dim_memberset=4

CATEGORY:Plan,1 in total.

RPTCURRENCY:USD_T,1 in total.

AUDITTRAIL:Input,1 in total.

TIME:2022.01,1 in total.

REC :%VALUE%*LOOKUP(RATEUSD_T)

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 3.00 ms. 11627 RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY LOOKUP DATA FROM APPLICATION: Rates

QUERY TIME : 1.00 ms. 1 RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :1.00 ms.

11627 RECORDS ARE GENERATED.

CALCULATION END.

SCRIPT RUNNING TIME IN TOTAL:5.00 s.

Bue when is included more Than one value as member dimension in TIME

The validation show an error:planusd-with-a-list.txt

UJK_VALIDATION_EXCEPTION:El componente "2022.01,2022.02,2022.03" doesn't exist

What is wrong in the SL? I have read that LOOK UP cannot be used for a list of values. What could I do if I need to re-write in local currency every month of the next year at the exchange rate recorded in the rate model.

Atach advanced SL

Thanks