cancel
Showing results for 
Search instead for 
Did you mean: 

Script logic question

Former Member
0 Kudos
50

Hello,

I need to implement a script logic where-

WHEN TIME

IS %TIME_SET%

WHEN RPTCURRENCY

IS LC

WHEN - SUM UP ALL RECORDS FOUND AND CHECK IF THEY TOTAL OUT TO ZERO

*REC..........and so on.......

So my question is how to implement

WHEN - SUM UP ALL RECORDS FOUND(That are for time period selected and rptcurrency of LC) AND CHECK IF THEY TOTAL OUT TO ZERO

.

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

JohnL
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Zack,

You could try a *CALC_DUMMY_ORG function for each of your dimensions members that have top level parent values:

i.e.

*CALC_DUMMY_ORG ACCOUNT=PARENTH1

*CALC_DUMMY_ORG DATASRC=PARENTH1

etc.

*WHEN TIME

*IS %TIME_SET%

*WHEN RPTCURRENCY

*IS LC

*WHEN GET(DATASRC=#TOTALDSMEMBER,ACCOUNT=#TOPACCOUNTMEMBER, etc.)

*IS 0

*REC..........and so on.......

TOTALDSMEMBER and TOPACCOUNTMEMBER are the top level dimension members in the DataSrc and Account dimensions.

Be careful though because using CALC_DUMMY_ORG's are memory intensive so you may need to restrict the scope of that calculation as follows:

*CALC_DUMMY_ORG

*ORG ENTITY=PARENTH1

*WHERE ACCOUNT = CASH, ACCREC

*WHERE INTCO = NON_INTERCO

*ENDCALC

In the above example the calculation of the hierarchy PARENTH1 for the ENTITY dimension will only be performed for accounts CASH and ACCREC and for the intercompany member NON_INTERCO, even if all accounts or intercompany members have been scoped into memory.

HTH,

John

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Zack,

Can you try something like:

*XDIM_MEMBERSET TIME = %TIME_SET%

*WHEN GET(RPTCURRENCY = "LC")
*IS 0

Hope this helps.