Dimensions and Cubes
Discussion List
-
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 31 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 132 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 34 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 31 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… -
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 41 views 2 comments 0 points Most recent by Brett Rooks EPM Platform and Freeform
-
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 31 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 - Dropbox 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 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 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…