IT Analytics Cube Pivot Table buttons greyed out

Products

• IT Analytics

Issue/Introduction

When accessing the cube pivot table the buttons are greyed out.

No error, buttons are greyed out.

Cause

Incorrect version of the OWC.DLL installed.

Resolution

This has been seen when an incorrect version of the owc11.dll is installed. You can check the version by clicking the Web component icon on the upper left corner of the pivot table.

We require the version to be 12.0.4518.1014.
If a different version is listed you will need to remove the file and run the installer which can be downloaded at 
http://www.microsoft.com/downloads/details.aspx?FamilyId=7287252C-402E-4F72-97A5-E0FD290D4B76&displaylang=en.

The file to remove is located at C:\Program Files (x86)\Common Files\microsoft shared\Web Components\11\OWC11.DLL

You can verify this is correct by right-clicking the file and going to the details tab, this should show the same version listed

in the console when pushing the web component icon. Once removed run the web component installer.

Now you can check the newly installed DLL to be the correct version 12.0.4518.1014.

This will need to be performed on each machine with the incorrect DLL version installed.

Applies To

SMP 7.1sp2

SQL 2008r2

Windows 7 professional sp1