Dimensions and Cubes
Discussion List
-
Metadata Integration from Oracle ERP to EPM export is not working in Data ExchangeSummary: Metadata Integration from Oracle ERP to EPM export is not working in Data Exchange but working in Data Management Hi All, I've noticed that whenever I run and e… -
EPM FCCS - out of the box integration for loading metadata from Oracle ERP Cloud to EPM (Consol Op)Summary: Hi All, we are trying to integrate metadata from Oracle ERP to FCCS Cloud using out of the box integration. We noticed that the Consol Operator were ignored. Wh…
-
New member isn't recognized in Application.A few times in the last month when we have been importing a meta-data file with a new member isn't fully recognized by the application. The import and DB Refresh will co…Nathan Foutch 64 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
How to make Version dimension selection dynamic based on Scenario selectionSummary: Trying to figure out how to make the Version dimension selection on a report dynamic based on what is chosen by the user for Scenario. For example, if Actual is…
-
Cannot search by member alias after May 2024 updateSummary: After the latest update to version 24.05.66 there is no possibility to perform a search in default Entity dimension by member alias. Only the search by member n…Martynas Storasta 14 views 3 comments 0 points Most recent by Dave Roberts_-Oracle EPM Platform and Freeform
-
EPBCS - what are the reasons for 200MB limitation for export file in EPBCS?Hi, Currently there is a limitation of 200 MB on the size of the export file when executing a Datamap in EPBCS via a Groovy Rule which is causing us a bit of a headache …AyandaKrumalo12 72 views 2 comments 0 points Most recent by AyandaKrumalo12 EPM Platform and Freeform -
Number of BSO cubes in EPM Cloud Enterprise custom application (more than 3 BSO)Hi, As per oracle doc 2706999.1 it is clearly mentioned that a Custom Planning application under EPM Cloud Enterprise license can support up to 6 BSO cubes. In our case,…John Kolitsopoulos 83 views 10 comments 0 points Most recent by Vijay Mahantesh-Oracle EPM Platform and Freeform
-
How do I identify metadata with no data?Summary: We have over 100,000 members in our Project Dimension. Each year we go through the process of exporting data, importing into a SQL database, and querying to ide… -
User not able to see data in actual scenarioSummary: I have a user who is a system admin, but cannot view data in the scenario for Actual ; They can see budget but when they try to render data for actuals in a rep…Dustin Peeples 71 views 4 comments 0 points Most recent by Vijay Mahantesh-Oracle EPM Platform and Freeform
-
ASO Sum crossjoin syntaxSummary: We are attempting to implement a Trailing Twelve Months/Last twelve months in our ASO cube. We have a working formula in our BSO cube that is producing desired …ColtonB919 82 views 25 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Groovy to access a file in Inbox/Outbox explorerSummary: Is there a way to access a CSV (precisely a metadata file) present Inbox/Outbox explorer using groovy? Intention is to Automate Metadata across apps Am able to …NarayananS 421 views 13 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Pre-update analysis and Impact analysis in EPCMSummary: We had Pre-update analysis and Impact analysis feature in PCM to Identify any rules that will be impacted as apart of the monthly metadata changes during the cl…Bhavani Gajula 11 views 2 comments 0 points Most recent by Raavi Divya sri-Oracle 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 42 views 14 comments 0 points Most recent by Hyperion_Junkie EPM Platform and Freeform
-
PBCS member formulaHi all, I have a scenario to reference value from same dimension(Measurement) in member formula. Measurement Global_Assumptions Worker_Type (SmartList values : Internal_…
-
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
-
Setup Account/Period dimensions as CustomWhat are the implications of setting up Account and Time Period dimensions as Custom dimension in EPM Planning/Freeform?Satish Vanamadi 14 views 1 comment 0 points Most recent by Vijay Mahantesh-Oracle EPM Platform and Freeform
-
Pipeline to extract EDM dimensionSummary: Can we extract (not export) EDM dimension into EPM freeform/planning using Pipeline. PS: We are successful in creating a Pipeline that can export the EDM dimens…Satish Vanamadi 12 views 1 comment 0 points Most recent by GaneshN-Support-Oracle EPM Platform and Freeform
-
TRCS - Is there some functionality to toggle on a disregarded entityIs there some functionality to toggle on a disregarded entity that is an opaque entity from a foreign legal and financial reporting standpoint, since DRE’s are a common …
-
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…
-
MDX Formula for ISMBRSummary: Hello, How can I write in MDX language (for ASO cube) this formula? IF(@ISMBR( @RELATIVE ("Tot_Cost_Center", 0) ) ) "CE-1"; ENDIF; Thanks, Davide Content (pleas…DavidePacilio 185 views 41 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
EPBCS Security to see Total Financials without seeing Granular detailsSummary: Hi Experts, We have some of our grocery stores being divested. Our C-Suite still needs to be able to see Total Financials in aggregate for the entire company, h…
-
This is related to EPM PlanningFCCSummary:This is related to EPM Planning/FCC Content (please ensure you mask any confidential information): This is related to EPM Planning/FCC We want to know about the …
-
Unable to create multiple currencies in EPBCS FreeForm application?Summary Unable to create multiple currencies in EPBCS FreeForm application. Content (please ensure you mask any confidential information): I created a EPBCS Planning "Fr…
-
Free Form Application Creation for different year cubesSummary: Currently we are having different application with respect to different year which is ASO cubes . We are planning to create a single application which contains …
-
Options to load metadata from an HFM XML file to FCCSSummary: Hello experts, What are the options available to load metadata from HFM which is in XML format into FCCS ? Could you please share your ideas if you have impleme…Payal Vaidya-Oracle 33 views 4 comments 0 points Most recent by M. Kyle Goodfriend-Oracle EPM Platform and Freeform -
List of all essbase error codesSummary: I'm looking for a list of all the Essbase errors with codes and descriptions. Can anyone help me with it? I'm not able to find them. For example, I'm facing the…Shareef_Ahamed 313 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
How to convert FCCS_YTD to ASOSummary: Using MDX we want to replicate the FCCS_YTD member formula Content (please ensure you mask any confidential information): We are feeding FCCS data to Freeform A…Gary Popielarczyk 11 views 3 comments 0 points Most recent by Gary Popielarczyk EPM Platform and Freeform -
ASO Cube deletionHi. We are planning to delete the ASO cube from Oracle EPM Cloud (PBCS) application. Please let us know the best practices / recommendations to implement the solution wi…
-
Maximum Alias Members LengthSummary: Workaround to use longer than 80 char for member aliases Content (please ensure you mask any confidential information): Hi everybody, I have read on the officia…Marco T 32 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Ability to Add Prior Years After Application was CreatedSummary: I thought we are not able to add prior years after application was created with a specific start year but Admin Guide suggests that we can do it. When did it ch…