Essbase Technical Reference Series: essbase.cfg

This website stores cookies on your computer. These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media. To find out more about the cookies we use, see our Privacy Policy.

We won’t track your information when you visit our site. But in order to comply with your preferences, we’ll have to use just one tiny cookie so that you’re not asked to make this choice again.

[Accept](javascript:void(0);)[Decline](javascript:void(0);)

Esp: **[![Image 2: espanol](https://www.mindstreamanalytics.com/images/espanol.jpg)](https://www.mindstreamanalytics.com/esp/blog/referencia-tecnica-de-essbase-serie-essbase-cfg.html)**

Language: **[![Image 3: language](https://www.mindstreamanalytics.com/images/english.jpg)](https://www.mindstreamanalytics.com/blog/essbase-technical-reference-series-essbase-cfg.html)**

Call Us: **1-800-497-0151**

[![Image 4: LOGO](https://www.mindstreamanalytics.com/img/logo-base.png)](https://www.mindstreamanalytics.com/)

  • [](https://twitter.com/MSAnalytics)
  • [](https://www.linkedin.com/company/mindstream-analytics?trk=hb_tab_compy_id_718482)

Follow Us:

  • [Services](https://www.mindstreamanalytics.com/services.html)
  • [See All Services](https://www.mindstreamanalytics.com/services.html)
  • [Advisory and Consulting](https://www.mindstreamanalytics.com/advisory-and-consulting.html)
  • [Assessment Services](https://www.mindstreamanalytics.com/assessment-services.html)
  • [Cloud Readiness](https://www.mindstreamanalytics.com/cloud-readiness.html)
  • [EPM RoadMap](https://www.mindstreamanalytics.com/epm-roadmap.html)
  • [Product Selection](https://www.mindstreamanalytics.com/product-selection.html)
  • [Solution Implementation](https://www.mindstreamanalytics.com/solution-implementation.html)
  • [For FP & A](https://www.mindstreamanalytics.com/financial-planning-and-analysis.html)
  • [For Controller](https://www.mindstreamanalytics.com/controllers.html)
  • [AppCare Managed Services](https://www.mindstreamanalytics.com/managed-services.html)
  • [Data Management](https://www.mindstreamanalytics.com/data-management.html)
  • [Analytics](https://www.mindstreamanalytics.com/analytics.html)
  • [Training](https://www.mindstreamanalytics.com/training.html)
  • [Support](https://www.mindstreamanalytics.com/netsuite-planning-support.html)
  • [Solutions](https://www.mindstreamanalytics.com/datasheets.html)
  • [MindStream ToolBox](https://www.mindstreamanalytics.com/toolbox.html)
  • [MindStream Software](https://mindstreamsw.com/solutions/)
  • [Accrual Manager](https://www.mindstreamanalytics.com/accrual-manager.html)
  • [Sheets for OneStream](https://www.mindstreamanalytics.com/sheets-for-onestream.html)
  • [Technology Partners](https://www.mindstreamanalytics.com/blog/essbase-technical-reference-series-essbase-cfg.html#)
  • [OneStream](https://www.mindstreamanalytics.com/partners/onestream.html)
  • [CPM Express](https://www.mindstreamanalytics.com/partners/onestream/cpm-express.html)
  • [Capital Planning](https://www.mindstreamanalytics.com/partners/onestream/capital-planning.html)
  • [Cash Planning](https://www.mindstreamanalytics.com/partners/onestream/cash-planning.html)
  • [Data Blending](https://www.mindstreamanalytics.com/partners/onestream/data-blending.html)
  • [Extensible Dimensionality](https://www.mindstreamanalytics.com/partners/onestream/extensible-dimensionality.html)
  • [Financial Consolidation and Close](https://www.mindstreamanalytics.com/partners/onestream/financial-consolidation-and-close.html)
  • [OneStream Marketplace](https://www.mindstreamanalytics.com/partners/onestream/marketplace.html)
  • [Application Control Manager](https://www.mindstreamanalytics.com/onestream-marketplace-application-control-manager.html)
  • [Compliance Solutions](https://www.mindstreamanalytics.com/onestream-marketplace-compliance-solutions.html)
  • [Sales Planning](https://www.mindstreamanalytics.com/onestream-marketplace-solutions-sales-planning.html)
  • [Sensible Machine Learning](https://www.mindstreamanalytics.com/onestream-marketplace-solutions-sensible-machine-learning.html)
  • [Thing Planning](https://www.mindstreamanalytics.com/onestream-marketplace-solutions-thing-planning.html)
  • [Transaction Matching](https://www.mindstreamanalytics.com/onestream-marketplace-solutions-transaction-matching.html)
  • [Oracle Hyperion Conversion](https://www.mindstreamanalytics.com/partners/onestream/oracle-hyperion-conversion.html)
  • [Planning Budgeting and Forecasting](https://www.mindstreamanalytics.com/partners/onestream/planning-budgeting-and-forecasting.html)
  • [NetSuite](https://www.mindstreamanalytics.com/partners/netsuite.html)
  • [NetSuite Planning and Budgeting](https://www.mindstreamanalytics.com/oracle-netsuite-planning-and-budgeting.html)
  • [NetSuite Analytics Warehouse](https://www.mindstreamanalytics.com/netsuite-aw.html)
  • [NetSuite SuiteSuccess](https://www.mindstreamanalytics.com/netsuite-suitesuccess.html)
  • [Oracle](https://www.mindstreamanalytics.com/partners/oracle.html)
  • [Oracle Analytics Cloud](https://www.mindstreamanalytics.com/oracle-analytics-cloud.html)
  • [Oracle Planning and Budgeting Cloud Service(PBCS)](https://www.mindstreamanalytics.com/oracle-planning-and-budgeting-cloud-service.html)
  • [Oracle Enterprise Performance Reporting Cloud Service(EPRCS)](https://www.mindstreamanalytics.com/oracle-enterprise-performance-reporting-cloud-services.html)
  • [Financial Consolidation and Close Cloud](https://www.mindstreamanalytics.com/financial-consolidation-and-close-cloud-fccs.html)
  • [Oracle Data Relationship Management](https://www.mindstreamanalytics.com/oracle-drm.html)
  • [Dodeca(Applied OLAP)](https://www.mindstreamanalytics.com/partners/dodeca.html)
  • [Resource Center](https://www.mindstreamanalytics.com/resource-center/index.html)
  • [Webinar Series](https://www.mindstreamanalytics.com/webinars.html)
  • [Tips and Tricks](https://www.mindstreamanalytics.com/epm-tips-and-tricks.html)
  • [White Papers](https://www.mindstreamanalytics.com/whitepapers.html)
  • [Blog](https://www.mindstreamanalytics.com/blog.html)
  • [About Us](https://www.mindstreamanalytics.com/aboutus.html)
  • [Who we are?](https://www.mindstreamanalytics.com/aboutus.html)
  • [Meet Our Team](https://www.mindstreamanalytics.com/management-team.html)
  • [Company Statement](https://www.mindstreamanalytics.com/ourcompany.html)
  • [Careers](https://www.mindstreamanalytics.com/careers.html)
  • [Customer Financing](https://www.mindstreamanalytics.com/customer-financing.html)
  • [Case Studies](https://www.mindstreamanalytics.com/casestudies/index.html)
  • [Contact Us](https://www.mindstreamanalytics.com/contactus.html)
  • [Ask an Expert](https://www.mindstreamanalytics.com/ask-an-expert.html)
  • [Services](https://www.mindstreamanalytics.com/services.html)
  • [Advisory and Consulting](https://www.mindstreamanalytics.com/advisory-and-consulting.html)
  • [Assessment Services](https://www.mindstreamanalytics.com/assessment-services.html)
  • [Cloud Readiness](https://www.mindstreamanalytics.com/cloud-readiness.html)
  • [EPM RoadMap](https://www.mindstreamanalytics.com/epm-roadmap.html)
  • [Product Selection](https://www.mindstreamanalytics.com/product-selection.html)
  • [Solution Implementation](https://www.mindstreamanalytics.com/solution-implementation.html)
  • [For FP & A](https://www.mindstreamanalytics.com/financial-planning-and-analysis.html)
  • [For Controller](https://www.mindstreamanalytics.com/controllers.html)
  • [AppCare Managed Services](https://www.mindstreamanalytics.com/managed-services.html)
  • [Data Management](https://www.mindstreamanalytics.com/data-management.html)
  • [Analytics](https://www.mindstreamanalytics.com/analytics.html)
  • [Training](https://www.mindstreamanalytics.com/training.html)
  • [Support](https://www.mindstreamanalytics.com/netsuite-planning-support.html)
  • [Solutions](https://www.mindstreamanalytics.com/datasheets.html)
  • [MindStream ToolBox](https://www.mindstreamanalytics.com/toolbox.html)
  • [MindStream Software](https://mindstreamsw.com/solutions/)
  • [Accrual Manager](https://www.mindstreamanalytics.com/accrual-manager.html)
  • [Sheets for OneStream](https://www.mindstreamanalytics.com/sheets-for-onestream.html)
  • [Technology Partners](https://www.mindstreamanalytics.com/partners/index.html)
  • [OneStream](https://www.mindstreamanalytics.com/partners/onestream.html)
  • [CPM Express](https://www.mindstreamanalytics.com/partners/onestream/cpm-express.html)
  • [Capital Planning](https://www.mindstreamanalytics.com/partners/onestream/capital-planning.html)
  • [Cash Planning](https://www.mindstreamanalytics.com/partners/onestream/cash-planning.html)
  • [Data Blending](https://www.mindstreamanalytics.com/partners/onestream/data-blending.html)
  • [Extensible Dimensionality](https://www.mindstreamanalytics.com/partners/onestream/extensible-dimensionality.html)
  • [Financial Consolidation and Close](https://www.mindstreamanalytics.com/partners/onestream/financial-consolidation-and-close.html)
  • [OneStream Marketplace](https://www.mindstreamanalytics.com/partners/onestream/marketplace.html)
  • [Application Control Manager](https://www.mindstreamanalytics.com/onestream-marketplace-application-control-manager.html)
  • [Compliance Solutions](https://www.mindstreamanalytics.com/onestream-marketplace-compliance-solutions.html)
  • [Sales Planning](https://www.mindstreamanalytics.com/onestream-marketplace-solutions-sales-planning.html)
  • [Sensible Machine Learning](https://www.mindstreamanalytics.com/onestream-marketplace-solutions-sensible-machine-learning.html)
  • [Thing Planning](https://www.mindstreamanalytics.com/onestream-marketplace-solutions-thing-planning.html)
  • [Transacation Matching](https://www.mindstreamanalytics.com/onestream-marketplace-solutions-transaction-matching.html)
  • [Oracle Hyperion Conversion](https://www.mindstreamanalytics.com/partners/onestream/oracle-hyperion-conversion.html)
  • [Planning Budgeting and Forecasting](https://www.mindstreamanalytics.com/partners/onestream/planning-budgeting-and-forecasting.html)
  • [NetSuite](https://www.mindstreamanalytics.com/partners/netsuite.html)
  • [Oracle NetSuite Planning and Budgeting](https://www.mindstreamanalytics.com/oracle-netsuite-planning-and-budgeting.html)
  • [NetSuite Analytics Warehouse](https://www.mindstreamanalytics.com/netsuite-aw.html)
  • [NetSuite SuiteSuccess](https://www.mindstreamanalytics.com/netsuite-suitesuccess.html)
  • [Oracle](https://www.mindstreamanalytics.com/partners/oracle.html)
  • [Oracle Analytics Cloud](https://www.mindstreamanalytics.com/oracle-analytics-cloud.html)
  • [Oracle Planning and Budgeting Cloud Service(PBCS)](https://www.mindstreamanalytics.com/oracle-planning-and-budgeting-cloud-service.html)
  • [Oracle Enterprise Performance Reporting Cloud Service(EPRCS)](https://www.mindstreamanalytics.com/oracle-enterprise-performance-reporting-cloud-services.html)
  • [Financial Consolidation and Close Cloud](https://www.mindstreamanalytics.com/financial-consolidation-and-close-cloud-fccs.html)
  • [Oracle Data Relationship Management](https://www.mindstreamanalytics.com/oracle-drm.html)
  • [Dodeca(Applied OLAP)](https://www.mindstreamanalytics.com/partners/dodeca.html)
  • [Resource Center](https://www.mindstreamanalytics.com/resource-center/index.html)
  • [Webinar Series](https://www.mindstreamanalytics.com/webinars.html)
  • [Tips and Tricks](https://www.mindstreamanalytics.com/epm-tips-and-tricks.html)
  • [White Papers](https://www.mindstreamanalytics.com/whitepapers.html)
  • [Case Studies](https://www.mindstreamanalytics.com/clients.html)
  • [Blog](https://www.mindstreamanalytics.com/blog.html)
  • [About Us](https://www.mindstreamanalytics.com/aboutus.html)
  • [Meet Our Team](https://www.mindstreamanalytics.com/management-team.html)
  • [Company Statement](https://www.mindstreamanalytics.com/ourcompany.html)
  • [Careers](https://www.mindstreamanalytics.com/careers.html)
  • [Customer Financing](https://www.mindstreamanalytics.com/customer-financing.html)
  • [Contact Us](https://www.mindstreamanalytics.com/contactus.html)
  • [Ask an Expert](https://www.mindstreamanalytics.com/ask-an-expert.html)

Blog

  • Category:
  • [Blog](https://www.mindstreamanalytics.com/blog.html)

Essbase Technical Reference Series: essbase.cfg

  • Brett Gillis , Business Analyst
  • 4-24-18
Image 5: oracle epm automate

Today I’ll be reviewing configuration settings in your **Essbase server** , and how you can update these and maintain them.

In order to make your [Essbase](https://www.mindstreamanalytics.com/articles/essbase.html) server work the way you need it to, it’s essential to understand the Essbase configuration file.

The **essbase.cfg** file is a powerful and centralized tool for managing your server configuration settings. Most of the settings in **essbase.cfg** apply to the entire Essbase server, but some are specific to applications or databases.

Now the first question to ask here is obviously “where do I find the configuration file”?

The **essbase.cfg** can be accessed in the directly in the Essbase server from the OS ( **under ARBORPATH/bin** ), but the easiest and most user-friendly way to edit it is through EAS, by right-clicking the server name and clicking on **Edit > Properties > Environment** .

A couple things to note:

  • Each setting should be entered on a separate line in the file.
  • Semicolon terminators are not required, as opposed to in calculation scripts.
  • Moreover, semicolons can be used at the beginning of a line to comment it out.
  • Make sure to make no duplicate settings, especially with different values!
  • No syntax check is performed when you upload this file. Double check your work!
  • A lot of the **essbase.cfg** settings affect performance. Make sure to test before implementing in production.
  • Changes to the **essbase.cfg** are not applied until Essbase services are restarted. Plan accordingly!

Now understandably there are a lot of nuances when it comes to correctly setting up this file for your server, and it would be impossible to teach all in one post. For now, we can take a look at the configuration categories that are available:

  • Backup and Recovery Configuration Settings
  • Calculation Configuration Settings
  • Data Import and Export Configuration Settings
  • Oracle Exalytics In-Memory Machine Configuration Settings
  • Failover Clustering Configuration Settings
  • Logging and Error Handling Configuration Settings
  • Memory Management Configuration Settings
  • Miscellaneous Configuration Settings
  • Partitioning Configuration Settings
  • Ports and Connections Configuration Settings
  • Query Management Configuration Settings
  • Security File Configuration Settings

So, as you can see this file does have a lot of things that are vital in setting up your server settings properly, but be wary and test thoroughly before deploying any changes to your production environment.

While obviously there is still a lot to review here as far as the intricacies of the file, we’ll stop with just the overview to provide some background and a broad understanding of what exactly it’s used for.

Stay tuned for more!