Skip to Content
0
Jan 10, 2012 at 01:40 PM

Breake Logic Run by dimension

20 Views

Hi, experts!

We have such logic

*SELECT(%C_R%, "REGION", "P_CC", "ID='%P_CC_SET%'")
*SELECT(%C_FA%, "ID", "P_CC", "REGION='%C_R%' AND DPCODE='FA' AND LEVEL='3'")

*XDIM_MEMBERSET P_DATASRC = KPI
*XDIM_MEMBERSET P_ACCT = F2004030000

*WHEN P_ACCT
*IS F2004030000
*REC(P_CC = %C_FA%)
*ENDWHEN
*COMMIT

We select Cost Center with different one DPCODE (Department Code) in this Region and try write value from it in Cost Center from this Region but with DPCODE = FA.

When we run logic for 1 Cost Center it works perfect.

But then we try run logic for several Cost Centers we got errors in debuglogic.

No records returned by *SELECT(%C_R%, "REGION", "P_CC", "ID='3_ADY_CF_PRO,3_OMS_CF_PRO'")
No records returned by *SELECT(%C_FA%, "ID", "P_CC", "REGION='' AND DPCODE='FA' AND LEVEL='3'")

How can we run this logic only for 1 Cost Center at time, but select in package several cost centers?

For example for first run logic only with 3_ADY_CF_PRO, and Next for 3_OMS_CF_PRO and so on

Best regards

iaroslav