cancel
Showing results for 
Search instead for 
Did you mean: 

Logic question - XDIM_MEMBERSET vs WHEN

Former Member
0 Kudos
46

Greetings,

I've taken on the Admin role for an existing budgeting application that has budgeting calcs built into the default logic. I need to start loading strat plan data to its own category through an input schedule. All the logic is scoped by XDIM_MEMBERSET CATEGORY=BUDGET. Will the default logic still run for the existing Budget data if I send data through a schedule to a category of STRATPLAN? Is there any overhead involved, scanning of records, etc? Would a WHEN CATEGORY IS BUDGET be needed? Basically, when there is logic in default that should only be run for a certain category what is the appropriate method to scope that logic so that it does nothing at all when data of another category is sent to BPC?

Regards

Edward

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Edward,

As a way of introduction, I've written logic for both 4.2 and 5.1, so I'm pretty familiar with the topic. The short answer is that the xdim_memberset command limits the focus of the logic to only members that have data in the budget category. As a safeguard, you could add the when category is budget statement as a wrapper and it will not have a signficant impact to performance and it will ensure that only records with budget will be reviewed by the logic.

Thanks,

Barton

Former Member
0 Kudos

Thank you both for your replies. I'll keep them in mind as I start working with the strat plan.

Regards

Edward

Former Member
0 Kudos

Hi Edward,

SQL logic applies to the region of records in logic module runtime memory whose range is controlled by XDIM_MEMBERSET statement. So in your case range will be CATEGORY=BUDGET. I dont think this logic will have impact when you submit data for CATEGORY=STRATPLAN.

regards,

Lokesh Nandula