Calc Manager
Discussion List
-
Update Valid Intersections Rules via GroovySummary I want to create valid intersections rules or conditions via groovy while creating a new memberContent Hey all, I have a situation where the client has several v… -
New Groovy version 25.10 Validation ErrorHello Experts, I have a issue when I run validation Groovy Script: My HTML Report have same error in several rules, now are working fine but I'm afraid that is not worki… -
Business Rule: Capture logged-in user ID?Summary: Is there a way to capture, say in a variable, the ID of the logged-in user? Content (please ensure you mask any confidential information): We're building a cust…
-
Map members into other dimensions based on data set in Account dimension using a RuleSummary: Hello, I have a request to populate the data residing in the account dimension into 2 other dimensions, such that the intersection below copies data 25 and 35 f…
-
Groovy getFormattedValue() not working?Summary: Content (please ensure you mask any confidential information): Hi, Just found that getFormattedValue() not working as expected, it was working correctly before.…
-
Groovy Script ValidatorSummary: Content (please ensure you mask any confidential information): Hi, With the Aug release in TEST to validate groovy rule scripting restrictions by the provided t…
-
How to get the Smart Push functionality to work in Dashboards when they are being utilized via SmartSummary When submitting data for an EPBCS Dashboard in Excel via the Smart View 11.1.2.5.910 (Build 172) add-in, the Smart Push for the underlying simple forms being sav… -
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 73 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…