Dimensions and Cubes
Discussion List
-
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… -
EPM Cloud Application - Import Zero Level Data did not complete successfullySummary: EPM Cloud Application - Import Zero Level Data did not complete successfully FMCONS Archive Test Cloud Application - Import Zero Level Data did not complete suc…schandy 33 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
New Hands-on Tutorials for FreeForm now availableWe are pleased to announce the availability of the following new Hands-on Tutorials. Hands-on Tutorials provide step-by-step instruction on how to complete a set of task… -
Can a Date Time Calendar be created in FreeFrom?Summary: Is there a way in freeform to create a date-time dimension calendar? Could this be something where Oracle provides a wizard or dimension artifact file? We are t… -
validate metadata optionSummary: As per new feature testing in patch 23.10, i have tried by clicking the checkbox validate metadata during DB refresh. However, it did not generate any file in o…Meenakshi Rajagopalan 21 views 1 comment 0 points Most recent by Ija Vidaurri EPM Platform and Freeform
-
How to Integrate Metadata in Oracle Fusion to be Custom Dimension in Oracle PBCSSummary: I would to ask about integration Oracle Fusion metadata (segment) to be dimension in Oracle PBCS, especially to be a custom dimension 1-4. I Already setup data …
-
Root Node access Permissions for ReadSummary: We have an intersection which has Accounts as top node and security enabled, and rest have some combination at levels users have access to. The below picture ex… -
Adding a space to the member alias when importing metadata to Data IntegrationSummary: The product alias is a combination of the product code plus the product description. Both are in a separate field and I want to concatenate those with: space hy…Jeroen Goudvis 32 views 4 comments 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
For YTD data load in FCC, what are the different ways to set up movement dimension?Summary: Please help with this query. Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support yo…Kartikey Panday 41 views 4 comments 0 points Most recent by Kartikey Panday EPM Platform and Freeform
-
Mapping of Dimension Members between applications based on Alias to member?Summary: To my understanding, data can be pulled directly using DataExchange from Target Application. We are looking for a way to transfer data between 2 EPM Planning Cl…
-
Strategic Workforce Planning - Member Names limit to be increased to at-least 90 characters.Summary: [Strategic Workforce Planning] Member Names limit requested to be increased to at-least 90 characters. Content (required): [Strategic Workforce Planning] Custom…Priyanka Yadav S-Oracle 41 views 2 comments 1 point Most recent by Patrick Northcraft EPM Platform and Freeform -
One of the COA segment value have the dash and its impact on EPMSummary: We are planning to have a COA department segment with a dash in middle of value. e.g. 101-1001. We would like to know the impact on EPM. Content (required): We …Hemant T 31 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
OFS_Expense Type displaying unwanted values based on Smart ListSummary: On the Project Expense sub tab Direct Entry the OPF_Expense Type member in the Project Account dimension displays predefined project expense accounts that aren'…
-
How do I get a form to format a non-account member with percentage data type, as a percentage?Summary: A custom dimension member is calculates % difference of 2 other members within the dimension. The calculation is correct, but I am (again) trying to find a way …
-
@ismbr() causing a validation error in EPBCS but is OK on 11.1.2.4 versionSummary: Member formula using @ismbr() is generating an error in EPBCS but OK on the on-premise 11.1.2.4 version. Application in both environments are BSO. Validation er…
-
data load optimization from Ms SQL Server to Free formSummary: Free form appllication has interfaced data from MS SQL server via EPM Agent method(Simple Mode). MS SQL has around 25 million records and during data load it ta…Aniruddhsinh-Oracle 21 views 3 comments 0 points Most recent by Aniruddhsinh-Oracle EPM Platform and Freeform
-
How to merge columns in Import FormatSummary: Hello, I am doing a metadata build of the Employee dimension with source from an MSSQL table with multiple fields. The query I defined in Data Exchange pulls 3 …
-
How to keep dimension Hierarchy changes in EPBCS?Summary: When Entity Hierarchy changes, how to keep the history of the old Hierarchy in EPBCS. Content (required): we keep making some dimension Hierarchy changes. For e…
-
Best method to Keep Current cube back up in same freeform applicationSummary: Best method to Keep Current cube back up in same application Content (required): Customer is using Essbase on-prem and as part of back up strategy, take complet…Aniruddhsinh-Oracle 11 views 2 comments 0 points Most recent by Brett Rooks EPM Platform and Freeform
-
In a FreeForm application, can each cube have its own, separate version of the same dimension?Summary: We have multiple Essbase cubes (taken as "backups" at the end of each year) that we'd like to migrate to a FreeForm app. Each cube has different versions of the…
-
"Your data request references a member that is unknown to Planning or Essbase" error in SmartViewSummary: When using a HsGetValue formula, unable to retrieve data for one member in the Account dimension. The issue is only with this one member. This member has been r…
-
Data Management - Lookup dimension in a metadata load?Is there a way to use a lookup dimension as part of a metadata load? When we tried to set one up for our Projects dimension. It only allowed "Generic" dimension (aka met…Peter Joelson 41 views 3 comments 0 points Most recent by Thejas Shetty-Oracle EPM Platform and Freeform
-
ERP Cloud BIP Report to EPBCS for loading Account dimension keeps failing!Hi All, I have created a BIP report in ERP Cloud, and while running the integration in data management it keeps failing with the following error: 2022-04-06 09:33:52,266…yanni vossos 131 views 1 comment 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform -
Smart View AdHoc analysis error - member xxxx is out of placeSummary: Smart View connected to FCCS but when running an AdHoc analysis an error popped up with: Member Account is out of place. Content (required): Hello, I've encount…
-
21.11 UPDATES TO DIMENSION INFORMATION IN THE ACTIVITY REPORTSummary: 21.11 cloud readiness says, "The Activity Report tables depicting outline dimension order and statistics of each cube in the application have been enhanced to i…
-
write on attributesSummary spread global amounts input on attributesContent Hello, We are analysing the possibilities we have to answer a new business request. Our headquarters (HQ) would …User_2025-02-07-10-02-37-171 25 views 1 comment 0 points Most recent by Helene THIEBAULT-Oracle EPM Platform and Freeform -
Best Validation Warning - DB RefreshSummary we are getting warning while refreshing DBContent We are getting warning message while refreshing DB for a cube in hybrid application which have a 2 dense dimens…