How to Enable Essbase menu in Excel (Essbase 11.1.2.2)

• First we need to check whether provider services are installed or not.
• Then go to excel   smart view options > advanced > shared connections url.  Here we need to enter the Smart View Provider URL -

                 http://<server>: port/workspace/SmartViewProviders.

•  And then we need to go in excel smart view > Panel. As shown below

• In the smart view  panel select ‘Shared connections > enter the credentials

• Now in smart view panel select ‘Private Connections > Create new connection (at the bottom).

•  The option shows as ‘Smart view http provider’ click on it and then enters URL as http:// <server>: port /aps/SmartViewProvider  and makes it as default connection.

• Click next and then connect to the data source of Essbase cluster as shown.

• And then select which application to be loaded.

• After the connection is set up double click on the particular application we can see Essbase option beside Smart view in Menu bar of Excel.