Calc Manager
Discussion List
-
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,…
-
Get Previous Month Balance in CalculationContent Hi All, We have defined a business rule using the formula template to derive a value for an account (Business Rule details are attached for your reference). Our …
-
Data load mapping in data managementContent Hi I have one source value which needs to be mapped to two different target values. How to do this in data management Version 21.04.06
-
Can't see the Business Rules in Calc Manager after LCM importContent Hi All, I did LCM of a business rule in projects from Dev environment to Prod. After the LCM, in prod environment, I can see the business rule in the rules card,…
-
Refresh Database in Calc Script or Form?Content Hi guys, We have set up in our PBCS that an user can create a member via an action menu. That this member can used by the user in calculations, a refresh of the … -
Can planning expression be used outside OEP_WFP, e.g. OEP_FS?Summary Can the planning expression [TimeBalanceSpread] be leveraged outside OEP_WFP?Content Is it possible to use [TimeBalanceSpread] in a business rule outside OEP_WFP… -
Business Rule is not workingContent Hi Experts, We have created a business rule to allocate rent expenses across departments based on the square feet. An example is attached for your reference and …
-
Groovy to Get Metadata from Action Menu RowSummary Running a business rule from action menu on a row in a form and need to get metadata from that row.Content I am writing a custom employee transfer rule in groovy…
-
Groovy rule calling RESTAPI PLAN_TYPE_MAP - not workingContent I am working on a groovy rule to call a REST API for running a data map. I would skip the API and use a smart push, however I want to bypass dimensional security…
-
YearTotal in rolling budgetContent Hi We are configuring rolling budgets on a 12 month basis. So for most calculations, summation of 12 months value is needed. For static budget, we use "Yeartotal…
-
Essbase Function for tolerance rangeContent Hi is there any essbase function to give a tolerance range. Like i need to use in an if condition. If the certain account value exceeds by the tolerance value, f…