Calc Manager
Discussion List
-
October 25.10 calc manager bug introduced: a valid dimension could not be found for variable...Summary: Just noticed ASO business rules no longer validate if a variable of type "Members" is used. I get error message: A valid dimension could not be found for variab… -
Workforce Domestic and International TaxesSummary: Content (please ensure you mask any confidential information): I have been asked to add our international team to our Workforce app. They have a number of diffe… -
Groovy script with POST rest command creates a unexcepted filename in targetSummary: I am running a groovy script which basically copies a file ( Outbox folder ) from environment-1 to Inbox folder of the target environment-2, ait then runs the i… -
@REMOVE is not working with Shared hierarchiesSummary:@REMOVE is not working with Shared hierarchies Content (please ensure you mask any confidential information): I am trying to remove currency rates, Mexico hierar… -
Profitability and Cost Management (EPCM) Model Calculations for multiple Periods with GroovySummary: I have a pipeline in EPM Planning that push data into EPCM for all periods of Forecast scenario/Run Model Calculations for all periods to allocate Overheads/ Pu…
-
Translate BR variable "User ID" to dimension or smart list member?Summary: Can I translate a BR variable using the User Name default value into a dimension member or Smart List value? Content (please ensure you mask any confidential in…
-
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…
-
Creating via Groovy Rule the Excel file needed for the update of Cell-Level SecuritiesSummary: We would need to create and populate the two-tab-based Excel file needed for the Cell-Level Securities update. Is there a way to do so? Content (please ensure y…
-
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…
-
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… -
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…
-
Groovy script to Validate comment entered through data formSummary: Hi, I am new to groovy BR. I am working on Groovy BR to validate "comment" entered by user using data form. A member with "Text" data type is used in data form …
-
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…
-
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…