Issue after Upgrade from 11.1.1.6.0 to 11.1.1.6.2 BP1

Issue after Upgrade from 11.1.1.6.0 to 11.1.1.6.2 BP1

After upgrade to bundle patch set 11.1.1.6.2 The new SQL generated by the .RPD file aggregates data incorrectly.

Solution

1)      Take a copy of the 11.1.1.6.0 .RPD file (repository version 318)

2)      Open the 11.1.1.6.2 version of the Admin tool  (repository version 320)

3)      Open the 11.1.1.6.0 version of the .RPD file with the 11.1.1.6.2 version of the Admin tool.

4)      Save the .RPD file and upload it.

Note that opening a copy of the .RPD file from the upgraded (11.1.1.6.2) OBIEE server will not work.  The version of that RPD is already 11.1.1.6.2, so the 11.1.1.6.2 Admin tool will not “upgrade” it to the current version.  You need to use the 11.1.1.6.0 RPD.

Reference:

http://www.biztech.com/blog/2012/10/obiee-11-1-1-6-2-issues/

Till next time...