Calc Manager
Discussion List
-
Ruleset Validates/Deploys and displays success message, but isn't runningSummary: We have a rule set of 5 rules that validates and deploys without issue. It is connected to an action menu item and when I select it from the right click menu, i…User_2025-02-11-06-55-16-264 23 views 2 comments 0 points Most recent by User_2025-02-11-06-55-16-264 Planning -
Error while calculating loaded Exisiting Employees dataSummary: Encountering error while calculating compensation for loaded existing employees data. Content (required): Once i loaded the existing employees data from HCM to … -
Encountering error while calculating All Existing Tangible AssetsSummary: Facing issue while executing All Existing Tangible Assets Business rule. Content (required): Hello All, Here i tried to calculate Depreciation for all my loaded…
-
Dynamic Member formula to compute ACTUAL (YTD values) + BUDGET (Remaining YTD)Summary: Good morning, I'm trying to learn how to develop a member formula in the dimension editor that will compute the following SCENARIO: The YTD ACTUAL for a given r…
-
Capturing Base salary by Position & Grades in WorkforceSummary: Capturing Base Salary by Position in Workforce Content (required): Hi All, Here we have a requirement to capture the Base Salary by Position in Workforce, By De…
-
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,…
-
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…