Calc Manager
Discussion List
-
EPBCS : Copy parent level data to Level0 Members having Multiple generation sparse dimensionContent Hi All, We have a Department hierarchy (Sparse Member) with multiple levels/generations. We have loaded data to the department parent members with the top down T… -
Problem with aggregating percentage values against custom created ScenarioContent Hello guys, We have an issue with newly added custom Scenario member (Actual vs SPLY %). This member is supposed to calculate the % of Difference of Actual scena…
-
Planning - Data Management Replace Data FunctionContent Hello, One of our clients have a DM Rule with Replace Data to clear the cube before importing the data. The thing is that the ClearData is taking almost 3 hours …
-
Error on Groovy error Message: expected type found .Summary Converting rule to groovy rule. Rule fails to write RTP value to member. Trying to write text string entered through RTP on Action MenuContent I have a working r… -
Ruleset's RTP shows the RTP number in front of the RTP TextContent Hello everyone, We recently migrated to Planning in the Oracle cloud. We encountered the issue with one of the Business Rules RTPs. The very last RTP in the Rule… -
Anyone has ever used "Allocation" system template successfully without any custom modificationContent Hi, I wonder if anyone has tried using Allocation system template successfully without the need to make custom changes in the system generated script. I tried di… -
Business rule syntax errorContent Hi Everyone, I have the following relatively simple business rule that I am trying to create to attach to a form: FIX (/*DIM:Years*/"FY21", /*DIM:Scenario*/"OEP_…
-
Need to identify members that used inside BRs and Member formulasSummary Before edit or Delete Dimension member, we need to identify is it using inside any BR or member formula.Content We are facing difiiculty when we need to delete o…Surya_chittaranjan_01 47 views 2 comments 0 points Most recent by M. Kyle Goodfriend-Oracle Planning
-
EPM Automate script failing with new 5.02 runRuleSet commandSummary EPM Automate script failing with new 5.02 runRuleSet commandContent We downloaded the newest version of EPM Automate and changed the runBusinessRule command to r…User_2025-02-01-06-21-55-603 34 views 3 comments 0 points Most recent by User_2025-02-01-06-21-55-603 Planning -
What's New in 21.02?Summary We kick-off the new year in style!Content Faithful followers may have noticed I skipped the 21.01 update last month. The January update tends to be lighter given… -
What's New in 21.03?Summary A really big Enhancement!Content Well, to say I'm excited to share this post may be an understatement and I believe you may very well share my excitement! In fac…
-
Calling a Business Rule from a Groovy script (OWP_Add Requisition_GT)Content Hi, Our client has its own version of calculating Benefits and Additional Earnings; so we created a custom business rule ("HS_Calculate Benefits Additional Earni…
-
Unable to Incorporate Applicable Union Code in Business Rule.Content Created two Level 0 children under OWP_All Union Code in WFSC cube. And we have a member called 'OWP_Applicable Union Code" in WFP Cube Under Account Dimension h…
-
Aggregation issue with dynamic calc membersContent Hi Im experiencing an aggregation issue with dyanamic calc members where at the total product level, it picks the wrong agg value/summation. When i delete the ca…
-
Currency Conversion in ASO (Freeform Planning)Content Hi, I am currently working on the Currency Conversion on Cloud, we are using ASO in Free Form Planning. So for Currency Conversion in ASO, i have written a Groov…Dhawal Shah-266999 24 views 12 comments 0 points Most recent by Dhawal Shah-266999 EPM Platform and Freeform
-
Aggregation to Parent level from calculated members (one being %)Summary The aggregation is calculation of the totals of sum of the members, not the sum of the calculated values.Content Aggregation of the UPP Indirect Costs is not reg…
-
Idea Lab - New Idea Raised to include search field in Business Rules HomepageSummary Idea Lab - New Idea Raised to include search field in Business Rules HomepageContent Hi Friends - I have raised an idea in the Idea Lab to include a search field… -
Execute a rule from a tab in a navigation flowSummary Need to execute a business rule by clicking on a tab in a navigation flowContent Hi, We would like to be able to execute a business rule from a navigation flow t… -
Action Menu in Redwood ThemeContent Has anyone in the forum experiencing Action Menus disappear or not showing up at all under Redwood theme? Any workaround has been discovered to avoid this issue?…
-
How to reference runtime prompt variables in a business ruleContent I am trying to create a simple business rule that will run after saving a webform. Additionally, it needs to use the POV of the webform for some of dimensions. T…
-
Fill Forecast with remaining BudgetSummary Forecast periods should be pre-filled evenly with the remaining Budget (YearTotal Budget - Actual)Content Hi everyone, I'm trying to build a business rule to aco…
-
What's New in 21.04?Summary More cool ways to enhance your Oracle Cloud EPM experience!Content I'm still very excited to have released Cell-Level Security last month! I hope many of you are…Mark Rinaldi-Oracle 236 views 4 comments 7 points Most recent by Shankar - PM Cloud EPM-Oracle Planning
-
Passing RTP within a groovy rule calling the REST API to clear cubeSummary Unable to figure out the correct syntax to pass the rtps into the HashMap - Groovy Business Rule calls "Clear Cube"Content Hello, I have a groovy rule that calls…
-
Variance Calculations in CalcMgr Rule?Summary Experimenting with variance calculations in calcmgr rules, need some advice/helpContent Hi, We've been experimenting with making some of our sparse dimensions dy…
-
Unable to edit the OOB artifacts like smartlist, Valid intersection, Action Menu etc.,Summary Unable to edit the OOB artifacts like smartlist, Valid intersection, Action Menu etc.,Content Hi, We are trying to edit the OOB artifacts like smartlist, Valid i…
-
Hybrid Dynamic Member Performance IssuesSummary Dynamic member formulas are slowContent I have not done a ton of hybrid development. I want to know if others are having this issue. In a BSO cube, I do this all…M. Kyle Goodfriend-Oracle 55 views 11 comments 1 point Most recent by M. Kyle Goodfriend-Oracle Planning -
EPBCS - @return function is not returning anythingContent Hi all, In EPBCS OEP_FS cube I wrote a custom script in order to validate my start/end month prompts, please see below. When I run it, it does not return anythin… -
Update Substitution variable using GroovyContent Team, Is there a way to override the substitution variable values (OEP_CurMnth & OEP_CurWeek) for a specific rule set to execute without impacting other processe…Suresh Ratnala-Oracle 372 views 3 comments 1 point Most recent by M. Kyle Goodfriend-Oracle Planning -
Sharing Info: How to view Substitution Variable values in Debug mode - Cal ManagerSummary How to view Substitution Variable values in Debug mode - Calculation ManagerContent Hi All I found something interesting and want to share with all of you. If we… -
Groovy error: calc script too longContent I'm trying to run a Groovy script to execute a calculation but the calc script is too long: The Groovy script failed to compile with internal error: Compile Erro…