Universe Documenter

The tool exports BusinessObjects universe metadata into Excel file including information about objects, predefined conditions, tables, joins, contexts, index awareness and incompatibilities.

Requirements

  • Microsoft .Net Framework 3.5
  • BusinessObjects XI 3.1 SP3
  • Microsoft Office 2007 or OpenOffice 3.0

Installation

The tool is provided and supported by biclever.com.

The tool is build using Express version of Visual Studio, therefore it does not have a normal installer. Maybe I will do something about this later.

How to use

  • Start the tool  UnvDoc.exe as Administrator
  • Login to BOE system. If you cancel login, the tool will run in standalone mode.
  • Open universes from the disk or import from CMS.
  • Select output options. Do not check “List of values details” unless you need it – extraction of this information is very slow.
  • Save result to a specific file or click Quick View to get the result in Excel. ( Example of the result)

More Information

How to diff universes using Universe Documenter

Best practices of using Universe Documenter

List of output Excel columns

Objects
Universe Name
Universe Full Name
Class Path
Class Id
Class Name
Object Id
Object Name
Object Type
Object Format
Object Description
Object Show
Object Select
Object Where
Tables
Object Qualification
Measure Projection
Associated Object
Object Has LoV
LoV Allow Edit
LoV Automatic Refresh
LoV Hierarchical
LoV Export With Universe
LoV Delegate Search
LoV Name
LoV Is Custom SQL
LoV SQL
Can Be Used In Condition
Can Be Used Result
Can Be Used Sort
Security Access Level
Database Format

Classes
Universe Name
Universe Full Name
Class Path
Class Id
Class Name
Class Description
Class Show
Parent Class

Conditions
Universe Name
Universe Full Name
Class Path
Class Id
Class Name
Condition Id
Condition Name
Condition Description
Condition Show
Condition Where
Tables
Mandatory Condition
Apply On LoV

Hierarchies
Universe Name
Universe Full Name
Hierarcy Id
Hierarchy Name
Object Id
Object Name

Tables
Universe Name
Universe Full Name
Table Id
Table Name
Alias
Is Derived
Derived SQL

Table Columns
Universe Name
Universe Full Name
Table Id
Table Name
Column Name

Joins
Universe Name
Universe Full Name
Join Id
Left Table
Right Table
Outer Join
Short Cut
Expression

Contexts
Universe Name
Universe Full Name
Context Name
Context Description
Join Id
Left Table
Right Table

Index Awareness
Universe Name
Universe Full Name
Class Path
Class Name
Object Name
Type
Select
Where
Enable

Incompatibilities
Universe Name
Universe Full Name
Table
Type
Object Id
Object Name

