@variable('UNVID') not updated in different repository

building semantic layer
1

In BO XI 3.1 SP6.3 @variable(‘UNVID’) exists that returns the ID of the universe object.
I am a bit confused under what circumstances it shows a Universe ID.

When the variable is queried in a Web Intelligence report, it shows the Universe ID from a BO repository the report was originally saved to. If you open the report in a different repository - even after it had been exported to that repository - it still shows the original ID.

The only way I seem to resolve it, is by manually re-attaching the report data provider to the universe. Only then BO shows the correct Universe ID that is applicable for the different repository.
I wonder if other people had similar issues and have found a better workaround for it.

Thanks in advance.

Tim Janssen (BOB member since 2004-09-10)

2

Could it be the universe has become “unbound”? The universe CUID should be the same across your different environments?

http://www.businessobjectstips.com/tips/web-intelligence/what-is-an-unbound-report-and-why-should-i-care/

Mak 1 :uk: (BOB member since 2005-01-06)

3

Thanks for pointing me to the ‘unbound report’-blog, Mak I.
A Universe having a different CUID in different repositories could be a logical cause for @variable(‘UNVID’) not displaying a correct value.

I did conduct a small test by exporting a Universe from repository X to a BIAR-file using the Import Wizard. In repository Y I then imported the file. After this step the Universe did exist in both repositories sharing the same CUID.
Unfortunately, querying @variable(‘UNVID’) in a Web Intelligence report then still behaves as described in my original mail. Explicitly re-attaching the report data provider to the universe is the only solution.

Maybe the @variable(‘UNVID’) will behave differently in BO XI 4.x. Until then, I will write instructions for my colleagues whenever a BO XI 3.1 Web Intelligence report needs to be migrated from one repository to the other, to explicitly re-attach each data provider to the universe.

Tim Janssen (BOB member since 2004-09-10)

4

Does this still happen after refresh of the data, after doing as you have explained, below?

Mak 1 :uk: (BOB member since 2005-01-06)

5

Yes, it still does happen after refresh of data.

In repository X I created a Web Intelligence report consisting of an object using @variable(‘UNVID’). Refreshing it in repository X InfoView it returns the repository X Universe ID.
With the Import Wizard I exported the report to a BIAR-file and imported it in repository Y. Refreshing it in repository Y InfoView it still returns the repository X Universe ID.
Only after having manually edited the report data provider by having it re-pointed to the same universe-name, repository Y Universe ID is shown.

Tim Janssen (BOB member since 2004-09-10)

6

Very strange. It still seems to me that the queries have become unbound in some way. As I said the CUIDs should persist from environment to environment, ie. they should be the same.

Mak 1 :uk: (BOB member since 2005-01-06)