BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: Upcoming Events: PGHBOUG: Aug 23.

Document a BO Universe in Excel
5 members found this topic helpful
Goto page 1, 2, 3 ... 12, 13, 14  Next
 
Search this topic... | Search BOB's Downloads... | Search Box
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Author Message
André Lützkendorf
Senior Member
Senior Member



Joined: 28 Sep 2009

Posts: 54


flag
PostPosted: Mon Sep 28, 2009 1:29 pm 
Post subject: Document a BO Universe in Excel

Author: André Lützkendorf
Platform: Windows
Version: GetSetUniverse 3.5.25
Code: VBA code within the uploaded xls file
Author notes:

1. What can you do with the tool?
Presentation of all universe objects and properties
This includes
- general universe information (defined in parameters)
- all object properties
- object dependencies (lineage/ impact analysis)
(which table will be used by which object,
which objects will be used by which objects with @functions)
- contexts
- hierarchies
- joins
- incombatibilities
redefine objects
After loading all objects and their properties into excel you can change the properties and write the data back into the universe.
Redefinable are the
- name of the object
- description of the object
- select of the object (excluding conditions)
- where of the object
All actions will be logged.

3. versions/ demo output in excel, webi
The uploadable version in this post requires BO XI 2.
Upgrades for BO XI 3 and demo outputs are available here: http://www.luetzkendorf.eu/download.html

4. manual
A brief manual is available here: http://www.luetzkendorf.eu/download.html



GetSetUniverse_3_5_25.xls
 Description:

Download
 Filename:  GetSetUniverse_3_5_25.xls
 Filesize:  708.5 KB
 Downloaded:  15484 Time(s)



Last edited by André Lützkendorf on Tue May 03, 2011 2:33 pm, edited 6 times in total
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19184
Location: Bratislava


flag
PostPosted: Thu Dec 17, 2009 1:06 pm 
Post subject: Re: Document a BO Universe in Excel

Approved and moved to BOB's Download section.

Thanks Andre for sharing.

_________________
BO: BI 4.0, 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win, Linux and AIX servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
SST
Forum Member
Forum Member



Joined: 25 Mar 2008

Posts: 18


flag
PostPosted: Wed Dec 23, 2009 10:28 am 
Post subject: Re: Document a BO Universe in Excel

Absolutely fantastic utility. Thanks for sharing.
Back to top
patneel
Principal Member
Principal Member



Joined: 02 Nov 2006
ASUG Icon
Posts: 265
Location: India,Pune


flag
PostPosted: Wed Jan 20, 2010 5:16 am 
Post subject: Re: Document a BO Universe in Excel

Hi Andre,

Please share the manual which is available in English.
Also eagerly waiting for the next version which is going to be compatible with BO XI3.0

Thanks in Advance

_________________
BO XI R2,BO XI3.0,Crystal Reports,Crystal Xcelsius
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19184
Location: Bratislava


flag
PostPosted: Wed Jan 20, 2010 8:44 am 
Post subject: Re: Document a BO Universe in Excel

patneel wrote:
Please share the manual which is available in English.
It's there, on Andre's webpage:
http://www.luetzkendorf.eu/download/getsetuniverse/3_5_25/en_GetSetUniverse_3_5_25.pdf

_________________
BO: BI 4.0, 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win, Linux and AIX servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
beisss
Forum Member
Forum Member



Joined: 22 Jan 2010

Posts: 1



PostPosted: Fri Jan 22, 2010 3:26 am 
Post subject: Re: Document a BO Universe in Excel

Hi

I try to use the excel file to open GetSetUniverse.xls and compile an error. I have all the libraries that you indicate.

Could you send me a guide in English on how to load in excel file my universe?.

I'm a little lost, do not understand how to use it. Thank you very much

Regards
Back to top
André Lützkendorf
Senior Member
Senior Member



Joined: 28 Sep 2009

Posts: 54


flag
PostPosted: Fri Jan 22, 2010 1:34 pm 
Post subject: Re: Document a BO Universe in Excel

Can you please post the exact error message?
The point of code, at which the error occurs, should be written in the message. The info helps to understand your problem.

In general you can use the tool with following prerequisites:
- installation of excel containing vba
- installation of SAP BO XI Designer
- the BOXI right to open the universe with the designer (with the exception of universes you can open in offline mode)

By opening GetSetUniverse you will get an additional menu item. You can select then e.g. LoadUniverse to load the universe properties into Excel. (The posts above contains the link to the manual with a more detailed guidance.)

Normaly thats it icon_smile.gif
Back to top
x139603
Forum Member
Forum Member



Joined: 13 Oct 2009

Posts: 6



PostPosted: Wed Jan 27, 2010 12:42 pm 
Post subject: Re: Document a BO Universe in Excel

Hi Andre,

I've updated your macro for 11.5 as indicated, although it also shows that "Crystal Enterprise qaaws PlugIn 12.0" as missing and I don't have a version for 11.5. If this is absolutely required, where can I find it? The installation disk?

