Calc Manager
Discussion List
-
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…Patrick Northcraft - Dropbox 47 views 5 comments 1 point Most recent by Brett Rooks EPM Platform and Freeform -
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 35 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 17 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 26 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 62 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
-
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 4 comments 0 points Most recent by AA_AlfonsoGonzalez Financial Consolidation and Close -
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…
-
Calc Manager "Errors and Warnings" tab not displaying the actual blocksSummary: When executing the "Warnings and Errors" check against any rule it reports 0 Actual blocks. This used not to be the case, the report would identify the potentia…Luis Autrique 11 views 1 comment 1 point Most recent by Stephanie Gianetti-Oracle EPM Platform and Freeform -
Effect of removing a Service Administrator from EPM Planning Cloud who currently owns artefacts.We want to remove a former EPBCS/Planning service administrator from our Identity Domain, and consequently Planning. The individual is currently the owner of a number of…Alan Turnbull 31 views 1 comment 0 points Most recent by Suruchi S-Support-Oracle EPM Platform and Freeform
-
Can not use rankOrderType within @RANK on PBCSSummary: Can not use rankOrderType within @RANK on PBCS Content (please ensure you mask any confidential information): This is Syntax of @RANK (rankOrderType, SKIPNONE |…
-
DATAEXPORT is missing implied sharesSummary: We are using DATAEXPORT in an EPM Cloud Planning application for bulk data exports. When Accounts dimension is not specified in the containing FIX, implied shar…
-
Rename Snapshot - GroovySummary: Trying to Rename Snapshot using a Groovy BR , The URL for EPM as a connection for mandates '/HyperionPlanning' and Other web service provider does not mandate t…NarayananS 45 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Simple logical calculation of budget transferThe below code is supposed to run in a second or two but it's running for 20-30mins and giving wrong results. It's filling all the cells. I checked and we have 10 dimens…
-
Any reason why the BR/template disappear from the action menu in EPBCSSummary: BR/Template disappear from the action menu Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
powershell runBusinessRule syntaxSummary: Team I am hitting a wall today. For some reason I cannot get powershell to execute a run business rule command on planning. I have tried single and double quote…
-
Error while creating New Project in Projects ModuleSummary: Encountering Error while creating New Project in Projects Module Content (required): Hi All, Getting this error while creating New Project with OOTB Add Project…