Conditionally run an AGG
Content
Hi, I have a rule with an RTP of type "member". What I'd like to do is aggregate a dimension only if the RTP value is a certain member.
In the past I've done something this to aggregate the entity dimension for the Actual scenario only if rtpScenario = Actual otherwise don't agg. I'm wondering if there is another way so I can shorten my potential code. Possible through design time prompts (i haven't really used them)? any other elegant way?
SET EMPTYMEMBERSETS ON;
Fix ( "Actual" And {rtpScenario})
Fix(final)
Agg(entity)
endfix
Endfix
Tagged:
1