EPM Problem Rollup-smartview cannot connect essbase__ business intelligence

question:

When you use SmartView to share a connection, you do not have the option to connect Essbase, as shown in the following figure:

The normal connection should be the following figure:

Solve:

1.1 Installation Deployment APs

Install APS: Double-click installtool.cmd for installation, and check "Provider Services Web Application" below:

Always next, the other defaults until the installation is complete.

Deploy APS:

Click the "Start" menu-"EPM systemconfigurator" under Oracle EPM system to enter the deployment interface:

In the following figure, check "deploy to Application Server" under "Providerservices" under "Essbase":

Continue to the next step until the deployment is complete.

To reconfigure a Web server:

Deployment completed with one more APS service in the service, indicating successful deployment (pictured below):

Reboot the Foundation Server.

1.2 Add APS service manually

Connect Interop URLs (you can also log in to shared Services Console via workspace):

Expand Application Group--"Foundation"--"Deployment Metadata"--"Shared Services Registry"--"essbase"--"lwa-aps@planningapp_19000 Right-Datasources.xml, select Export for edit:

Modify the exported file "Datasources.xml.xml" as follows (the middle row is the added content, where IP is Essbase server IP):

<datasources><type name= "Essbase" >

<datasource srv= "IP" url= "app=" "cube=" "form=" "/>"

</type><typename= "OBIEE" ></type></dataSources>

After the modification, right-click "Datasources.xml" and select "Edit after Import" to import the modified file into the system.

Restart the Hyperion service.

Open the Excel connection SmartView shared connection test, at which point you can connect Essbase normally.