This discussion is archived
1 Reply Latest reply: Feb 26, 2013 11:19 PM by Journeyer RSS

Business rule logic

sj1208 Newbie
Currently Being Moderated
Hi all,

I have a situation where two of my dimension does the same job. Department dim and cost centre dim with 1 to 1 mapping between them( cant convince ppl on this logic). So in one of my rules i have fixed around 50 departments out of 250 available. now i want the rule to calculate values only for the corresponding costcentres. so i had my rule something like this.
Fix(depart1, depart2, depart3...depart50)
fix(01-01-01,01-02-02,....05-02-05) /* cc codes are the members of this dim*/
{Month}
If(@Jequals(@ALIAS(@CURRMBR("Department")),@CONCATENATE("CC_",@NAME(@CURRMBR("Costcenter")))))
Do something
endif
/* alias if depart member is like CC_01-01-01 resp)*/

But this rule takes long time to run and eventually throws error saying not enough cache space, though ive already increased the caches size to a big number.

Please do help me with this logic.

thanks,

Edited by: sj1208 on Feb 26, 2013 9:03 PM
  • 1. Re: Business rule logic
    Journeyer Journeyer
    Currently Being Moderated
    Hi,

    Your script is doing lot of work like comparing and concatenating the members to get the cost centres.
    Set the cache's in the Essbase configuration file. and use the set commands to refer the high cache value.

    CALCCACHE Default "value"
    CALCCACHE High "value"
    CALCCACHE Low "value"

    This you can use in ur calc script...............
    SET CACHE HIGH;
    SET LOCKBLOCK HIGH;

    Hope this helps.........

    Thanks,
    Sourabh