Essbase Features
Discussion List
-
Exclude negative data in member formulaSummary: hello, Need some advise on how to exclude months with negative values in the data set when taking an average. We are currently doing this within Excel's functio…Zut Alors 62 views 5 comments 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform -
Release date Essbase 21c update in EPM?Summary: Essbase 21c update is in the Upcoming section of the latest EPM roadmap. Is there an anticipated release date for Essbase 21c in EPM? What improvements can we e… -
I am having trouble loading currency conversion rates in EPM - we recently converted to Hybrid mode.Summary: We are trying to update forecast rates but not able to do so for 2025. We checked the application configuration settings and ensured current fiscal year is 2025…
-
I have an EPBCS MDX Outline formula and want to perform logic to only the parent member Total EntitySummary: I have an EPBCS MDX Outline formula where I want to perform logic to only the parent member 'Total Entity', yet it is applying to all embers under Total Entity …Glenn Durkin 44 views 2 comments 0 points Most recent by Patrick Northcraft EPM Platform and Freeform
-
In EPBCS MDX Outline formula, is there a way to use the Except Function after When IS Function?For example I have the below Account formula and it shows values for all brands within Pillar_220, yet I want to exclude certain brands (that roll up to other Pillars). …Glenn Durkin 41 views 11 comments 0 points Most recent by Patrick Northcraft EPM Platform and Freeform
-
General Question for Cloud limitationsSummary: We are in process of evaluating On-Premises Essbase cubes (11.2 & 11.1.2.4) to Cloud (Planning & Freeform) inclusive of rationalization of cubes. Content (pleas…
-
How does the migration from Standard to Enterprise Application occurs & the process/Action Items?Kindly provide us with the information regarding the timelines, how Oracle handles the migration - will the instance will be upgraded with the licensing directly on the …
-
What are the pre-requisites & considerations to upgrade the EPM Applications to Enterprise edition?Please provide more information on the pre-requisites & considerations to upgrade the EPM Applications to Enterprise edition. Thanks in advanceShilpa Char 32 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
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…
-
Inquiry on New Roles in EPM Cloud Planning - Power User (Dashboards -Manage, Documents - Manage)Summary: In the "Role Assignment Report" tab, I can see an additional role has been added—"Dashboards - Manage, Documents - Manage" under "Power User," which weren’t the…
-
Copy Version in EPCMCSSummary: Hi all, does it is possible to use the out-of-the-box copy version functionality in an EPCMCS application? I can only see the Copy Data Functionality, but i nee…
-
ASO Custom Calculation vs. Graphical Editor DifferenceHi folks, I'm working in a custom EPM Planning app and trying to create an ASO business rule to calculate a percentage of total headcount. I can use the graphical design… -
Exported Report shows Report name for excel tabs instead of 'Pages' member namesIn Financial Reporting, when we export a Report to Excel, the dimension members selected in the 'Pages' section of the Financial Reporting web studio are exported to sep…
-
How to Copy Data from a combination to another combination using groovy in PCMSSummary: Need to Copy Data from a combination to another combination in a form using groovy in PCMCS Content (please ensure you mask any confidential information): Versi…Sri Harsha Panchumarthy 41 views 5 comments 0 points Most recent by Harish Kumar C Profitability and Cost Management
-
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…
-
Metadata Integration from Oracle ERP to EPM export is not working in Data ExchangeSummary: Metadata Integration from Oracle ERP to EPM export is not working in Data Exchange but working in Data Management Hi All, I've noticed that whenever I run and e…
-
Essbase error 1060168Summary: I am trying to delete a year 2003 and received error code 1060168. There is no documentation on this error; any help on this will be highly appreciated. Content…Naveen_Bonakurthi-Oracle 13 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
Quantity of instances that can be created using Plan: Oracle Enterprise Performance Management.Hi, How many instances can i create to use for with other applications? (My plan its: Oracle Enterprise Performance Management). Nowadays, i've 1 application for EPM pro…Caio Silva 11 views 1 comment 0 points Most recent by Vijay Mahantesh-Oracle EPM Platform and Freeform
-
Move EBS allocation rules to PCMCSSummary: We want to move EBS allocation rules to PCMCS. Please could some one advise how to extract definition of 200 EBS allocation rules (it uses backend Essbase cube)…Ravinder Singh-63390 12 views 2 comments 0 points Most recent by Ravinder Singh-63390 Profitability and Cost Management
-
Formula AssistanceI have a scenario where users budget on a data form to Department and Default_Account and not the 'Natural Account' from the G/L. So, now I learn each Department does ma…Hyperion_Junkie 41 views 14 comments 0 points Most recent by Hyperion_Junkie EPM Platform and Freeform
-
Multi Year Data Load in Quick ModeSummary: I'm loading Freeform ASO cube with data from SQL server table VIA EPM Integration Agent(Full Load) through Quick mode option and the load is successful. Able to…Kalaivani Ravichandran 21 views 2 comments 0 points Most recent by Kalaivani Ravichandran EPM Platform and Freeform -
Quick Mode -Loading data into Freeform ASO cube through Data IntegrationSummary: Hi, Loading Freeform ASO cube with data from SQL server table VIA EPM Integration Agent(Full Load). As this method took more hours to load data , I gave a try w…Kalaivani Ravichandran 32 views 2 comments 0 points Most recent by Narayan EPM Platform and Freeform
-
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
-
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 13 views 2 comments 0 points Most recent by Brett Rooks EPM Platform and Freeform
-
Faster way for Data Extraction out of on-prem Essbase for freeform applicationSummary: Hi All, We are extracting data from an on-prem Essbase application (single BSO cube) to load into the Freeform application. Due to the data size, we cannot extr…