BusinessObjects Board

Create Class and Objects Automatically

downloads
#6

Welcome to B:bob:B!

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 :us: (BOB member since 2002-09-19)

#7

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)

#8

This maybe?

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

#9

Perfect, this is exactly what I am looking for.

thanks a million

Gabe

boarch (BOB member since 2008-04-04)

#10

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

meutte :belgium: (BOB member since 2007-12-06)

#11

ok, found it in another post:

meutte :belgium: (BOB member since 2007-12-06)

#12

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 :uk: (BOB member since 2007-10-05)

#13

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 :us: (BOB member since 2005-11-02)

#14

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 :us: (BOB member since 2002-09-19)

#15

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 :us: (BOB member since 2005-04-18)

#16

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 :us: (BOB member since 2002-09-19)

#17

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 :us: (BOB member since 2005-04-18)

#18

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 :wink: )

(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 :fr: (BOB member since 2008-09-29)

#19

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 :us: (BOB member since 2008-02-12)

#20

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)

#21

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 :india: (BOB member since 2007-01-09)

#22

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 :us: (BOB member since 2002-09-19)

#23

Thanks for your help.

I have resolved the problem; it is a Vista issue :hb:

Bottom-line, I have to run Excel as administrator.

For other folks who may come after and have similar problems, here are the specific steps I took to make it work.
[list]

  1. Open up Universe Designer, and open the desired Universe.
  2. If you have a secured connection, change the connection to a shared connection (I had to create a new one).
  3. Save the universe locally, being sure to check the Save for All Users box.
  4. I don’t the get the ‘Run as Administrator’ right-click option when I hover over the file on the destop. Just run the Excel.exe as administrator
    and open the .xls file.
    [/list]
    The first three steps were to resolve the “The Universe belongs to another CMS
” error. I was able to successfully execute the GetInfo macro after taking these steps.

Moira

moiram (BOB member since 2009-02-20)

#24

Hi,
Could anyone help me how to run this macro for the CITRX users.

Thanks,
Caitu

Caitanya.Candra (BOB member since 2008-08-04)

#25

Has anyone tried to use this to create a universe in 3.1? We will be creating a couple new universes for a new TMS installation and I wondered if this has been tested in 3.1?

We have not yet completed our upgrade to 3.1, so I am trying to do some “forward thinking” for when the new TMS universe will be required and the 3.1 upgrade is complete.

thanks for any feedback

Roland

REB01 :us: (BOB member since 2004-11-29)