Dimensions and Cubes
Discussion List
-
Freeform ASO Compression DimensionI have a few questions about Freeform and an instance with a single ASO cube: Does Freeform require the Account dimension to be the compression dimension for an ASO cube… -
Error Creating Alternate Period Hierarchies for ASOHi, I am attempting to create an alternate structure in the period dimension, which will be subscribed only to an ASO Plan Type, to replicate the functionality of dynami… -
Changing the Entity Base Currency in a Freeform AppSummary: When creating a freeform application, the Entity Dimension Base Currency defaults to USD. Is there a way to change it to a different currency or that is a defau…
-
Attribute Dimension association not workingSummary: We have 2 attribute dimensions associated with our sparse Entity dimension, however when we assign an attribute to an Entity member it is not being applied. Con… -
Pull Dynamic Calc Member with DLRBackground: In FCCS, we currently have a level-0 member of the Account dimension (let's call it Account XYZ), which has a data storage type of "Dynamic Calc and Store". …
-
Max Character Limit for Text Data Type Members?Due to business requirements, we are leveraging a portion of a custom dimension to submit text commentary. We did not find the answer in Oracle documentation, so can any… -
Data Load failing in EPM Test but loading in EPM ProdSummary: We were able to load the same exact Integration in Prod but it is failing in test. Below is the error log from EPM Test: 2024-08-13 13:37:55,273 INFO [AIF]: FDM… -
Is it necessary to clear and load data during Hierarchy update in EPM cloudSummary: Is it necessary to clear and load data during Hierarchy update in EPM cloud. The Hierarchy updates typically involve moving the members, renaming member names/A…Satish Vanamadi 31 views 8 comments 0 points Most recent by Satish Vanamadi EPM Platform and Freeform
-
EPM FCCS - out of the box integration for loading metadata from Oracle ERP Cloud to EPM (Movement)Summary: EPM FCCS - out of the box integration for loading metadata from Oracle ERP Cloud to EPM (Account - Movement) Hi All, We are trying to integrate metadata from Or…
-
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…
-
EPM FCCS - out of the box integration for loading metadata from Oracle ERP Cloud to EPM (Attributes)Summary: Hi All, We are trying to integrate metadata from Oracle ERP to FCCS. How do we set up the attributes, especially for the entity, to set it to ICP_Entity_Yes, an…
-
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 61 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 13 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 55 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 41 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 81 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 270 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 41 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 11 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 11 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…