Calc Manager
Discussion List
-
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…
-
Is there a way to pass entity selection as RTP for data load rule in data integration?Content Team We have two separate instance like Finance and workforce due to security reasons. As part of monthly business activities 30 brand users are supposed to send…