Essbase Features
Discussion List
-
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 45 views 11 comments 0 points Most recent by Patrick Northcraft EPM Platform and Freeform -
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 …
-
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 …
-
ASO Input and Aggregate Data SizeHello, We are implementing an EPCM solution and are concerned about data generation and storage with ASO cubes. Primarily, we would like to better understand what contri…
-
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 12 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 11 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 42 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 33 views 2 comments 0 points Most recent by NarayananS 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 22 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 12 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…