Automate deletion of LOV in a class in a universe

building semantic layer
1

Hello All,

We have tables with large number of columns. Some of the tables have about 450 columns. When I create a class from these tables, LOV automatically gets created. Is there an easy way to take the option out for LOV? I have to open the properties of each object and manually delete LOV which is very tedious.

Thanks.
Purnima

prnmsharma :us: (BOB member since 2008-03-18)

2

UNV or UNX? If you’re on Designer (versus IDT) then you can accomplish this with VBA. I posted some sample code a long time ago that does this. See this topic for details.

Dave Rathbun :us: (BOB member since 2002-06-06)

3

How do you establish the reference to the proper libraries? Can you please send me step by step instructions please?

Thanks.
Purnima

prnmsharma :us: (BOB member since 2008-03-18)

4

Hi,

I was able to associate with the right library. However, it opened the universe in BI 4.0. I believe the code is written for BI 4.0. Can you please send me the code for 3.0 please?

Thanks.
Purnima

prnmsharma :us: (BOB member since 2008-03-18)

5

Did you see the date on the original topic? It’s from 2010. :slight_smile: It was written for XI 3. If you have both installed on your system, you need to pick the right version of the libraries. BI 4 is going to reference version 14 of the object library. XI 3 is going to reference version 12, or at least that’s how it looks on my computer.

Dave Rathbun :us: (BOB member since 2002-06-06)

6

I did try. When I check reference version 12, it gives me an error. However, if I uncheck version 12 and check version 14 it works fine but opens UDT.

Thanks.
Purnima

prnmsharma :us: (BOB member since 2008-03-18)

7

Ah, got it. That’s where the confusion is. There are two methods for logging in. In the comments for the code it says they’re for different versions. Remove the current one and use the other and see if that works.

Dave Rathbun :us: (BOB member since 2002-06-06)

8

It gives compile error: user_defined type not found.

Thanks.
Purnima

prnmsharma :us: (BOB member since 2008-03-18)

9

I posted a screen shot of my library references. I used the code as-is and it worked fine. The “LoginAs” was apparently for XI R2 because when I tried to use it with 3.1 it said it was depreciated. When I went back to the LoginDialog it worked fine and started Designer from XI 3.1 which I have installed on my system, along with BI 4.
VBA_References.png

Dave Rathbun :us: (BOB member since 2002-06-06)

10

It works fine. I don’t know for some strange reason I saw two instances of the library fro 12.0. It worked with the second one but not with the first one. Thank you so very much. You saved me and my group lot of time. I truly appreciate your help in this regard.

Thanks.
Purnima

prnmsharma :us: (BOB member since 2008-03-18)