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…
-
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…
-
$value is being considered as variable in REST API get method (SharePoint Integration)Hi guys, I am trying to get data from a CSV file which is uploaded in SharePoint to EPBCS application. From Sharepoint REST API, using the following Source URL GET https…
-
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…Sabrina Greensea-166456 21 views 6 comments 0 points Most recent by Kyle Goodfriend, In2Hyperion-Oracle Planning
-
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 …
-
ASO Calculation Script Very Slow!Hi, We have an ASO Freeform application and I am trying to calculate prior year retained earnings using the formula template using the following script, but it is taking…
-
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…
-
Automate Data Copy with commentsSummary: How to automate a datacopy with comments, supporting details and attachments ? Content (required): Hello everyone, My client is currently on Planning On Prem 11…
-
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…
-
Ruleset : Parallel executionSummary: Rulesets are created with nested rulesets enabled for parallel execution Content (required): I want to run ruleset, enabling parallel execution tick. some of th…
-
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,…Thulya Perera 31 views 6 comments 0 points Most recent by Kyle Goodfriend, In2Hyperion-Oracle Planning
-
How to refresh a form using a groovy rule?Summary: How to refresh a form using a groovy rule? Content (required): Dear all, I've written a Groovy rule to add some complex control before saving data. This rule is…Alain Mathon 32 views 5 comments 1 point Most recent by Kyle Goodfriend, In2Hyperion-Oracle Planning
-
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 …