I am trying to write script for allocation in PBCS
Dimension:
-Account, dense
-Person, sparse
-Project, sparse
Allocate from:
Account001 -> No Person -> No Project = 100;
To:
Account001 -> Person A -> Project I = 20;
Account001 -> Person B -> Project II = 80;
based on driver:
Driver01 -> Person A -> Project I = 2;
Driver01 -> Person B -> Project II = 8;
Are there any better ways than code below? It runs very slow (more than 10 mins). Are there any ways to make the calculation quicker. Any advice are greatly appreciated.
FIX ("FY19",/*DIM:Version*/"Working",/*DIM:Customer*/"No Customer",/*DIM:Period*/"Jun",/*DIM:HSP_View*/"BaseData",/*DIM:Scenario*/"Actual")
FIX ( /*DIM:Person*/@RELATIVE("Total Person",0))
FIX ( /*DIM:Project*/@RELATIVE("Total Project", 0))
Fix (/*DIM:Entity*/@RELATIVE("T", 0))
SET CREATENONMISSINGBLK ON;
"598099" = {Source_account}->"P000"->"No Project" * 100 / 100 * "Man-hour" / "Man-hour"->"Total Person"->"Total Project";
"598099"(
@xwrite("598099",@loopback,@concatenate("A",@name({Source_Account})));
);
ENDFIX
ENDFIX
ENDFIX
FIX ( /*DIM:Project*/"No Project", /*DIM:Person*/"P000")
/*STARTCOMPONENT:FORMULA*/
{Eliminated_Account} = ({Source_Account} * (100 / 100)) * -1;
/*ENDCOMPONENT*/
ENDFIX
ENDFIX
Thank you!