Calc Manager
Discussion List
-
DATACOPY Rule taking a long timeSummary: Content (required): I have a DATACOPY business rule that copies one version to another. However, it is taking up to 15 or so minutes to complete. I have a simil… -
Unable to create blocks for Allocation LogicSummary: Unable to create blocks for Allocation Logic Only Period and Account are Dense and rest of all are Sparse. FIX(&CurYr, &CurMnth,"Actual","Final", @RELATIVE("All… -
Ruleset and Rule Variable Prompt OrderSummary: The order of my variable prompts within a Rule and a Ruleset are not updating regardless of how I have the order setup within Calc Manager. Content (required): …
-
Import Rates from ERP to EPBCSSummary: Form subvars off imported ERP rates and reference them in business rules. Content (required): Currently we are manually hard-coding our period average and perio…
-
Copy data using XREF from different members to unique member (Fastest way)Hello experts I have a requeriment to do. I have to catch some data using XREF. I have one dimension that is available for both cubes (Product: Sparse Dimension) and I n… -
Unable to copy data from one member to another using groovy script in Hybrid EPBCSSummary: Content (required): Unable to copy data form one member to another using Groovy Version (include the version you are using, if applicable): Code Snippet (add an…
-
FRS IssueSummary: FRS Issue Content (required): Hi We have an FRS Report with 2000 rows, and we are bringing a dimension to the which was not earlier. For this dimension member v…
-
Two Ifs : to use in calculation scriptSummary: Content (required): Hi I want to use Two ifs in calculation scripts but it is giving a validation error. Condition is if user selected a particular smartlist va…
-
Can we execute calculations 'on-the-fly' in a data form with/without using groovy in EPBCS?Summary: We are calculating Revenue items based on the driver inputs. Can we execute calculations 'on-the-fly' in a data form with/without using groovy in EPBCS data for… -
FRS grid takes a long time to openSummary: Content (required): Hi We have a financial report around 2000 rows with Account, and 2 sparse dimensions on row, and scenario ,version, plan element, period and…
-
RTP to smartlistSummary: Hi All, I want to post Smartlist value on the basis of RTP. Content (required): Hi All, I want to post Smartlist value on the basis of RTP.Both RTP and Smartlis… -
Using @XWrite to create block within the same cubeSummary: trying to use @Xwrite function to create new blocks within the same cube, the rule is running but doesn't create new blocks Content (required): Create block wit…
-
Understanding the Importance of Groovy Collections - KScope Follow UpI received a number of questions when I attended KScope. A lot of people had a tough time wrapping their head around the fact that using Groovy could actually reduce cos…M. Kyle Goodfriend-Oracle 81 views 0 comments 4 points Started by M. Kyle Goodfriend-Oracle Planning -
Creating a Transaction IDSummary: I'm looking to create a way to track and report against mid cycle budget adjustments using a transaction ID. Content (required): Hello, I’m trying to come up wi…
-
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…Lakshani Hettiarachchi 52 views 2 comments 0 points Most recent by M. Kyle Goodfriend-Oracle Planning
-
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…Chiranjeevi Naragani 334 views 14 comments 1 point Most recent by M. Kyle Goodfriend-Oracle Planning
-
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…