Dimensions and Cubes
Discussion List
-
Report Prompt window is not displaying alias from Custom Alias Table in PlanningSummary: Report Prompt window→ Member Selection window→ displaying alias of Default Alias table instead of Custom Alias Table in Planning. We have a Custom Alias table o…Ganesh Golla 14 views 5 comments 0 points Most recent by Dave Roberts_-Oracle EPM Platform and Freeform -
ORACLE Financial Consolidation FCCS scenario yearly and monthlyHi all, we have an application FCCS with all scenario used with period detail → month. Now we would like to create a long term period scenario without detail of period (… -
Access Asset Description in writeback outbound integrationSummary: Hi, I have created a writeback outbound integration to write data from the OEP_CPX cube to a table in the On premise database with the help of EPM Integration A…
-
Unable to delete Shared entity from Oracle FCCSSummary: Hi All, In my project we are trying to delete few shared entities (from alternate hierarchies) from Oracle FCCS application. However FCCS is giving consolidatio…Himanshu Saxena 21 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Impacts of adding a new dimension to an ASO and BSO cubeSummary: We are required to add a new dimension to an ASO and BSO cube that has 5 years worth of data. On the refresh database it clears out all the existing data. What …Amrutha Muraleedharan 61 views 4 comments 0 points Most recent by Brett Rooks EPM Platform and Freeform -
How to update consolidation operator for "Not used for Cube"Summary: We need some help to pass the correct value in the integration to update the consolidation operator as Not used for Cube. Content (please ensure you mask any co…Tabish Neyaz 61 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Set Alias Table per Cube for SmartViewIs there a way for a specific alias table to be used as a default by cube in SmartView, instead of by the environment/connection? For example, cube "Losses" will default…
-
Unknown Member After RefreshSummary: Content (please ensure you mask any confidential information): I added a new member on the 26th and ran a refresh after, which completed successfully. However t… -
Inquiry regarding row/column/total cell limit for the EPM/PBCS REST API exportDataSlice methodSummary: We are using Applied OLAP's Dodeca product to access our EPM Cloud Freeform and FCCS applications. We seem to be hitting a retrieve time out in the API call the…
-
how many members can be creat in each dimension in freeformWe are going to implement oracle free form application, so we want to know how many members can create in each dimension. Becasuse there isn't any exact number of member…
-
how to enable view dimension in FINANCIAL moduleSummary: how to enable view dimension in FINANCIAL module Content (please ensure you mask any confidential information): We are looking to enable VIEW dimension in Finan…
-
Member formula not working as expected EPBCS ASOWe are encountering an issue with member formulas in an ASO Cube and would appreciate your insights. Scenario: In our Scenario dimension, we have four members: A, B, C, …
-
While building import format, new dimension is not visible in Data Management EPBCSWe created a new dimension named 'category'. While building import format, this dimension is not visible in the dropdown to map columns in EPBCS. We are using file based…
-
attribute dimension wrong behaviorHi community I am facing an issue with alternative hierarchy with member formula and attribute dimension members. Turns out that , the alternative rollup retrieves wrong… -
aso essbase member formulaSummary: How to handle a percentage calculation and a calculation that is using that percentage, both in a member formula. Results are ok on level0 but are being recalcu… -
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… -
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…TobiasK_ 71 views 4 comments 1 point Most recent by Suruchi S-Support-Oracle EPM Platform and Freeform -
Custom Attribute unique value can be added automatically in the LOV?Summary: Hi, I wanted to know if within the EPM scope we can add the new values automatically via integration (or any other way) into the Custom Attributes existing valu…
-
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…EPM-321 41 views 1 comment 0 points Most recent by Suruchi S-Support-Oracle EPM Platform and Freeform
-
Assistance Required: "Hierarchy Type" Option Disabled for Entity Dimension in PreProd and ProdHello All, Description: We are encountering an issue where the "Hierarchy Type" option for the Entity dimension is grayed out and unavailable for modification. Expected …
-
How can I load rates through Data Exchange using the EPM Agent?Summary: Error in loading average rate and ending rate in Financial Consolidation and Close through Data Exchange using the EPM Agent. Content (please ensure you mask an…
-
ASO Input and Aggregate Data SizeHello, We are implementing an EPCM solution and are concerned about data generation and storage with ASO cubes. Primarily, we would like to better understand what contri…
-
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…
-
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… -
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…