Calc Manager
Discussion List
-
Data Management - Passing Start Period and End Period to Business RulesContent In Data Integration I have a business rule that performs calculations post load for the period range loaded i.e. DM POV Start and End Period range. In DM Cloud, …Dinesh Chand 226 views 6 comments 2 points Most recent by Anandita Biswas-Oracle EPM Platform and Freeform -
We are trying to write a calculation referring FCCS_YTD member but its not workingSummary: Hi Team, We are trying to write one calc script using FCCS_YTd data but rule gets stuck whenever we try to run it. This is working fine when we run it with "FCC… -
Sumrange function used along with UDA function is not working as expectedSummary: We are trying to write a calc manager script where we want the sum of all entities tagged with Specific UDA multiplying it with respective ownership percentage …JyotiSharma 32 views 12 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
When lauching a rule via Rules I get an errorSummary: Hi everyone, When launching a rule from Rules I get following error: the dimension Year is invalid. However it is successful when launching it via calculation m…
-
Unable to launch business rule from RulesSummary: Hi all, I created a rule to copy data from one year to another year, the rule is successfully validated, saved and deployed. I can also launch it from the Calcu…
-
Script doesnt work as expectedHi we want the aggregation of a different dimension eg row 6 and 7 needed to be summed up in row 11 ie where ever the functionl area = Room Sales_FA it need to summed to…Althaf Abdullah 32 views 2 comments 0 points Most recent by Lakshani Hettiarachchi EPM Platform and Freeform
-
EPM planning business rule runs multiple timesHi, There used to be an issue like this decades ago, but I am getting the same behaviour in PBCS. After saving a form, and the business rule runs, if I leave the form sa…
-
Dataexport not exporting #missing dataHi, I am trying to export members in a certain area regardless of whether there was data or not. My understanding is that DataExportNonExistingBlocks ON, was to export a…
-
Smart List based RTP not working in Planning InterfaceSummary: We have a Smart List based RTP. The business works fine directly in Calculation Manager but not from Planning. Details: We are encountering an issue with a DATA…adarshad 31 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
How could reversal in proportion change for YTD view correctly?Summary: In a hierarchy some entities are changing from 90% Subsidiaries to Not Consolidated method and 0% Ownership, the same entities are consolidating in a 100% in ot…AA_AlfonsoGonzalez 51 views 5 comments 0 points Most recent by Hussein M Ali Financial Consolidation and Close -
OAuth 2.0 Refresh-token based EPM Automate login failsSummary: Refresh-Token based EPM automate connection fails Content (please ensure you mask any confidential information): Groovy code to execute Recompute ownership modu…Arindam Chakravarty 31 views 1 comment 0 points Most recent by BalaR-Oracle EPM Platform and Freeform
-
How to search a string variable in Groovy for a specific part of a string.Summary: How to search a string variable in Groovy for a specific part of a string. Content: We're currently using an pipeline that triggers everyday and processes the f…
-
ASO Custom Calculation vs. Graphical Editor DifferenceHi folks, I'm working in a custom EPM Planning app and trying to create an ASO business rule to calculate a percentage of total headcount. I can use the graphical design… -
Data Export with Pivot DimensionSummary: Hello Wizards, I have requirement to export BSO data (Non Num as well) to csv file with Account dimension on the column (Pivot). Expected Output (StartDate and … -
In EPBCS, Unable to copy data from Working Version to Final Version within ASO cubeSummary: I've used MDX to copy the data from 'Working' version to 'Final' version within the ASO cube but I'm unable to do that. The Rule got successful in the validatio…
-
How to Copy Data from a combination to another combination using groovy in PCMSSummary: Need to Copy Data from a combination to another combination in a form using groovy in PCMCS Content (please ensure you mask any confidential information): Versi…Sri Harsha Panchumarthy 41 views 5 comments 0 points Most recent by Harish Kumar C Profitability and Cost Management
-
ASO to BSO DataSummary: What are the ways of pushing data from ASO to BSO cube. Data Map is not working. We need to push a big set of data from ASO to BSO. Content (please ensure you m…
-
How to print the Duplicate data in a form in incremental order using groovySummary: Exporting the Repeated Data Combination in a form in incremental order using Groovy Content (please ensure you mask any confidential information): I want to pri…Sri Harsha Panchumarthy 21 views 1 comment 0 points Most recent by Brett Rooks EPM Platform and Freeform
-
Need Calculation scriptsSummary: Our Company Contribution to Staff Association (1) Use the prior year’s actual contribution to staff association to forecast the contribution to staff associatio…
-
Calculation Manager -Allocation RulesI am using the Calculation Manager module to generate allocation reports. My report is based on a year-to-date format. However, sometimes my report is incomplete due to …
-
OIC Gen3 Rest API to generate an OAuth2 token using EPM Groovy script.Summary: Can anyone help me as The OIC gen 3 only allows OAuth and while the EPM Groovy script facilitates only Basic and API key based authentication. Content (please e…Rahul VargheseRoy 31 views 1 comment 0 points Most recent by Vijay Mahantesh-Oracle EPM Platform and Freeform
-
Pipeline execution stop/resetSummary: When executing/invoking a pipeline (REST) from Groovy if in case the pipeline name is incorrect or if a param or comma is missed the pipeline keeps polling and …NarayananS 21 views 1 comment 0 points Most recent by Randa-Support-Oracle EPM Platform and Freeform
-
Groovy script error query threshold limitSummary: Hi experts, I have written a groovy rule using flexibleDataGrid to export the dynamic calc Parent members plus all stored sparse members to a csv file . while e…Sreekumar Hariharan 41 views 1 comment 0 points Most recent by M. Kyle Goodfriend-Oracle EPM Platform and Freeform
-
Move EBS allocation rules to PCMCSSummary: We want to move EBS allocation rules to PCMCS. Please could some one advise how to extract definition of 200 EBS allocation rules (it uses backend Essbase cube)…Ravinder Singh-63390 11 views 2 comments 0 points Most recent by Ravinder Singh-63390 Profitability and Cost Management
-
Formula AssistanceI have a scenario where users budget on a data form to Department and Default_Account and not the 'Natural Account' from the G/L. So, now I learn each Department does ma…Hyperion_Junkie 41 views 14 comments 0 points Most recent by Hyperion_Junkie EPM Platform and Freeform
-
EPM Automate login using Connections in Groovy instead of using epw password fileSummary: Is it possible to use EPM Automate in Groovy BR for login? Am trying using getUserName(), getPassword() instead of using epw password file. Defined the connecti…NarayananS 81 views 7 comments 1 point Most recent by Suruchi S-Support-Oracle EPM Platform and Freeform
-
Convert to MDXHi, I have tried all kinds of iterations to convert this BSO calc to MDX. Any ideas/help? The Subvar &Prior_Year_1 is set to 'FY23'. I need it to return numeric value of…Hyperion_Junkie 31 views 2 comments 0 points Most recent by Hyperion_Junkie EPM Platform and Freeform
-
Member names only showing in rtp dialoguesSummary Only member name being shown when member selected (would like to see the alias)Content Hi, has anyone been able to surface an alias in an rtp when running a rule… -
General Tips for Improving Retrieval Performance for BSO cube?Summary: Need to restructure dimensions for optimal retrieval performance in reports, smartview, etc. Content (required): Need to restructure dimensions for optimal retr…
-
A validation error was received from the Planning server.Hi, I receive the bellow error when validating my script. DATACOPY &OEP_CurMnth->&OEP_CurYr->"OEP_Actual" TO "OEP_Yearly Plan"->(@ismbr(@MEMBER(@shiftsibling(&OEP_NextYe…