Create Class and Objects Automatically

[system]

@maverickee

Do you have a macro to create the objects and classes in BO5.1
Universe

You should be able to use the XI version as a starting point. Go to the VB Editor and under Tools, References change to the Designer 5 library. The only code change should be to use .LoginAs instead of .LogonDialog. Give it a try.

---

Dwayne Hoffpauir (BOB member since 2002-09-19)

[system]

Hi Dwayne,

You are fantastic It worked Thanks for your reply

Regards,
Santhosh

---

maverickee (BOB member since 2008-01-31)

[system]

Is this tool able to add classes and objects to the existing universe? How?

---

snorb9396 (BOB member since 2008-03-10)

[system]

Welcome to B:bob:B!

@snorb9396

Is this tool able to add classes and objects to the existing universe? How?

The workflow says to create a blank universe first, but that’s not necessary. The code will prompt you to open a universe, so you can certainly pick a “non-blank” existing universe if you like. As long as the classes / objects you are adding are not duplicates, it should work fine.

---

Dwayne Hoffpauir (BOB member since 2002-09-19)

[system]

This tool works like a gem but it doesn’t solve my problem 100%.

I want to import column comments from database to BO Object description.
I can create a txt/xls/csv file with table,column name and column comments
and somehow I need to import that to Class.Object description.

I have more than 140 tables in my mart and loading about 3000 definitions/descriptions would be great help.

I am sure I am not the first person who has this type of need,
if anyone has any solution for this situation, please let me know

thanks
Gabe D.

---

boarch (BOB member since 2008-04-04)

[system]

This maybe?

Mass update to object names / descriptions

