Calc Manager
Discussion List
-
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…
-
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 241 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 489 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…
-
Calc Manager - With Multiple Rules Opened, opening a new rule sometimes opens and shows code from aContent I've noticed this happening ever since the new year. I wonder if this is because of the Java discontinued. When I open an existing rule in Calc Manager, but I al…
-
Will running multiple Business Rules (in BSO cubes) with an Aggregation component at the same time sContent Will running multiple Business Rules with an Aggregation component at the same time slow down performance significantly? What about where multiple rules are run …
-
Groovy Grid Iterator/cell.updated doesn´t work sometimesContent Hi all, In a few processes we use the Grid Iterator in Groovy to check if a cell was updated in order to just recalculate that specific point of view. in 99% of …
-
Modify Module RTP Text LabelSummary Want to change the text for "LABEL_ASSET_RATE" for the AssetRate RTP TextContent We want to present a different text for the RTP AssetRate. Presently, it is set …
-
Scenario Based BudgetingContent Hi This is with regards to both financials and strategic modelling in EPBCS. We have created a chart of accounts (around 3000 accounts) and around 40 rules to ca…
-
Referencing a Member Range within a Groovy Script VariableContent Hello There! I'm trying to create a dynamic data push after running a data load within my BSO cube. The data load can load multiple periods ie from Jan - Mar or …User_2025-01-31-02-27-25-352 90 views 7 comments 0 points Most recent by User_2025-01-31-02-27-25-352 Planning
-
Member name beginning with $Summary Member name beginning with $Content We have a few member names beginning with $ in Planning. The system allows creating the member name but throws an error when …
-
EPBCS: Block creation issue in allocation LogicContent Hi All, I am having a block creation issue in allocation logic. I need to do the project allocation from No Projects to Level 0 of All Projects. I tried to use @…
-
Rule takes 30 min to runContent Hi I have attached a calculation script which takes 30 min to run in total. We need to reduce the time taken to run the rule. Please share any suggestions. Thank…
-
@CREATEBLOCK function not creating blocksSummary Trying to use the @CREATEBLOCK function to create blocks, but it isn't doing it.Content I've used this function a number of times. I recall that sometimes it has…Sabrina Greensea-166456 122 views 6 comments 1 point Most recent by M. Kyle Goodfriend-Oracle Planning
-
What's New in 20.12?Summary Wrap-up for a Strange YearContent Well, this concludes a strange year (to say the least) but one with lots of new features. We've snuck several more for this mon…Mark Rinaldi-Oracle 204 views 5 comments 6 points Most recent by User_2025-02-08-03-53-41-891 Planning
-
@CALCMODE dependency in dense dimensionContent Hi all, We have a complex calculation with a dependency in one of the dense dimension, therefore we use @CALCMODE(CELL) in the script. This slowed down the calcu…