Calc Manager
Discussion List
-
Rule take a long time to completeThe Below rule takes 5 minutes. STI Provision"->"OWP_Expense Amount"=(@XREF(EPBCSREPCube,"No Job","No Employee","No Component","No Cost Center","No Functional Area","No … -
SmartPush with Groovy failed and very slow. Error Threshold: 500000Hello experts, I have a form with moreless 400 rows, and user should inform these 400 rows with different values. in Rows I have four dimensions with different combinati… -
FCCS : executeCalcScript(java.lang.String) is not allowed RuleSummary: Groovy function to executeCalcScript is not working in FCCS Content (please ensure you mask any confidential information): getting below error while trying to e…
-
Evaluate a account defined as TEXT data typeSummary: hello, I have one member in the Account dim (dense) defined as a text. I need to evaluate the content of that member in a business rule. I'm hoping with yoru in…
-
how to run REST API ADD_USERS_TO_GROUPGroovy is undoubtedly a wonderful tool, it has allowed me to run jobs through REST API export and import data, metadata, security, mass rename members, form operations a…
-
Groovy-Randomly receiving "The form GroovyDataGrid_# is invalid" error that works perfectly on rerunSummary: We have rules that will occasionally fail with the above error but work perfectly when rerun with no changes. Content (please ensure you mask any confidential i…
-
Best way to move data bso to aso for level 0 dynamic calc members in account hierarchyIn epm cloud planning, how to move data between data from bso to aso for a dynamic calc account dimension member with formula as below? @@SUMRANGE("I_4-7",@INTERSECT(@AT…
-
Groovy - how to print real-time log message in job console?Summary: Hi, I have a Groovy rule with long-running processes, for example the process needs to be iterate through 100 times for different combinations. I need to watch …
-
Debugging Rules in EPM planningWe have few Rules in EPM planning and budgeting - Profit cube which calculates the costs/revenue based on few allocation account drivers and then it allocates them acros…
-
Groovy setSuppressMissingSuppressesZero never workSummary: Hi, With a groovy rule to build a grid like below for reading data FlexibleDataGridDefinitionBuilder gdb = cube.flexibleDataGridDefinitionBuilder() gdb.setSuppr…
-
Not able to Hide Prompt when a Ruleset consists of two business rules from different cubesSummary: Though all the "Hide Prompt" properties are ticked still the user gets the prompt when executing from the actions menu Content (required): We have a requirement…
-
epmautomate exportEssbaseData is it same as calculation manager export data>Summary: epmautomate exportEssbaseData is it same as calculation manager export data> Content (please ensure you mask any confidential information): hi All, We were eval…
-
General aggregation questionI was curious as to what might be causing an aggregation to take significantly longer when run for a different fiscal year, all other things being equal. Each fiscal yea…
-
@count usage in a divisionSummary: Greetings, I'm using @count in a rule file in Planning to get the number of records for a particular intersection. Works well, the result comes back correctly. …
-
Error in groovy, The following Date is Invalid: .Hi all, we are trying to retrieve data from multiple projects in EPBCS in ASO cube we are using datagriddefinitionbuilder to read the data from the above accounts as bel…
-
Essbase cache data is fullHello experts, I have a problem with essbase cache. In production environment it works fine, but when I copy the snapshot to test and execute rule I have this problem: H…
-
Possible to derive the start month of prior sibling of selected Scenario in RTP?Summary: Hi there, We have our regular scenarios and we have created Staged Scenarios for each of them. These Staged scenarios deal with the periods prior to the open pe…
-
How do I use @ATTRIBUTE in business ruleSummary: Need a business rule using attributes to breakout costs into another entity/account Content (please ensure you mask any confidential information): I've used @AT… -
Securely storing a client secret for REST API OAuth2 Authentication in Groovy ruleSummary: Where can I securely store a client secret token for use in a REST API call in Groovy. Content (please ensure you mask any confidential information): I need to …
-
groovy assign variable value to rtpSummary: Assign variable value to rtp for essbase calculation part Content (please ensure you mask any confidential information): Hi All, I have retrieved the prevData v…
-
Passing all Dimension value to a single intersectionHi, We need to pass all values in a particular dimension(Functional Area) to a dummy account Eg Dummy accounts created. Amortisation of Intangible assets_Dummy Lease Dep…
-
Groovy - The form GroovyDataGrid is Invalid when DataGridDefinitionBuilder is usedHi all, In an ASO cube, we are using CsvWriter and DataGridDefinitionBuilder to iterate through each account to generate a CSV file in Inbox/Outbox Explorer. while using…
-
What is the Maximum Calcparallel Setting Recommended (limit)Summary: I'm trying to find out what would be the maximum recommended setting that calcparallel could be set at in EPBCS. Is there any documentation about the limit of t…
-
Script DesignHi, We have a requirement when a smartlist value is selected for a particular intersection, we need to identify all other intersections that use the same smartlist value…
-
Create or Update All Substitution Variables Defined for the ApplicationHello, I am trying to leverage "Update Substitution Variables " REST API and below is the code: Through Postman it is working fine. I am trying to execute it as I did fo…
-
Creating via Groovy Rule the Excel file needed for the update of Cell-Level SecuritiesSummary: We would need to create and populate the two-tab-based Excel file needed for the Cell-Level Securities update. Is there a way to do so? Content (please ensure y…
-
Is it possible to have a specific message show when throwing veto exception on a form rule?Summary: If a rule has a veto exception triggered when launched on save of a form it doesn't show the message on the pop up on the form, just that the rule failed. Conte…
-
Delay in calc manager to recognize new Smart Lists/Variables?Summary: I created a new SmartList within Planning and new Variables in Calc Manager. The SmartList isn't showing in the options for variables and the variables are givi…
-
Download CSV file from EPBCS inbox using GroovySummary: We are looking for a groovy code to download a file from epbcs inbox/outbox explorer to local machine. Unfortunately, we can't use epmautomate. Content (please …
-
How do I fetch salary rates by Pay Type on new requisitions in Oracle Planning (EPBCS)?Summary: We added Pay Type (Exempt/NonExempt) to our Salary Grades table in Workforce Planning; We're no longer able to pull the new rates when using the Salary Grade op…