How do you map an .lov file to its related Object.

[Former Member]

Hi

I need to find out which of our .lov files are affected by a change to one of our database fields (BU_CD).

I can find the .lov files that reference the BU_CD field by running a simple search in windows explorer, the issue I have is trying to find out which Objects in the Universe each of the .lov files are related to.

For example how would I find out that lov file "1ys.lov" is the lov for the Object "Client Name" without manually searching through every Object in the Universe?

Thanks

Paul

[PPaolo · Accepted solution]

Hello,

unfortunately there is no interface to show a list of all objects and their associated LOVs. You should use the Universe Designer COM SDK to build a tool giving the list.

At this link:

http://devlibrary.businessobjects.com/BusinessObjectsXIR2SP2/en/devsuite.htm

you can browse to the Universe Designer and Desktop Intelligence SDKs / Samples / Universe Designer Universe Info.

You will find a small application which explains how to use the SDK to get Universe information.

You can easily modify it and add a few lines to retrieve for each Object its ListOfValues and then get its ListOfValues.Name.

Hope that it helps.

Best regards

PPaolo

[Former Member · Accepted solution]

Great thanks for the reply, thats put me on the right track!