Monday, October 1, 2012

Change Universe in SAP BusinessObjects 3.1

"Some objects are no longer available in the universe. See your BusinessObjects administrator. (Error: WIS00001)(Error: INF)"

SAP BusinessObjects 3.1

When you want to replace the universe, which is used in a Web Intelligence report by a new universe, you might get the error message "Some objects are no longer available in the universe. See your BusinessObjects administrator. (Error: WIS00001)(Error: INF)" even when all the dimensions and measures definitely exist in the new universe.
The reason is, that sometimes Web Intelligence doesn't use the object names to reference dimensions and measures of a universe, but it's own internal object ids. These object ids are not visible for the user, but when creating a new object in the universe, a new object id is created automatically.
To overcome the error in Web Intelligence after changing the universe, the only solution I have found is not to recreate the objects in the new universe, but to use the existing universe with the existing object ids and replace the SQL query in the properties. This way the object ids remain and the Web Intelligence report can reference the objects correctly.