Documentation for CXO-Cockpit Reporting Suite 5.0, click for CXO-Cockpit Reporting Suite 4.3 Documentation or check the CXO-Cockpit Website.

Essbase Authentication Plugin

From CXO Cockpit Reporting Suite Documentation
Jump to: navigation, search

Essbase Authentication Plugin has been introduced as of release 4.3.2.

It allows users to login to the Essbase application of CXO-Cockpit by using their standard Essbase credentials.

How to configure the Essbase authentication adapter

Essbase authentication adapter is configured in CXO-Cockpit Configurator tool.

To enable the authentication adapter you need to put the required CXO-Cockpit instance into "Change authentication plugin" field and press "Save":


How does Essbase authentication adapter work?

  • Once Essbase authentication adapter is set up, you can log in into CXO-Cockpit with the user, created in Essbase. The user name and the password will be checked in Essbase itself. 
  • Essbase users need to be be registered in CXO-Cockpit anyway, but there is no need to maintain the paswords, as they will be stored directly in Essbase.
  • From the System Settings in Design Studio you can configure, which user will be used for retrieving metadata and building reports.

Below we describe the three scenarios, which you can use when operating with Essbase authentication plugin:

Validate password scenario

This scenario is used only to validate user login and password in Essbase.

If the checkbox next to "Use credentials of logged on user" is not checked, the metadata will be retrieved and reports will be created with the "Cockpit Service User" - this is Essbase admin user and login and password will be the same for all the users, created in the CXO-Cockpit. In this case we only check in Essbase if the user login and password are correct. Cockpit Service User is also used for generating report previews:


Filtering data scenario

This scenario is applied when you want to only filter data, but not metadata, retrieved  from Essbase.

If the checkbox next to "Use credentials of logged on user" is checked, the metadata will be retrieved and reports will be built with the current logged in Essbase user. The security settings in this case are applied from Essbase.

At the same time metadata will not be filtered:e.g. even the entities which are blocked in Essbase for the user, will be available in CXO-Cockpit POV selection, but they will not contain any data:


Filtering metadata scenario

Apply this scenario, if you want to filter metadata as well.

In Connector Properties menu you can configure how the metadata will be filtered:



If the checkbox next to "Filter MetaData" is checked, the medata will be filtered in the CXO-Cockpit.

To make it worka you also need to press "Refresh Filter Cache" button. In this way the metadata filters will be cached.

You also need to use this button when metadata filters and their outline are changed in Essbase or when new users are created.

What you need to consider when using Essbase authentication adapter

  1. Preface image rendering is done only with Cockpit Service User
  2. Sending views is disabled when Essbase authentication adapter is used
  3. Printing is done not from a separate service, but from CXO-Cockpit web application