Calc Manager
Discussion List
-
Downloading CSV files from EPBCS Inbox/Outbox Explorer using Groovy scripting and REST APIHi guys, We are trying to download CSV files that are published in Inbox/Outbox Explorer in EPBCS application. We tried to download these files using REST API using Scri… -
How can I clear OFS_Trend assumption values in data formsSummary: OFS_Trends are used in our planning forms and values selected in all our forms are for UAT purposes. Now we would like to clear all data values as well as Trend… -
Encountering issue while calculating Assets with Monthly and Yearly PlanSummary: Issue while calculating Assets with Monthly and Yearly Plan Content (required): Hi All, I'm trying to calculate assets on two methods - Monthly and Yearly.First…
-
Using Groovy to Pass a Smart List Value from form rows (need to pass WITHOUT quotes)Summary: Is there a supplemental Groovy function, or other technique, that can convert a pulled smart list value from a form WITHOUT quotes? Content (required): We are t… -
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 21 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…
-
$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 61 views 6 comments 0 points Most recent by M. Kyle Goodfriend-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 …
-
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,…