Calc Manager
Discussion List
-
Course for Business Rule WritingSummary: Content (please ensure you mask any confidential information): I am looking for recommendations of courses which offer Calculation Manager training. I have a go… -
Groovy - awaitCompletion - An error occurred while processing this page.Hi all, Hope you guys are doing well. We are trying to use REST API to trigger a data integration from Calc Manager (EPBCS application). We have created the connection, … -
Pipeline execution stop/resetSummary: When executing/invoking a pipeline (REST) from Groovy if in case the pipeline name is incorrect or if a param or comma is missed the pipeline keeps polling and …NarayananS 21 views 1 comment 0 points Most recent by Randa-Support-Oracle EPM Platform and Freeform
-
Block Creation issue when I used @prior functionSummary: Hi, Please help me in creating the block when I am using @prior function. Requirement is to add the data of previous period for two account and load to current … -
Groovy script error query threshold limitSummary: Hi experts, I have written a groovy rule using flexibleDataGrid to export the dynamic calc Parent members plus all stored sparse members to a csv file . while e…Sreekumar Hariharan 61 views 1 comment 0 points Most recent by Kyle Goodfriend-Oracle EPM Platform and Freeform
-
Rule Error status code [1042016]Hi, The Original script completes in a second(1sec) but once the rule is edited with a cross dimension ->"OWP_Existing Employees" the rule error out after 30 minutes Ori…
-
Business Rule not working for Scenarios other than OEP_PlanHello! Summary: I am creating a Business Rule to apply a Percent increase to the values from the previous year. The rule does not work for different Scenario other than …
-
Working functionality of LOOP/ARRAY in Business RuleSummary: Is there any way to use Loop or Arrays which will take multiple RTP variables as parameter and perform calculations for each RTP within the loop? Content (pleas…
-
Error using startsWith function in IF condition within FIX ENDFIXHello, I'm trying to put an IF condition within FIX ENDFIX in an EPBCS groovy script. Need to execute the set of statements if a Custom dimension member starts with a pa…
-
Fix inside if conditionSummary: Content (please ensure you mask any confidential information): Hi I have a rule which takes 10 min to run. Current setup : 16 Entities and Each of these entitie…
-
Smartlist issueSummary Content (please ensure you mask any confidential information): Hi, We had an issue with smartlist, not sure about the root cause. In business rule, we have a cal…
-
Remove shared members from XRANGESummary @REMOVE in @XRANGE not working as expectedContent Hi experts, we have the following custom calculation which counts the members of Period dimension in a given ra… -
Export Console REST API - generates all rules instead of single rule in params & Unzip using groovySummary: Export Console REST API - generates all rules instead of single rule in params Content (please ensure you mask any confidential information): Export Console RES…
-
Allocation ExampleSummary: Need to allocate by department from one entity to multiple others. Content (please ensure you mask any confidential information): I'm looking for a good example…
-
Convert value of SmartList to member to use in cross-dimensional (Non-Groovy)Hello experts, I have an account linked to smartlist where I have "account values" to choose in this smartlist, like this: For each entity (on columns) and dimension flo… -
@CalcMgrSLMember not recognized?In the october update it brought 4 new functions : @CalcMgrLogMessageTrace: Adds custom messages to the Log Messages tab after launching a rule in Calculation Manager. @… -
Copy a dynamic calc parent member to a stored base level memberSummary: Need to copy a dynamic calc member to a stored base member Content (please ensure you mask any confidential information): I have a roll up (below) in a sparse d…
-
How to print or use substitution variables in Groovy for ASO cubeSummary: I had a requirement where I need to extract data from ASO cube montly, I created Sub Var in ASO cube for period and year trying to call those in groovy but scri…
-
Optimizing Allocate RuleHello experts, I have a doubt with a calc script doing an allocation. Type my code and explain if is possible optimize this code: FIX (&Act_Year,"Actual","EUR",@RELATIVE…
-
Member Selection in a Business Rule Shows Account List Not HierarchySummary: Would like to have the member selection show as a hierarchy, not a list Content (please ensure you mask any confidential information): We have a prompt to selec…
-
Uniform Budget Hospitality industrySummary: Content (please ensure you mask any confidential information): Hi Im having a client who is in hospitality industry. and he would like to know how certain types…
-
Planning PBCS: Intercompany Elimination best PracticesSummary: Developing in Planning an Intercompany Elimination process. Content (please ensure you mask any confidential information): Hi, We are developing an intercompany…
-
Can we see budget at Account level in Sales planning - Quota Target for Account dimension?we have a account segment and sub segment in sales planning Account dimension.I want to rollup the revenue to account segment level but not Account sub segment level. Ca…
-
Formula AssistanceI have a scenario where users budget on a data form to Department and Default_Account and not the 'Natural Account' from the G/L. So, now I learn each Department does ma…Hyperion_Junkie 41 views 14 comments 0 points Most recent by Hyperion_Junkie EPM Platform and Freeform
-
hide rows in a pbcs formHello Experts! I have a form that I would like to supress rows that contains "almost" zero. I click on option supress missing / zero rows but in my example doesn't work …
-
How to run the calculation in detailed logging mode?Summary: We are running into errors like "Error executing formula for [StaffEntry] (line 764): attempt to cross a null member in function [@X]" Found Doc ID 2191610.1. I…
-
Hybrid cube business rule optimizationIs there any documentation on business rule optimization for a BSO hybrid cube. We converted our BSO cube to hybrid and started noticing efficiency issues with some busi…
-
EPM Automate login using Connections in Groovy instead of using epw password fileSummary: Is it possible to use EPM Automate in Groovy BR for login? Am trying using getUserName(), getPassword() instead of using epw password file. Defined the connecti…NarayananS 131 views 7 comments 1 point Most recent by Suruchi S-Support-Oracle EPM Platform and Freeform