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

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

Sat Jun 16, 2018 12:06 pm: The BOB server was upgraded (O/S and database) today. If you encounter any errors, please post on the board. Posting has been tested and seems to be working. Thanks.
General Notice: Upcoming Events: BI & HANA 2018 Prague: Jun 29.

Document a universe using Excel and the Designer SDK
23 members found this topic helpful
Goto page Previous  1, 2, 3 ... 19, 20, 21
 
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
hilfy
Forum Enthusiast
Forum Enthusiast



Joined: 16 Apr 2007
ASUG Icon
speaker.gif*3
Posts: 1839
Location: Atlanta, GA


flag
PostPosted: Thu Mar 23, 2017 2:23 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

No, it won't work with UNX universes. For that you need to use the Semantic Layer Java SDK - it's not available for .NET.

-Dell

_________________
Protiviti
Data & Analytics Practice
https://www.protiviti.com/US-en/data-management-advanced-analytics
Back to top
bibhabasu
Forum Member
Forum Member



Joined: 08 Jun 2017

Posts: 1



PostPosted: Thu Jun 08, 2017 12:29 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

This one works perfectly fine for BI 4.2 in Windows 7.
But I am getting some errors while working on Windows 10 with office 2016.
Has anyone else faced the same issue and is there any solution?

Thanks in Advance!
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



Joined: 16 Apr 2007
ASUG Icon
speaker.gif*3
Posts: 1839
Location: Atlanta, GA


flag
PostPosted: Thu Jun 08, 2017 1:44 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

You may have to "register" the Designer type library - it doesn't automatically happen with the Client Tools install any more. To do this, open a command prompt and navigate to the win32_x86 folder in the BO install. Run the following command:

designer.exe \RegServer

The universe designer will open like it does when you run it from its icon and you won't see anything special. Close it when it comes up.

The other issue you might be running into is that designer is a 32-bit application. It will not work with a 64-bit version of MS Office.

-Dell

_________________
Protiviti
Data & Analytics Practice
https://www.protiviti.com/US-en/data-management-advanced-analytics
Back to top
tbcnfpt
Forum Member
Forum Member



Joined: 15 Dec 2004

Posts: 18


flag
PostPosted: Thu Feb 15, 2018 3:29 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Hi
i use idt
i cannot find the excel program to extract meta data from idt
where it is
thanks a lot

_________________
thierry
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



Joined: 16 Apr 2007
ASUG Icon
speaker.gif*3
Posts: 1839
Location: Atlanta, GA


flag
PostPosted: Thu Feb 15, 2018 9:43 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

There isn't one. There is no .NET SDK for the "Semantic Layer" (IDT), it is available for Java only. I've done some work with it and it's not too difficult, but it is different from the COM-based Designer SDK that is used with .unv universes.

-Dell

_________________
Protiviti
Data & Analytics Practice
https://www.protiviti.com/US-en/data-management-advanced-analytics
Back to top
moons
Senior Member
Senior Member



Joined: 08 Nov 2007
ASUG Icon
Posts: 81
Location: Michigan


flag
PostPosted: Thu Feb 22, 2018 9:02 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Hello,

Is there a "Document a Universe" file to IDT?

Thanks much!

_________________
"Fear knocked the door. Faith replied. No one was there."
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



Joined: 16 Apr 2007
ASUG Icon
speaker.gif*3
Posts: 1839
Location: Atlanta, GA


flag
PostPosted: Thu Feb 22, 2018 10:01 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

If you'll look at the responses in this thread you'll see that there isn't one. Because the Semantic Layer SDK is only available for Java, there's no way to do this in Excel like was possible for the UDT.

-Dell

_________________
Protiviti
Data & Analytics Practice
https://www.protiviti.com/US-en/data-management-advanced-analytics
Back to top
moons
Senior Member
Senior Member



Joined: 08 Nov 2007
ASUG Icon
Posts: 81
Location: Michigan


flag
PostPosted: Thu Feb 22, 2018 10:13 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Thanks for quick response hilfy! Is there a way we can document IDT? any ideas would be greatly appreciated. Thanks!
_________________
"Fear knocked the door. Faith replied. No one was there."
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



Joined: 16 Apr 2007
ASUG Icon
speaker.gif*3
Posts: 1839
Location: Atlanta, GA


flag
PostPosted: Thu Feb 22, 2018 10:34 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

It's possible to write a program using Java and the Semantic Layer SDK that will let you document .unx universes. I have written code to do this and write the info to a database. Unfortunately, the code belongs to one of my clients, so I can't share it except for a snippet here or there. However, I can provide guidance for how to use the SDK to get what you need.

-Dell

_________________
Protiviti
Data & Analytics Practice
https://www.protiviti.com/US-en/data-management-advanced-analytics
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Page 21 of 21 All times are GMT - 5 Hours
Goto page Previous  1, 2, 3 ... 19, 20, 21
 
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.0127 seconds using 17 queries. (SQL 0.0029 Parse 0.0003 Other 0.0095)
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