Calc Manager
Discussion List
-
Checking for NULL in getattributeValue in Groovy EPBCSSummary: we are trying to check if attribute is attached with dimension and if attribute is tagged then users should get a custom message and script execution will stop.… -
OOB Calculation logic of Existing and New Asset in Capital PlanningSummary: Would like to know the high level logic of calculating Existing Asset and New Asset in Capital Planning. Content (required): Hello All, I have added the existin…
-
@CalcMgrExcelXIRR with @XRANGESummary: I am trying to implement excel's XIRR function using @CalcMgrExcelXIRR. When I run this function within the year (using XRange) it works fine but XRange across …
-
Groovy code questionSummary: How can I test for a value in one column in a grid and retrieve the value of the second column if it passes the test? Content (required): I have a grid iterator…
-
Use of cross dimensional operator in the FIXSummary: Use of cross dimensional operator in the FIX Content (required): Hi i need to give a range of specific month and years in a fix. what im expecting to pick using…
-
Substitution Variable error in ASO RuleSummary: Need solution to pass Period range to ASO rule Content (required): We have an ASO Rule where we pass a variable &ActualsRange for period and the rule complains …
-
Rule formula to get balance valueSummary: In business rule, we need to get the balance value of an account skipping zero and missing. Content (required): The business rule needs to get the balance value… -
Update UDA using API/GroovySummary Updating member UDA upon runnen calc ruleContent Hi all, For one of our customers we want to update (assign/remove) a UDA for the entity dimension, triggerd by a…
-
How to best use @CREATEBLOCK in a business ruleSummary: Using @CREATEBLOCK is not working when faced with block creation issues Content (required): When running my calculation rule, I realized that it wasn't working.…
-
Issue with Groovy RuleSummary: The requirement is to transfer the data from one department to another and if in the target department entered headcount is more than available headcount in sou…
-
Passing Month varialbe through Data Managment - ErrorSummary: Setup rule "OWP_Process Loaded Data" run after load in Data Management Rule. Set to run After Load with all the prompts set. Calc Mgr Rule RTP "Month" is set to… -
Projected 12 does not skip none when calculating the averageSummary: Projected 12 does not skip none when calculating the average in rolling forecast Content (required): Hi Im using projected 12 to calculate the sum of current mo…
-
Some shared account members are not cloning from one instance to anotherSummary: Some shared account members are not cloning from one instance to another Content (required): Im having a cloning issue, where some of the account members in the…
-
Exclude members from @sumrange?Summary: I am working in a labor cube, and I have a pool of bonus dollars that is to be split among upper level management, but not among non-mgr employees. Is there a w…
-
Workforce Planning: FTE larger than 1Content Hi, The default range of FTE for adding requisition is 0 to 1. Our client has a requirement to expand this range. I changed it to -100 to 100 in both the custom … -
Calculation Issue in Business RuleSummary: Content (required): Hi Experts, In our implementation, we are having 9 dimensions as Years, POV, Time Periods, Version, Scenario, Account, Product, Cost Centre,…