Update 23-Oct-2009: Another version that can change CLASS names and descriptions can be found [url=http://www.forumtopics.com/busobj/viewtopic.php?p=666079#666079]here[/url] later in this thread. Author: [url=http://www.forumtopics.com/busobj/profile.php?mode=viewprofile&u=1343]Dwayne Hoffpauir, EDS Corporation[/url] Further discussion on this utility should take place in [url=http://www.forumtopics.com/busobj/viewtopic.php?t=20992]this topic[/url]. Author Notes: [quote:d8ce665e88]This utili…

---

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

[system]

Perfect, this is exactly what I am looking for.

thanks a million

Gabe

---

boarch (BOB member since 2008-04-04)

[system]

awesome tool !
Is there anything to do the opposite as well?
Extract from universe all objects in an excel?

---

meutte (BOB member since 2007-12-06)

[system]

ok, found it in another post:

Mass update to object names / descriptions

Update 23-Oct-2009: Another version that can change CLASS names and descriptions can be found here later in this thread. Author: Dwayne Hoffpauir, EDS Corporation Further discussion on this utility should take place in this topic. Author Notes: Option Explicit 'require variables to be declared before being used Dim DesignerApp As Designer.Application Dim Univ As Designer.Universe Dim Wksht As Excel.Worksheet Sub GetInfo() Set DesignerApp = New Designer.Application …

---

meutte (BOB member since 2007-12-06)

[system]

I am trying to use the tool :

But I don’t know how it works. I followed the procedure given , but classes and objects are not created in universe.

Can anyone please tell me how to use this tool. I am using BO XI R2.

Thanks
Aniket

---

aniketp (BOB member since 2007-10-05)

[system]

Hi,
Can this tool be modified to function as follows:
It should look into a particular column of a specific table and if the column is null, then it should hide the related object in the universe and if it not null then it should add \ unhide the object in the universe.

Please let me know if this can be achieved or not. I am using BO XI R2. Also let me know to achieve this what are the required components that i need to have on my server like BO SDK etc…

Thanks,
Raman

---

romanb4u (BOB member since 2005-11-02)

[system]

@romanb4u

Can this tool be modified to function as follows:
It should look into a particular column of a specific table and if the column is null, then it should hide the related object in the universe and if it not null then it should add \ unhide the object in the universe.

Please let me know if this can be achieved or not. I am using BO XI R2. Also let me know to achieve this what are the required components that i need to have on my server like BO SDK etc…

This tool gets its information from an Excel spreadsheet. It could certainly decide whether or not to hide an object based on one of the spreadsheet columns. If you are trying to get the information from an actual database table, that is possible (with ADO, for example), but beyond the scope of this utility.

As far as required software, nothing is needed on the server side. The Designer SDK is intended as client-side only.

---

Dwayne Hoffpauir (BOB member since 2002-09-19)

[system]

Hi Dwayne,

In excel spread sheet i have all the information of universe, For example in one Tab has DB Connection information, 2nd tab has Tables Information, 3 Tab has Joins Information, 4 th Tab has classes and Objects information, 5th Tab has Context and Hierarchies information.

Use this Spread sheet Information can we generate a Universe using VB Macro. Do you have any code similarly like that. If you have please share it with me.

In my present situation this kind of VB Macro is very use full.

Please help me any one…

Thank in advance

---

Vallabhaneni (BOB member since 2005-04-18)

[system]

@Vallabhaneni

Use this Spread sheet Information can we generate a Universe using VB Macro. Do you have any code similarly like that. If you have please share it with me.

It is certainly possible, but I’ve never developed anything exactly like that. In my opinion, building a universe is not something that should be “black boxed” like that. It is way too important to understand the data model in detail, build in terms of user requirements, etc. My tools tend to focus on easing maintenance and documentation, but not creation, of universes.

---

Dwayne Hoffpauir (BOB member since 2002-09-19)

[system]

Hi Dwayne

Thanks for your reply. That’s right. I am migrating reports from Crystol to Business Objects. Here we need to build a universe also. My approach is I will take Sql Query from Crystol a report. I am planning to write a macro in Excel separate the SQL like select, where and From tables and using this Excel sheet information generate a Universe. That’s the Plan.

yes, some of the problems like traps those we need to do manually.

any one has code some thing like this please help me on this or guide me where we will get BO VB SDK Help.

Thanks in advance.

---

Vallabhaneni (BOB member since 2005-04-18)

[system]

Hi,

thank you, it’s exactly what I need but I have a problem to run your macro (office 2007 / windows Vista).
On the line “Set DesignerApp = New Designer.Application” I have this message (in french because I’m french )

Erreur d’exécution 430 :
La classe ne gère pas Automation ou l’interface attendue

(translate in english => “Error 430, The classe don’t manage Automation or …”)

“BusinessObjects 11.5 Object Library” and “BusinessObjects Designer 11.5 Object Library” are used.

How to resolve this error ?
Thank you
JBR

PS: sorry for my english, i’m a stupid french 8)

EDIT : I resolved my problem to install BO on windows XP

---

JBR (BOB member since 2008-09-29)

[system]

This tool is fantastic.

Anyone know how it could be modified to do the same thing, but with filter objects instead of dimension objects?

Thanks,
Drew

---

CSGDrew (BOB member since 2008-02-12)

[system]

I’m trying to use the Universe - Object Names & Descriptions.xls macros. I get the run time ‘430’ error on my machine (Vista + Excel 2003 SP3) - but a colleague is able to get past that on his machine. When we run GetInfo, we get the following error:

The Universe belongs to another CMS. You cannot open it unless you are connected to the same CMS from which it was imported.

As far as I know we only have one CMS.

Any hints?

Thanks,

Moira

---

moiram (BOB member since 2009-02-20)

[system]

Hi Moiram,
This is the error thrown when you log in to a CMS and open a Universe that was not present in CMS. This error is thrown because when this tool tries to look into repository it is not able to get any information for this universe.

If you colleague is using same repository as you are then it might be Vista issue but i am not sure. I would like other BO gurus to comment on this.

Thanks
Gaurav Sethi

---

Gaurav_Sethi (BOB member since 2007-01-09)

[system]

@moiram

The Universe belongs to another CMS. You cannot open it unless you are connected to the same CMS from which it was imported.

Try opening the universe manually with Designer. If you get the same message (which I suspect you will), then it is not a problem with the utility / Vista / whatever.

---

Dwayne Hoffpauir (BOB member since 2002-09-19)