Art of BI: Automatically Deploy Smart View Upgrade

By Christian Screen | In Art of BI | November 23rd, 2009

Whether you are a user or implementer of Smart View there comes a time when an upgrade is necessary. Since each user installs the smart view binaries on their workstation/laptop, the question of how to push a system-wide upgrade may arise. Fortunately this functionality is built into Essbase Administration Services.

Instructions

1. From Enterprise View or a custom view, select the provider node under the Provider Services node.

2. Right-click and select Edit > Properties.

3. In Provider Services Properties, select Client Deployment.

4. Select an option:

Force Smart View client to upgrade—Requires the user to upgrade in order to continue using Smart View.
Warn Smart View client to upgrade—Informs users that a new version of Smart View is available to upgrade. Users can continue to use existing Smart View client without upgrading.
Apply Smart View client to upgrade—Enables the administrator to apply new versions of Smart View and inform users without needing to restart Provider Services.

5. Click Apply.

6. Click Close.

7. In the Provider Services directory, C:HyperionAnalyticProviderServicesredist, modify version.xml to add a line for the Provider Services URL:

http://<server_name>:13080/aps/SmartView>downloadClient

The same version.xml shows where to add the line:

&lt;?xml version="1.0" encoding="utf-8"?&gt;
&lt;CommonAddinVersion&gt;
&lt;internalVersion&gt;
&lt;major&gt;
2
&lt;/major&gt;
&lt;minor&gt;
0.1.0.0
&lt;/minor&gt;
&lt;/internalVersion&gt;
&lt;externalVersion&gt;
9.0.1.0
&lt;/externalVersion&gt;
&lt;installFile&gt;
http://&lt;server name&gt;:13080/aps/SmartView?downloadClient
&lt;/installFile&gt;
&lt;/CommonAddinVersion&gt;

<?xml version="1.0" encoding="utf-8"?>

<major>

</major>

<minor>

0.1.0.0

</minor>

</internalVersion>

9.0.1.0

</externalVersion>

http://<server name>:13080/aps/SmartView?downloadClient

</installFile>

</CommonAddinVersion>

———————————————————————————-

By completing the above steps, when users attempt to access provider services they will be prompted to upgrade.

References

Christian Screen

Christian is an innovator in analytics and data warehousing design, best practices, and delivery. With more than fifteenyears of decision support and data warehousing with key experiences at Office Depot HQ, Sierra-Cedar, and Capgemini, he oversees the Oracle Analytics Practice which includes the technical development and delivery of Oracle BI collaboration software, data warehouse solutions, Oracle BI/EPM projects, and packaged analytics solutions at Datavail.