on 2009 Jan 27 2:08 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.