Calc Manager
Discussion List
-
Dynamic Substring Function - Essbase Equivalent of FIND/SEARCH Function from ExcelSummary: We have a need to perform dynamic member name lookups with member names that are varying lengths (something outside of our control as they come from a source sy… -
Non-Groovy: Transfer of Member into Smart Lists created from MembersHello everyone, I have a smart list called TransactionCompany created by @ILvl0Descendants(TransactionCompany) member. And I have a dimension called "Company". Now, I wa… -
Need help for block creation issue in business rule for Hybrid BSOSummary: Can anyone help us for block creation. Other than below 4 options do we use any other set command or function to create block for hybrid BSO cube. So that Block… -
summing does not occur as expectedSummary: Content (please ensure you mask any confidential information): Hi I need to get the sum of all the level 0 accounts, level 0 cost centers, where a member is tag…
-
Issue while running business rule - An error occurred while running the specified calc scriptSummary: Issue while running business rule - An error occurred while running the specified calc script Content (please ensure you mask any confidential information): We …
-
SET CREATEBLOCKONEQ does not open the blockHello everyone, I wrote a business rule with SET CREATEBLOCKONEQ to open the block. But it showed strange behavior. I fix from FY25 to FY28, BUT it did not open the bloc…
-
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…
-
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…