Skip to Content
0
Former Member
Jul 04, 2012 at 12:04 PM

two questions on script logic

16 Views

Hi all,

I know I can use nested *WHEN statements such as

*WHEN ACCOUNT

*IS A

*WHEN CATEGORY

*IS XY

*REC

*ENDWHEN

*ENDWHEN

But should nested *WHEN statements such as this one work?

*WHEN ACCTDETAIL

*IS F_CLO

*WHEN SIGNEDDATA

*IS < 0

*WHEN ACCTDETAIL

*IS F_OPE

*WHEN SIGNEDDATA <0

*REC

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

And secondly, if I use *WHEN SIGNEDDATA with three cases:

*WHEN ACCTDETAIL

*IS F_CLO

*WHEN SIGNEDDATA

*IS < 0

*REC

*IS = 0

*REC

*IS > 0

*REC

*ENDWHEN

*ENDWHEN

would the case where there is no entry in the fact table for F_CLO (for example after an optimisation of because no data has been entered) be captured by the *IS = 0 or do I need an *ELSE?

Thanks,

Arnold