Also, I'm trying to document a universe that I've imported & saved to my local harddrive from a central repository. Given that the universe I'm trying to document is saved on my computer I tried to use my computer as the CMS, but I get an error that there is no CMS running. I don't have access to the main CMS due to company security and I'm pretty sure they won't grant me access. What can I do to use your macro without access to the main CMS because so far it's the only one that documents incompatibilities, which is what I need.

Thanks!!!

BO Newbie
Back to top
André Lützkendorf
Senior Member
Senior Member



Joined: 28 Sep 2009

Posts: 54


flag
PostPosted: Thu Jan 28, 2010 2:47 am 
Post subject: Re: Document a BO Universe in Excel

x139603 wrote:
it also shows that "Crystal Enterprise qaaws PlugIn 12.0" as missing...I tried to use my computer as the CMS, but I get an error that there is no CMS running.


I am a little bit lost ... neither "Crystal Enterprise qaaws PlugIn 12.0" nor a local CMS is required for executing the code.

You need a local installation of Excel including VBA and a local installation of SAP Business Objects Designer.

If you want to use a universe outside the CMS, you have to open the universe in Designer (with an Enterprise authentification) first. Then define a public connection and save the universe local with the option "FOR all users". The saved universe can be used then in Offline mode.

All steps to extract the universe in Excel (using GetSetUniverse) are described in the manual below.

HTH
Back to top
steve1979
Senior Member
Senior Member



Joined: 16 Nov 2005

Posts: 77



PostPosted: Thu Jan 28, 2010 8:51 am 
Post subject: Re: Document a BO Universe in Excel

Thanks for this. very usefull.
I noticed couple of things.
1)when I run this macro it takes lot of time to refresh
2)after refresh it only creates two tabs info_ and objects_
so lot of other tabs are missing.. according to the manual
it should list all the LOVs,tables,joins etc...

please can you help... Thanks in advance.
Back to top
x139603
Forum Member
Forum Member



Joined: 13 Oct 2009

Posts: 6



PostPosted: Thu Jan 28, 2010 11:32 am 
Post subject: Re: Document a BO Universe in Excel

Andre,

I apologize, I was looking at the wrong documenter. However, I am having the same issue where I only get two tabs of information and there is no additional menu when I open the file.

Thanks!
Back to top
André Lützkendorf
Senior Member
Senior Member



Joined: 28 Sep 2009

Posts: 54


flag
PostPosted: Thu Jan 28, 2010 2:40 pm 
Post subject: Re: Document a BO Universe in Excel

steve1979 wrote:
1)when I run this macro it takes lot of time to refresh

For this case I recommend to load the universe in offline mode.
How this works is described in one of the posts above.

steve1979 wrote:
2)after refresh it only creates two tabs info_ and objects_ so lot of other tabs are missing.. according to the manual
it should list all the LOVs,tables,joins etc...

x139603 wrote:
However, I am having the same issue where I only get two tabs of information and there is no additional menu when I open the file.


The two tabs will be the result of executing the menu item Load Universe. The loaded data can modified then and written back to the universe. Please read the manual carefully for doing this.

As you want to see all universe data in Excel you have to execute the menu item Versioning Universe >> xls. The manual will guide you here too.
Back to top
André Lützkendorf
Senior Member
Senior Member



Joined: 28 Sep 2009

Posts: 54


flag
PostPosted: Mon Feb 08, 2010 3:42 pm 
Post subject: New version of GetSetUniverse BO XI 3

So where is the upload button?
Seemingly I do not have the possibilty to upload the document.

So you will find the next version here
http://www.luetzkendorf.eu/download.html

The version 3.6.01 requires BO XI 3.
Back to top
André Lützkendorf
Senior Member
Senior Member



Joined: 28 Sep 2009

Posts: 54


flag
PostPosted: Sat Feb 13, 2010 2:10 am 
Post subject: Document a BO Universe in Excel/ new version for BOXI 3

attached the new version for BOXI 3.


eFashion_v125_20100207_181430.xls
 Description:
Example of documented universe eFashion

Download
 Filename:  eFashion_v125_20100207_181430.xls
 Filesize:  95.5 KB
 Downloaded:  3704 Time(s)


GetSetUniverse_3_6_01.xls
 Description:
Version 3.6.01 for BOXI 3

Download
 Filename:  GetSetUniverse_3_6_01.xls
 Filesize:  632 KB
 Downloaded:  6737 Time(s)



Last edited by André Lützkendorf on Sun Feb 14, 2010 5:01 am, edited 1 time in total
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19184
Location: Bratislava


flag
PostPosted: Sat Feb 13, 2010 4:16 am 
Post subject: Re: Document a BO Universe in Excel/ new vesrion for BOXI 3

André Lützkendorf wrote:
Is it possible to move the post to the same topic?
Your new post from the BOB's Upload section was merged into this topic.
_________________
BO: BI 4.0, 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win, Linux and AIX servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Page 1 of 14 All times are GMT - 5 Hours
Goto page 1, 2, 3 ... 12, 13, 14  Next
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0415 seconds using 19 queries. (SQL 0.0063 Parse 0.0027 Other 0.0324)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo