Dimensions and Cubes
Discussion List
-
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 32 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 38 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 42 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 32 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 22 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 12 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 43 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 134 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 26 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…
-
EPM – Cloud EPM Platform - New Web Adhoc; Recent and Upcoming Features in EPM Cloud Platform, 14 AprContent Submit your questions for the EPM – Cloud EPM Platform - New Web Adhoc; Recent and Upcoming Features in EPM Cloud Platform session to have them answered during t…Al Marciante-Oracle 60 views 3 comments 2 points Most recent by James Pryal EPM Platform and Freeform -
LRP scenario is not getting calculated by built in out of the box calculation Rules.Content HI, We need to implement Long range planning in our application. But we did not configure/enable the strategic modeling in our application. But we want to use th…