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
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.)
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.
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.
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…
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.
For this case I recommend to load the universe in offline mode.
How this works is described in one of the posts above.
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.
[quote:ca07d56f2c=“André Lützkendorf”]Is it possible to move the post to the same topic?
[/quote]
Your new post from the BOB’s Upload section was merged into this topic.
In the first place, thank you for uploading such a nice tool!
However we have some problem during the write action in the file. I updated de VBA code of the SetUniverse procedure.
Before the last error handling, I rearranged the code into this code:
oXls.Interactive = True
Select Case oXls.International(xlCountryCode)
Case 49 'german
MsgBox "Die Änderungen wurden protokolliert in:" & vbCrLf & _
sPath & "\" & sLogName & ".txt", vbInformation, Title:=vbVersion
Case Else ' english
MsgBox "All changes are logged into file :" & vbCrLf & _
sPath & "\" & sLogName & ".txt", vbInformation, Title:=vbVersion
End Select
Set oShObjects = Nothing
Set oShCopy = Nothing
Set oShInfo = Nothing
Close #1
Set oXls = Nothing
Exit Sub
Instead of this code:
Set oShObjects = Nothing
Set oShCopy = Nothing
Set oShInfo = Nothing
Close #1
oXls.Interactive = True
Set oXls = Nothing
Select Case oXls.International(xlCountryCode)
Case 49 'german
MsgBox "Die Änderungen wurden protokolliert in:" & vbCrLf & _
sPath & "\" & sLogName & ".txt", vbInformation, Title:=vbVersion
Case Else ' english
MsgBox "All changes are logged into file :" & vbCrLf & _
sPath & "\" & sLogName & ".txt", vbInformation, Title:=vbVersion
End Select
Exit Sub
This made work again. Hopefully you can implement this in your file and upload it again, so others can benefit from it.
Hi, I am facing Microsoft VB Error as “Compile Error: User-Defined type not defined” and the line is stopping in VB code at: “Private Sub GetUniverseClasses(oMyUnv As designer.Universe)”.
I am using Excel 2003 and BOXI R2. and I have all the libraries as you mentioned above.
(BOB member since 2009-09-28)
(BOB member since 2003-11-27)
(BOB member since 2008-03-25)
(BOB member since 2006-11-02)
(BOB member since 2010-02-17)