Calc Manager
Discussion List
-
Getting Error while using [[PlanningFunctions.getUserVarValue("xyz")]]Summary: we are using [[PlanningFunctions.getUserVarValue("OEP_Scenario")]] and [[PlanningFunctions.getUserVarValue("OEP_Version")]] in business rule, we have user varia…Vanipenta Sreenivas 82 views 2 comments 0 points Most recent by N.S - Navulla Saikrishna-Oracle Planning -
Assign UDA Using GroovyHello everyone, I want to update the UDA of a member list based on the smartlist selection. Ideally, the calc would create the grid, read the value, and assign the UDAs.… -
How to get the first member of a substitution variable?Hello everyone, I am trying to get the first member of a substitution variables. I created a substitution variable called "YearRange" and set it is "FY24:FY28": So my qu… -
How to use Datacopy in If statement?: EPM Buisiness ruleI wrote a buisiness rule which copy data from a version to another version. In the rule, I want to use 'Datacopy' in 'If' statement but the following error is displayed.…
-
Changing background color to cell in data froms using GroovySummary: Requirement to change the background color for a data cell based on certain condition Content (please ensure you mask any confidential information): Hello, We n…
-
Ruleset variable questionSummary: Content (please ensure you mask any confidential information): Hi, Got a question about Ruleset variables. I have ruleset_1 with 2 rules which have common RTP o…
-
Ruleset parallel execution issueSummary: Content (please ensure you mask any confidential information): Hi, I got a weird issue when running a ruleset with parallel execution enabled, and want to seek …
-
Calculation for Employee that Terms Mid-MonthSummary: In our Workforce cube/module, is it possible to calculate partial month data for an employee that terms mid-month Content (please ensure you mask any confidenti… -
Error When Saving DataGrid in Production - "An error occurred while processing this page"Hi Folks, I have encountered an issue when calling the saveGrid() method to save a DataGrid in the production environment, which works fine in the cloned environment. He…
-
info about calculation manger related to latest feb release.with February release the web interface of Oracle will change a lot! in particular Calculation Manager is accessible from “rule” tab. From our knowledge users should not…
-
Account in @REMOVE is being ClearedSummary: Content (please ensure you mask any confidential information): I use the below business rule to clear expense accounts before loading a new employee roster and …
-
(Please ignore the post) Calc Mgr error validating @ISMBR functionSummary: Content (please ensure you mask any confidential information): Hi, Just in a sudden, a business rule that previously validated and deployed successfully now got…
-
Business rule assignment to the planning formsWas there any easy way to search business rule and assign to the planning forms , Currently i am scrolling down through the 100's of rules to find a business rule and as…
-
Can you create folders in calculation manager?Summary: Content (please ensure you mask any confidential information): In our calculation manager, we have a lot of custom rules that were created during implementation…
-
Script analysis throwing an error with substitution variableI'm attempting to make a business rule quicker, so I'm doing a script analysis on it. The rule validates and functions with no errors; however, when I try to do a script…
-
Business Rule Performance Question Datacopy vs FormulaSummary: After reading some posts that have been circulating here and on other media, I decided to try and optimize a script formula, but I'm not getting expected result…
-
Hide Columns validating a condition through groovySummary: I would like to validate a condition of row member and hide columns which does not satisfy that condition. Content (required): Looking for a groovy logic to see…
-
Validation not working in Calc ManagerSummary: One of my business rules is failing for validation. I have 3 members which have had names changes, and wondering if, although the refresh of the Planning Outlin… -
How can I convert a member to a string to populate a Smart List value?Summary: I am trying to derive a Smart List value using a member, where the Smart List has been build from the Period dimension. Content (required): Below is an example …
-
Groovy Dataexporter is not exporting Dynamic Calc membersSummary: Hi, I need to export data from EPM Planning BSO cube with "Alias". So I need to use Groovy Rule because Data Export Calc command BR create Member Name in file. …
-
How do I use an attribute in a workforce business ruleSummary: Content (required): When we copy data from workforce to the plan cube, we need to break out the employees by Class. We do not have Class in the Workforce cube, …
-
Member formula for opening balance calculationSummary: Content (please ensure you mask any confidential information): I seem to be experiencing what looks like a circular reference in a member formula for a BSO cube…
-
Issue with getEmailAddress() Method in Oracle EPM Groovy: "Email Doesn't Exist" ErrorHi Folks, I'm encountering an issue in Oracle EPM when using the getEmailAddress() method of the User class in Groovy. When I call operation.user.getEmailAddress(), I re…
-
Find a substring in an Alias and compare to textSummary: We have a standard PBCS license (so no Groovy Scripting) and I am trying to analyse member aliases on the Entity dimension to see if there is a matching substri…
-
Dynamic Children and Groovy saveMember questionSummary: Content (please ensure you mask any confidential information): Hi, With Dynamic Children enabled for a "Dynamic Calc" parent, and use Groovy(non-REST API) to ad…
-
How to know what is the data input and what is the calculated data?Hello everyone, I have one question about the business rule calculation functions. Can any calculation function be used in business rules to extract only inputted data? …
-
Block Creation in EPBCSHi, I have a below Business rule having a block issue, I tried @createblock and Set commands Still not able to resolve it, your advice is appreciated. SET FRMLBOTTOMUP O…
-
Groovy Scripting in EPBCS ASO CubeSummary: Hi Guys, Have a requirement to do Currency Conversion(USD to CAD) within the reporting cube(ASO) of EPBCS. Currency Conversion should happen once the Data get l…
-
Salary web form calculation issue when changing versionsHi, I have come across an issue with a salary web form. When entering a salary line with a start date and no end date salary is calculated for not just the current finan…
-
Dynamic Calc members are not aggregating when CALC DIM is used onceHi all, We have a sample hierarchy as below. Below are the member properties. Net Sales: Store, Two Pass Calculation - Enabled Gross Profit: Store, Two Pass Calculation …