Calc Manager
Discussion List
-
Member limit for custom dimension on financialsSummary: Content (required): Hi Need to know the member limit for custom dimension for financials. Version (include the version you are using, if applicable): Code Snipp… -
execute Data management rule from a Business Rule GroovySummary: Hi All, im trying to run a data management rule from a business rule using groovy script. The Data rule is on the Instance A(for Eg) and the business rule is al…
-
CREATEBLOCK - Script diagnostics generates error if you do not FIX on all dimensionsSummary: In the monthly update notes, there is recurring mention of a future update where script diagnostic errors will prevent the launch, validation, and/or deployment… -
Substitution Variable condition not working within IF conditionSummary: Issue while passing Subs variable inside IF condition. Content (required): Hello All, Here we are performing forecast calculation by passing subs variable insid…
-
Can I use a string in comparison statement?Summary:I just tried to compare value initially but it didnt't reflected, If I place #Missing in the code inside if condition the code gets executed, if I place any valu…
-
Exclude SmartList Accounts in a FIX statement possible?Summary: I need to remove zeros from a cube. However many SmartLists need zeros, so want to keep those. Content (required): Is there a way to exclude by DATA TYPE proper… -
EPM Essbase: Managing Calculation Permissions for Users and GroupsSummary: Content (required): Does anyone know if the following documentation only applies to PAAS clients? We're a SAAS client using the Oracle Fusion Cloud EPM suite. I…
-
How to exclude an alternative hierarchy with shared children in calc script?Summary: We are trying to exclude an alternative hierarchy in our calc script but using @remove we are unable to achieve this and also Exclude will not work as we are do…
-
Copy data from one member to other members of same dimension (fastest way)Hello experts, I have to copy data from one member to anothers of same dimension and I ask you which is the best and fast way to do it. My requeriment is copy data from … -
Ways to Validate level zero members of Hierarchy in a IF StatementSummary: Encountering Issue while validating entire hierarchy in IF Statement. Content (required): Hi All, I wanted to check ,level zero members of Salaries Hierarchy ==…
-
Automate Data Copy with commentsSummary: How to automate a datacopy with comments, supporting details and attachments ? Content (required): Hello everyone, My client is currently on Planning On Prem 11… -
Scheduled job (business rule) shows "Misfired" - what it means and why?Summary: Scheduled job (business rule) shows "Misfired" - what it means and why? Content (required): Hello All, I have a scheduled job (business ruleset) and it has this… -
Rounding off issue in ASO MDX ScriptingHi all, I am trying to copy data from BegBalance to months (Jan to Dec) in ASO cube using MDX scripting. Below is the code: When I am executing this script, the value is…
-
Extract UDA and Attribute from CURRMEMBERHello experts, I have a requeriment to do. I have 3 dimensions for this process: 1- Account : Account1 (UDA: Red) Account2 (UDA: Yellow) Account3 (UDA: Black) 2- Product…
-
Data Validation and Throw Exception using Groovy Grid IteratorSummary: Groovy DataForm data validation - raise exception and highlight cells which are causing this causing. Content (required): I have quite number of columns on the …
-
Scheduling User Group Report via Groovy APISummary: I'm attempting to schedule the User Group Report via Groovy API in order for it to generate an output file within the Inbox/Outbox preferably. I'm currently abl…
-
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 …
-
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…
-
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… -
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 63 views 7 comments 0 points Most recent by Sabrina Greensea-166456 Planning