Calc Manager
Discussion List
-
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 45 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 111 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…
-
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 41 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…
-
Can groovy rules be used to "Start open period" in FCCS?Summary: Can groovy rules be used to "Start open period" in FCCS? Content (required): When load TB data from Fusion GL, FCCS users need to open the period first. Can gro…Xu, Angela Menglei 21 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Script or Template objects in Calc Manager, which one is better and why?Summary: Script or Template objects in Calc Manager, which one is better and why? Content (required): Hi All, I wanted to clarify what the community members think about …Fred_Mamadjanov 91 views 5 comments 0 points Most recent by Fred_Mamadjanov EPM Platform and Freeform -
Possible to expand shared parent members in a calc?Content I have a parent called "Alternate" that contains two shared parents ParentA and ParentB. I'd like to refer to "Alternate" in a FIX and have it return children C1…