Calc Manager
Discussion List
-
Need to capture the start and end time of a Data load Rule(Data Exchange) in Groovy Rule.The Request is to get REST API output in json format like start time and end time of a Data load rule in Data Exchange. I have created groovy script to extract the log f…Radha Yerra 51 views 5 comments 2 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
Unable to Export Attribute Member Consolidated Data in EPBCSCurrently, in on-prem, we are exporting data using attribute members, which means we are getting consolidated data rather than associated members through a report script… -
Rules are not displaying under RulesSummary: Hello, Does anyone know why the rules are not displaying under Rules? The Daily maintenance ran last night, and it did not resolve it. We also redeployed all ru…
-
Why does @parentVal return #MISSING?Summary: Can someone help me understand why @parentVal("Period", "Working") returns #MISSING for the sample code below? Content (required): I have set up a simple exampl…
-
@IRR and @CalcMgrExcelIRR does not return a value equalent to the Excel IRR calculationSummary: We are using @IRR inbuilt oracle function in our Calculation rules to arrive at the IRR value , IRR(AC.PBC.6013)= IRR( Cumulative(Free Cash Flow (FCF)(AC.PBC.50…
-
How do i refer the smartlist value ( not numberic value ) in a business ruleSummary: I have created Increment Month smartlist which has period dimension refernce or smart list entries are Jan, Feb, Mar and so on, and i want to refer and compare …
-
Can I edit OWP_Transfer rule in Workforce Module?Summary: I need to edit the OWP_Transfer rule in TST environment to analyze an issue. When I try to "edit script" it doesn't allow me to edit. Please let me know how I c… -
Allow user to select design time prompt each time rule is runSummary: Allow users to select design time prompt each time rule is run in order to use validations and steps as needed Content (please ensure you mask any confidential …
-
Business Rules RTP behavior between Forms 1.0 and 2.0.Summary: Hi Experts, I have a Business Rule with RTPs that include both numeric values and Smart List selections. I have set Allow #Missing at both the variable and rule…
-
How to use groovy script to run the allocation in PCMCS and how to load driver data using groovySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Is it possible to set attribute value from SL value?Summary: Is it possible to convert SL Value and attach it on attribute dimension. Can we do it using groovy, if yes could you please share code snippet. Content (please … -
Change in FIX AND behavior with 25.08In my business rules, I often use SET EMPTYMEMBERSETS ON; along with FIX statements to handle different branches of logic that need to occur for different years or scena… -
Calculation of percentile / quantileSummary: How to calculate percentiles / quantiles in EPM Planning BSO without considering #Missing Content (please ensure you mask any confidential information): In my c…
-
How to use @SHIFT(@CurrMBR in a crossdimI am trying to write a calc in calculation manager which will return a different value based on 3 different situations depending on the Period (i.e. "Jan") in the IF sta…
-
How to Check if member from Plan1 exist in Plan2?Summary: Problem : Customer is copying data from one plan to another plan in planning application. Now some dimension member do not exist in target plan type. Do we have…
-
How to exclude intersections of different dimensional membersSummary: How to exclude an intersection of different dimensions within a FIX statement? see example below Content (required): Calc Script: In the FIX Statement is the wh…
-
Exclude negative data in member formulaSummary: hello, Need some advise on how to exclude months with negative values in the data set when taking an average. We are currently doing this within Excel's functio…Zut Alors 71 views 5 comments 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
-
Employees status setting to departureSummary: Content (please ensure you mask any confidential information): We have a business rule that sets active status. This has been working without issue for over a y… -
Calcmgrslmember does not return the correct cross reference value , but returns correctly in debugSummary: I have a business rule that refers to the calcmgrslmember to retrieve a SL member name and identifies the cross referenced value in an intersection. This does n… -
Independent BR assigned to Integration - runs also rules that are not assignedSummary: Hi all, I have created an Integration in EPM Planning (runs as expected) with the BR assigned to it. This business rule has been added as an Independent, event-…
-
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… -
Newly added members not getting reflected in the Calculation ManagerAfter creating dimensions in Custom cube and refreshing the application, Member count is reflecting correctly from front end at application level however member count is…
-
Planning Calc Script - @COUNT with ConditionSummary: Hello - not sure why I am struggling so much with this but we have a rule where we want to have an IF statement to only include shared member projects that meet…
-
Workforce Rule Failing for Unknown ReasonSummary: Rule and Ruleset failing for unknown reason Content (please ensure you mask any confidential information): I have a ruleset in workforce that is scheduled in jo…
-
Is there way to view all business rules ran within a time period?I need a full activity report/list with date or time stamps of all business rules that were ran for example in the past 30 days. Thank you!
-
Is rtp a restricted word in simulateConcurrentUsage?We are experiencing an issue with simulateConcurrentUsage regarding how it is processing rtps when performing the Run Business Rule function of this command. We have att…Russ_Shellhamer 101 views 20 comments 1 point Most recent by Russ_Shellhamer EPM Platform and Freeform