Dimensions and Cubes
Discussion List
-
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 … -
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 … -
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…
-
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…
-
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 33 views 2 comments 0 points Most recent by Patrick Northcraft - Dropbox EPM Platform -
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 …
-
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…
-
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…
-
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…
-
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…
-
"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…
-
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… -
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 …
-
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…
-
Dedicated EPM Disaster Recovery standby environmentSummary Dedicated EPM Disaster Recovery standby environmentContent Hello - We are in process of evaluating if we should be configuring our own dedicated EPM DR standby e…
-
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… -
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…