147 thoughts on “Universe Documenter”

  1. Ashutosh

    Do something about that dialogue box, when no data is retrieved. U wont expect us to sit for hours just to click on OK. Atleast there should be an option like “Ok to all”

    Like

      1. Ashwini Kumar

        Hi,

        It is a great tool. Do you have similar tool developed for IDT (Information Design Tool)/BO XI 4?

        Thanks,

        Ashwini

        Like

      3. Piyush V Dubey

        Hi Dmytro,

        Excellent tool and excellent work. I was strugling with Auto-Documentor of BO. Your tool gave me respite. Thanks a million!

        A suggestion, if possible add the Universe image then your tool is a complete tool. I did this manually, added the image from PDF file.

        Thanks & Regards

        Piyush

        Like

    2. SS

      This is a great tool! If I am not asking for more, is there a way to determine the date when the object was created?

      Like

  2. Raj

    Awesome Tool! It must have taken a lot of effort to code this yourself. I tried it on multiple universes – even complex ones (with over 6k objects) and never did it fail. The most important part is that the tool exposes universe object ids and they are damn useful in troubleshooting promotion related issues.

    Such a small footprint but so many features. I couldn’t have asked for more!

    Kudos Dmytro! UnvDoc rocks!!

    Like

  3. Tracy

    This is so great! Hopefully this is an easy question, is there a way to distinguish if an object is hidden in the universe?

    Thanks for sharing this!

    Like

    1. Vamsi Ch

      Hi,

      COM SDK is not released for 4.0 yet for UNX Universes ( IDT based Universes ) but you can try using above code for UNV ( Universe Designer ).

      Moreover IDT is based on Java but UDT is on VC++/VB so COM SDK works only on UDT.

      Vamsi

      Like

  5. Marco R

    I am not able to start UnvDoc on a Win7 and WinXp. On Win 7 I get the message that the program stopped working:
    Description:
    Stopped working

    Problem signature:
    Problem Event Name: CLR20r3
    Problem Signature 01: unvdoc.exe
    Problem Signature 02: 1.0.0.0
    Problem Signature 03: 50324cf2
    Problem Signature 04: UnvDoc
    Problem Signature 05: 1.0.0.0
    Problem Signature 06: 50324cf2
    Problem Signature 07: 2e
    Problem Signature 08: 0
    Problem Signature 09: PSZQOADHX1U5ZAHBHOHGHLDGIY4QIXHX
    OS Version: 6.1.7601.2.1.0.256.48
    Locale ID: 1033

    I am using .Net 4, Office 2007 and BOBJ 4.0 (UDT – designer.exe). I am able to use the documentation tools from Forumtopics based on Universe SDK on Excel, but UnvDoc would provide me a lot more useful information.

    Am I missing something other than unzip and run the program?
    thanks,

    Marco R.

    Like

    1. dmytro Post author

      There is no such property. The class path is build when the recursive algorithm traverses through the class structure.

      E.g. the function printing the class structure can look like this:

      static void PrintClasses(Classes classes, String path)
{
  foreach (Class theclass in classes)
  {
    String path1 = path + "/" + theclass.Name;
    Console.WriteLine(
      path1
      + " contains " + theclass.Objects.Count
      + " objects and "
      + theclass.PredefinedConditions.Count
      + " conditions");
    PrintClasses(theclass.Classes, path1);
  }
}

      Like

      1. MarkM

        Thanks Dmytro!! I didn’t think there was such property, as I was looking all over for it!! Thanks for posting the code, I’ll try to implement it into my Excel VBA macro and see if I get the same results. Thanks again, you’ve been very helpful!!

        Mark M.

        Like

  7. DCF

    Greate tool !!!
    Very usefull for documentation and testing.
    It is possible to extract business layer and allocated InfoObjects?

    Thanks and best regards

    DCF

    Like

  8. wasy

    Thank you very much for this great tool.

    I was wondering, if it is possible to add few more tabs to dispaly classes and columns as well.

    Columns:
    Table Name, Column Name, Column Type.

    Classes:
    Class Name, Parent Class, Class Description.

    Your consideration will be highly appreciated.

    Thanks and best regards,
    Wasy.

    Like

      3. wasy

        Hi dmytro,

        It’s awesome, exactly what i was looking for and works like charm.

        Really really appreciate your work and efforts in this regard.

        Greatful.
        Thanks,

        Wasy.

        Like

      4. wasy

        Hi dymtro,

        this tool works perfectly for .unv (extension), i created my first .unx and was not able to find it in the list for extraction.

        It would be great if you can have a look to include the .unx (information desing tool) universes as well.

        Really really apprecite.

        Thanks,
        -Wasy

        Like

      5. dmytro Post author

        There is no public SDK for semantic layer for BO at the moment.. so we cannot get access to that information.

        Like

      6. Bindu

        Hi,

        All our universes are .unx files. Is there any help I can get to run the documentor for them and get the details on to a spreadsheet. I really appreciate any help on this.

        Thanks,
        Bindu.

        Like

  9. Nandini

    HI,
    i am trying to use this tool but i am getting an error message as unhandled exception has occured in your application, if you click on continue , the appliocation will ignore this error and attempt tp continue.if you click QUIT , THE APPLICATION WILL CLOSE IMMEDIATELY.

    Unable to cast COM objectof type’Designer.ApplicationClass’to interfacetype ‘Designer.|Application. this operation failed because the query interface call on the com component for the interface with ||D ‘{B88BF663-03EE-4140-AA7e-AB4bfdb5c28e}’failed due to followinf error :NO such interafce supported(Exception from HRESULT:)x8—4002(E-NOININTEFACE)).

    Like

    1. Olivier

      Hello,

      I have the same error. I’m running the tool under win7 32b, with .NET 4.0. and BO BI4.
      Any suggestion ?
      Thanks in advance.

      Like

      1. dmytro Post author

        What is the SP and FP of BI4.0 you are using?

        Are you running the tool from the machine with the client tools installed? I.e. Universe Designer Tool is installed?

        Thanks

        Like

      2. Maria

        Hi Dmytro,

        I am getting the same error above. I am on BO 4.0 SP4 and I am running the tool on the server where Designer is installed.

        Any suggestions?

        Thanks, Maria

        Like

      3. dmytro Post author

        Do you have Microsoft NET Framework 3.5 or higher?

        (In windows 7, this can be checked in Control Panel\Programs\Programs and Features)

        Like

  10. Priya

    Hi Everyone,

    I am very new to BO world. I need help in understanding whether i would be able to retrieve the Columns:Table Name, Column Name, Column Type and other drill down information of universe using BO Java SDK ? I could see that there are lot many tools to do that using other SDKs. Please help me on this asap.

    Eg: Universe Name Class Name Object Name Visible Object Type Data Type Description

    Like

  11. Sameer

    I wish to identify the .lov file associated to all objects in the Universe. I do not need the SQL for LOV, but the LOV list name. I tried checking the option “LoV SQL”, but it rans for very long time even for a small test universe which has 38 objects. Please guide.

    Like

  12. Sameer

    Hi, I believe option “LoV SQL” will fetch the List name(.lov file) & the SQL to fetch the LOV. The generatiion of SQL is a time taking task. I am interested only in the list name. Is there any way i can get only the list name corresponding to an object.

    Like

  13. Elisabeth

    This looks great and just what I have been looking for (we had a tool that worked on 6.5 and earlier). We are currently on BOXI r2, but I will have to upgrade to 3.1 to use this, right? Can’t wait to start using it! Thank you!

    Like

      1. Elisabeth

        Previously (when we used BO 6.5.1 and earlier), before each product release, we used tool that converted our main (Oracle) universe to a similar SQL Server universe. The tool used 4 universes as “parameters”:
        – the “old” (previous release of the) Oracle universe (1)
        – the old SQL Server universe (2)
        – the new (ready for release) Oracle universe (3)
        – the universe that was going to become the new SQL Server universe (4).
        The new SQL universe (4) was originally just a blueprint of the new Oracle universe (3). The tool looked at the differences between the old Oracle universe (1) and the old SQL Server universe (2) and implemented these differences on the new SQL Server universe (4)(blueprint of new Oracle universe). This meant that only the changes made from the previous (1) to the current (3) release in the Oracle universe needed to be converted to SQL Server.
        We then had a handful of scripts that we executed on the repository to convert as much of the syntax as possible automatically. The last phase of the job would be to manually convert the remaining syntax that was not possible to do via scripts.
        Our development is now being done in BO XI. As there is no longer a repository, our conversion/migration tool is no longer usable.
        So I’m hoping your tool can help us out a bit with this. What I really want to do is create a universe that can be used on both platforms (ansi92), but have to look more into that!

        Like

      2. dmytro Post author

        We are using BOE XI 3.1 and has similar approach. We develop main version for Oracle and we convert the universes to SQL Server using an SDK tool for release.

        I do not quite understand why the scripts that you used for R2 are not applicable to XI 3.x. How do they access SQL in the universe?

        Like

      3. Elisabeth

        The approach was used in 6.5, not on the current BOXI. So we are now developing in two streams while we are trying to figure out a better way. Hopefully by using ANSI92 we can use the same universe on both platforms? Any thoughts on that? What sdk tool are you using? An in-house tool?

        Like

      4. dmytro Post author

        ANSI92 helps significantly because when functions are not used, SQL modifications are not needed (the only difference I know is that SQLServer requires named alias for subquery while it is optional in Oracle).

        The main difficulty is to rewrite expressions in SQL that use functions or string concatenations. We are using an in-house tool for this.

        Like

      5. dmytro Post author

        BTW it is also possible to use JDBC escape syntax for JDBC connection. E.g. {fn year(ENTRY.THEDATE)} and {fn concat(ENTRY.NUMBER, ENTRY.NAME)} will work both for Oracle and SQL Server.

        Like

  14. pavan

    Hi dmytro,

    I have one specific requirement on custom lov’s. I need to search all our universe custom LOV files and need to modify the definition where some objects need to be removed from the custom SQL.

    I tried your utility but in the documentation generated i cannot see any information related to the custom LOV’s . the other properties of LOV are documented. But the features like custom LOV and custom SQL are not documented.

    can you please have a look into this.

    Thanks.
    Pavan

    Like

    1. dmytro Post author

      Hi Pavan
      I have added field “Is Custom SQL”
      You can get the field and the SQL of LoV checking the option “List of values details”.

      Like

  15. Elisabeth

    Hi again dmytro,

    I’m about to start using your tool now, and was wondering something. We used to have a universe built on the repository when that still existed. That was very useful to have! So now I was thinking of using the excel file generated to create a script to build a database schema/insert to tables and then build a universe on top of that. Any experience with doing that?
    That would be a great enhancement to the tool as well 😀 an option for save as database schema or something like that. That would dump the old records for that universe name and create new ones when you rerun the tool after universe changes have been made.

    Like

  16. Wanda

    Hola Dmytro, I am trying to document our 3.1 universes so I tried the documenter tool for 3.1. However, I get the following error: “Unhandled exception has occurred in your application. If you click continue, the application will ignore this error and attempt to continue.
    Could not load file or assembly ‘WindowsBase, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35’ or one of its dependencies. The system cannot find the file specified.” When I click continue, it exists documenter. My machine still has windows xp.
    Cuidate, Wanda

    Like

  17. Gopi

    Hi dmystro,

    Awesome tool!!!!. Is there a way that I can get output file as csv. Also there is no column information in the first tab after exporting to excel. Perhaps table information exists.

    Like

  19. Revanth

    Im using BO 4.0 and when i use your application Unvdoc.exe a window opens directly promting for standalone mode and when i click the open button for getting the universe from my system, i get the below error.
    “Unable to cast COM object of type ‘Designer.ApplicationClass’ to interface type ‘Designer.|Application’. This operation failed ….”

    Can you please help me how to solve this issue. My objective is documenting the Universe in Excel and changing the object names exporting it back to universe.

    Like

  20. johndawg

    I’m getting the same issue as a few other people are:

    “Unable to cast COM object of type ‘Designer.ApplicationClass’ to interface type ‘Designer.|Application’. This operation failed ….”

    We are on XI4 SP11.

    I’m running the tool on my laptop and I have MS Framework 4 installed.

    Like

  21. Tom

    Hi,

    The same error here:
    Unable to cast COM objectof type’Designer.ApplicationClass’to interfacetype ‘Designer.|Application. this operation failed because the query interface call on the com component for the interface with ||D ‘{B88BF663-03EE-4140-AA7e-AB4bfdb5c28e}’failed due to followinf error :NO such interafce supported(Exception from HRESULT:)x8—4002(E-NOININTEFACE)).

    I have MS Framework 4 and am running BO 4 (SP4 w. fp3)

    The sample output looks really great and I can’t wait to run it on our universes.

    Thanks.

    Like

  23. Gurmeet Singh

    Thank you very much for this great tool. You are a star. Does it work for XI R2 (old version) also?

    Like

    1. dmytro Post author

      It will probably not work. I can try to compile it for R2… if this post gets 1000 likes 🙂 or at least a couple 🙂

      Like

  24. frank

    I get this error when I try to save the universer to excel. ” Could not save to Excel file. The server threw an exception(exception HRESULT:0x80010105(RPC_E_SERVERFAULT)). Please comment

    Like

    1. dmytro Post author

      Why do you need it?

      If you have BOE installed on your machine, then you can find it in win32_x86.

      If you do not want to install BOE, you can install BOE NET SDK Runtime package.

      Like

  26. HRens

    Awful tool. And amazingly fast.
    But I have one question: will it ever treat “multilingual universes” ?
    Our universes make intensive use of Translation Manager, to have one object to include in a query, but the text has to be automatically translated to the users’ language (for us: Dutch or French, German should be added too.
    Neither Dwayne’s Universe Documentor, nor Andre’s GetSetUniverse nor this tool seem to capture the “description” (or comment) field on our objects.

    The “object description” and “class description” fields now are either empty or contain a formula <>

    but excel cannot “evaluate” that one.

    Today, we need a complicated workaround, combining the excel result with TM-extracted LDF documents. But the developer told me yesterday that “it is difficult to describe on paper how do that, isn’t that documentation a waste of time ?” (He tries to explain showing that he clicked “this” and “that” and “that too” , fifty screens in three minutes)

    I cannot imagine Belgium being the only place where TM is really used that way.

    It would help us a great deal, if this kind of functionality could be captured.

    Like

  27. Anu

    Hi dymtro,
    i ran the tool on my server and i have .net 4 installed but i get the follwing error when i try to open a file..
    i am trying to use this tool but i am getting an error message as unhandled exception has occured in your application, if you click on continue , the appliocation will ignore this error and attempt tp continue.if you click QUIT , THE APPLICATION WILL CLOSE IMMEDIATELY.

    Unable to cast COM objectof type’Designer.ApplicationClass’to interfacetype ‘Designer.|Application. this operation failed because the query interface call on the com component for the interface with ||D ‘{B88BF663-03EE-4140-AA7e-AB4bfdb5c28e}’failed due to followinf error :NO such interafce supported(Exception from HRESULT:)x8—4002(E-NOININTEFACE)).
    ..i have Bo Xi 3.1 and .NEt 4 installed.

    Like

  28. Adam

    Hi!

    I’m trying to modify your Documenter to save data to relatation database instead of an Excel file. Your build for BO BI 4.0 works on my PC.

    I downloaded Source Code and opened project in Visual Studio, but the project cannot be build, there are two warnings:
    “The referenced component ‘Designer’ could not be found.” and “Cannot get the file path for type library “fb14d5a5-a14d-42f5-aec4-351874dfd86f” version 12.0. Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED))”
    and many (28) errors:
    “The type or namespace name ‘Designer’ could not be found (are you missing a using directive or an assembly reference?)”

    The system has freshly installed Client tools including Designer. The file C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\Designer.dll exist but the COM is appearantly called “Crystal Enterprise Designer PlugIn 12”; adding this COM as reference in VisualStudio does not help – still cannot build.

    Please, tell me, how to build Universe Documenter for BO 4.0.
    Thanks in advance.

    Like

    1. Adam

      Should have waited a few minutes before posting.
      Anyway for all other people:
      Referencing “BusinessObjects Designer 14.0 Object Library” (file C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\designer.exe) does the trick.

      Like

  29. Prashanthi

    Thanks a lot. This was so fast, extremely good information. I got a new PC at my work and not able to find the excel ad-in to install. Just ended up using my old machine and it worked like a charm. Thanks a ton.

    Like

  33. Darko

    Really nice tool, simple and efficient. It helped me :). Maybe a nice feature would be to have export in xml.

    Thanks..

    Like

  34. Raghavendra

    Thank you very much for the info. But I’m unable to run unvdoc.exe file on BO4 server machine. When I try to run this by default it shows standalone mode. I’m unable to import any .unv file. Could you please help me what are all pre-requisites to run this program. I have no idea on coding.

    Thanks,
    Raghavendra

    Like

  35. SAM

    I downloaded your source code for 3.1. When trying to build the project I am getting error saying designer dll is missing even when I imported the designer.dll of boe 3.1 sp4. Please tell me which dll to use to get the warning removed.

    Like

  36. deep

    How can we find out the objects used in the report in b0 3.1 ???? We have to change one of the object in the universe for that first we have to find out the reports that are using particular object..Is there any way that we can find out the reports that are using particular object???

    Like

  40. Ozzie

    Hey dymtro,

    Your tool is great, the best one I have come across for documenting universes.
    Would it be possible to add a column “Alias Select” which would include the real table name and not the alias “Realtable.field”, that way you can easily document universe objects vs table fields.
    Ozzie

    Like

  41. fa

    I’m getting following error:
    MS .Net 4.5, Universe Design Tool 14.0.4
    ************** Exception Text **************
    System.InvalidCastException: Unable to cast COM object of type ‘Designer.ApplicationClass’ to interface type ‘Designer.IApplication’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{B88BF663-03EE-4140-AA7E-AB4BFDB5C28E}’ failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).
    at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
    at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
    at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
    at Designer.ApplicationClass.GetInstallDirectory(DsDirectoryID DirectoryID)
    at UnvDoc.MainForm.buttonOpen_Click(Object sender, EventArgs e) in C:\Users\DmytroBukhantsov\Desktop\UnvDoc_src\UnvDoc\UnvDoc\MainForm.cs:line 65
    at System.Windows.Forms.Control.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
    at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
    at System.Windows.Forms.Control.WndProc(Message& m)
    at System.Windows.Forms.ButtonBase.WndProc(Message& m)
    at System.Windows.Forms.Button.WndProc(Message& m)
    at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
    at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
    at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

    Like

    2. Maxim Fomenko

      Have same error. In my case it happens if I am trying to compare two big universes. So to reproduce the issue try to run diff for universes with 50+ derived tables.

      Like

  42. khan

    I am new to BO and star using UDT and when I am inserting tables, it show fully qualify table name, how to avoid it that it should show only table names.

    thanks

    khan

    Like

  43. Su

    Hi Dmytro,

    The tool is just fab. It has made my life lot easier.

    Is it possible though to be able to save the output in mdb or db table instead of XLSX file. Otherwise, do you have any thoughts in case the total list of columns is more than the xls limit (ie 65536).

    Thanks for your thougths

    Cheers
    Su

    Like

  44. Maria

    Dmitry,

    thank you very much for this tool. I just downloaded and used for the first time. It really helped me to determine whether customer had a the same versions of universe in Live and Test. Thanks a lot. I saved so much time.

    Maria

    Like

  45. Dinesh

    Hi Dmytro,

    Great tool!!! really helpful and saved a huge amount of work!!!

    But am getting a small problem. Actually i changed your code slightly for my convenience. I have added a new form and moved all the checkboxes from mainform to that new form.Then,I have declared a boolean variable for each checkboxes and assigned “checkboxes.checked” value to each variable in new form.Then in Mainform,I have used those variables in place of “checkboxes.checked” in SaveToExcelFile() function.And i dint change anythin else in coding.but while running the code am getting error like “Retrieving the COM class factory for component with CLSID {3496DB16-E495-48C8-9C99-014AF38AD128} failed due to the following error: 80080005” in the following line of code.

    Designer.Application application = new Designer.Application();

    Thanks,
    Dinesh

    Like

  46. Anton

    Hi Dmytro,

    Great tool! It already save me a lot of time. Thank you.

    I think building a universe at BO, which will gather all the metadata of all our universe data.

    With this universe, we can get all info about objects,columns,tables and so on.

    Have you considered adding an option of exporting all the universes metadata into one big flat file?

    Cheers,
    Anton

    Like

    1. dmytro Post author

      Hi Anton
      Interesting idea. Probably it will require many flat files since it is difficult to denormalize completely.

      Like

      1. Anton

        Actually, it does not matter, whether the result will be a single file or group of files.

        The idea is to get metadata of all universes by one batch execution.
        What do you think?

        Like

      2. dmytro Post author

        The idea is good. It should also be easy to implement (by converting this code into a command line tool and implementing export to CSV or similar).

        My doubt is whether this really useful. How will the users benefit from the universe with metadata about universes?

        Like

  47. Mike Nicholas

    Dmytro – Excellent Tool! I have one final piece to resolve, I need to identify Webi source columns to objects/classes in the Universe. So far I havent found a tool that does it. Maybe some day you could add that to the tool!
    Thanks Again!

    Like

  48. lkanth

    I downloaded this tool for SAP BO 4.1. Should I need to connect .prj or .blx. How should I connect to from the exe file. PLease explain

    THanks

    Like

  49. lkanth

    Getting Error when I click open button for Universe
    Unhandled Exception – Unable to cast COM object of type ‘ Designer ApplicationClass to interface type ‘Designer.Iapplication.

    Let me know what is the issue.

    Thanks

    Like

  50. Dinesh

    Hi Dmytro,

    Can we extract details like server name,database name and whether it is oracle,sql or some other and connection string from Universe?
    Help me out!!!!

    Thanks!!!!

    Like

    1. dmytro Post author

      This tool does not extract connection information. You can extract connection information using Designer SDK.

      Like

Comments are closed.