Calc Manager
Discussion List
-
RTPs Repeated issueSummary: Content (required): Hi I have two run time prompts for scenario and version for all the rules, and i have attached all the rules to a ruleset. when im about to …
-
Can't insert vaiue after adding the dynamic member by groovySummary: we refered the following artiacle to add dynamic member and inserted the number value after adding member but it did't works (however the status is successfully…
-
Clone errorSummary: Content (required): Hi We are encountering the following error related to cloning (From test to prod EPM Planning). Do you have any insights or suggestions on h…
-
FRS Report IssueSummary: FRS Report Issue Content (required): Hi When doing modification to FRS report, by moving - in this case, entity dimension to a row, we need to apply entity valu…
-
Script IssueSummary: Content (required): Hi All Have the following requirement, where if user has entered any value on Direct input column (Column H highlighted in yellow) system sh…Lakshani Hettiarachchi 42 views 2 comments 0 points Most recent by Kyle Goodfriend, In2Hyperion-Oracle Planning
-
Smart lists in calculation scriptsSummary: Smart lists in calculation scripts Content (required): Hi I need to refer smart list value in a script and then to write a condition, if the smart list value is…
-
BR runs longer in a year with 3 months than in a year with 12 months of dataSummary: We've got a forecast in FY23 with 12 months of data and 3 months of data in FY24. The data has the same detail, but FY24 runs twice as long. (Edit: Calc manager…
-
Permission for Rule setHi, I'm unable to give permission for rulesets, but its possible to give access for a rule. Possible way to give users permission for rulesets? Ruleset Rules
-
Groovy: unexpected char 0xA0Hello all, I am trying to use data grid definition builders to read a form which is used for integration from CPX to FS. But, while executing the rule, encountering the …
-
Groovy Edit Script option not available for Planning Enterprise AppContent (required): Hi all We are trying to use groovy scripting for an enterprise application, Custom type but the option is greyed out. Is there a way to enable for Cu…
-
Copy No_Currency data to Local Currency based on Entity base currencySummary: Is there a way to copy No_Currency data to the respective Entity base Currency with out using UDA's or Attribute assignments Content (required): In a Simplified…
-
Not able to calculate data using GroovySummary: I am trying to calculate discount using groovy but data is not being calculated. BR is attached Run after save. Form Layout. Content (required): Set costCenter …
-
Error while finding Count of Members between range:invalid argument in function [@_BPROC]Summary: Encountering invalid argument in function [@_BPROC] Content (required): Hi All, Here we are trying to find count of Members between Start Month & End Month in a…
-
Business Rule Displaying Multiple Times in ListSummary: Content (required): I have some rules and rule sets that are appearing in multiple Plan Types in the Business Rule list. It should only be in the Plan Type to w…
-
Some questions about Query Tracker and ASO AggregationsSummary: I'm no expert on the aggregation functionality of ASO cubes using query tracking. In particular, I'm having trouble with the stated order of operations: 1. Merg…Sabrina Greensea-166456 62 views 7 comments 0 points Most recent by Sabrina Greensea-166456 Planning
-
Unable to expand Application in Database Properties - Calc MgrSummary: After the nightly backup, we can expand this in Calc Mgr and use the functionality as needed. Then after a few times it stops allowing it until next nightly bac…
-
Calculation based on TimeSummary: Is it possible to load time and get the difference between two times in pubs? Content (required): We can't load the time in pbcs as there is no property for it,…
-
Prevent Rules Migration from Including Script ComponentsSummary: We use multiple script components in our rules, especially to hold common variables for groovy rules. We have noticed that when we promote a rule using migratio…
-
How to copy the list of all Rules from Calc ManagerSummary: How to copy the list of all Rules from Calc Manager Content (required): How to copy the list of all Rules from Calc Manager. We have many rules and we need to c…
-
Business Rule/Groovy Scripting to remove data in ASO at a specific intersectionSummary: Trying to determine if there is a way to create a business rule or groovy script which would clear data in ASO at a specific intersection utilizing members deri…
-
How do I use an attribute in a workforce business ruleSummary: Content (required): When we copy data from workforce to the plan cube, we need to break out the employees by Class. We do not have Class in the Workforce cube, …
-
Launching Business Rule on Save of form is resulting in errorSummary: We are able to run a script from calc manager. When the same script is attached to a form and run on save, it is resulting in error as below: Error parsing form…
-
Clearing of data for shared members under alternate hierarchy not workingSummary: Found the issue. Disregard lol Content (required): A business rule to set an account to #Missing is not working for the shared children in an alternate hierarch…
-
CalcMgrGroovyNumberHello! I'm trying to mask data with a similar approach that the random function in excel. I've been reading old posts where there was a way to do this using @CalcMgrGroo…
-
Enabling Batch/Shell Scripts execution from Business Rules (Like OnPrem CDF Functionality)Summary: We would like to implement a functionality where Business Rules having ability to call Shell/Batch Scripts. The same feature available in OnPrem (CDF Functional…
-
If @PREVSIBLING returns null, have it return the member being evaluated instead. Is this possible?Summary: Is it possible to return the current member being evaluated in @PREVSIBLING if the formula evaluates to null (the member being evaluated does not have a previou…
-
How to refresh a form using a groovy rule?Summary: How to refresh a form using a groovy rule? Content (required): Dear all, I've written a Groovy rule to add some complex control before saving data. This rule is…
-
Importing Text through data management (Non Numeric)Summary: Importing Text through data management (Non Numeric) Content (required): Hi I have setup data management import format "Delimited All Data Type". And Load metho…
-
Updating substitution variables via REST API broke with 23.03 updateSummary: In performing regression testing, I am having trouble using the REST API to update substitution variables. The rule results in a null pointer exception. Content…
-
Need to Improve Aggregation Run TimeSummary: Want to decrease time it takes to run an agg. Content (required): Currently takes about 40 minutes to agg one period, one scenario, income statement only. Would…