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)  

General Notice: No events within the next 45 days.

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: 1846
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: 1846
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: 1846
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: 1846
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: 1846
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
RensH
Principal Member
Principal Member



Joined: 18 Jun 2007
ASUG Icon
Posts: 140


flag
PostPosted: Mon Oct 08, 2018 8:39 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

moons wrote:
Hello,

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

Thanks much!


Well, I DID stumble upon something that will help you generate this kind of "excel" file.
I found it on the website of
www.BICLEVER.com

For BI 4.1 SP5 it works, really well.
They provide a "windows program" ( exe file ) that lets you connect to a UNV universe, analyse it, export the analysis to excel
Another one will connect to UNX universes
A third one will let you connect to QueryBuilder. You can use (and create) "query templates", run them and ... export the answer to an excel file.

No, I did NOT find tools to run thse things from within excel.
the tools on biclever site will use your locally installed "BI client tools" and their library.
did not test this with 4.2 client tools (yet), but worked very well on 4.1 SP5 (which is old, I know, upgrade to some version of 4.2 is ongoing )

And yes, "my" excel being 64 bit probably won't talk well to the 32 bit client tools from 4.1

_________________
Transitioning to : XI 4.2 (SP3)
(Mostly WebI docs using universes, no voyager etc -yet- but (very few) dashboards )
LDAP eDirectory , repository on oracle.


Phasing out : BI 4.1 SP5 . Mostly Webi.
Phased out : BO-XI 3.1 SP6 . Mostly Webi.
Phased out : BO651, full clients. No Webi.
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



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


flag
PostPosted: Mon Oct 08, 2018 8:46 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

The tool you found won't work with 4.2 SP4 and newer unless they've recompiled it with the new version of the SDK. In 4.2 SP4 SAP replaced all of the old security libraries with more secure newer libraries. So, anything written with an earlier version of the SDK will not be able to connect to the newer versions of BOBJ.

-Dell

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



Joined: 06 Jun 2002

speaker.gif*16
Posts: 22117
Location: Dallas, Texas


flag
PostPosted: Mon Oct 08, 2018 8:55 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

RensH wrote:
No, I did NOT find tools to run thse things from within excel.

You most likely will not. The SDK framework has shifted from VBA to Java.

_________________
Dave's Adventures in Business Intelligence Image link

Latest Blog Posts
• 2018-10-19 BI Evolution
• 2018-09-13 Copying Content Is Not A Complement
• 2018-08-28 Resetting a Running Function
Back to top
Atul Chowdhury
Forum Associate
Forum Associate



Joined: 07 Jul 2003

Posts: 819
Location: New Jersey



PostPosted: Mon Oct 08, 2018 9:15 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

UNXpert may help for at least the use case where you want to:

* Extract UNX Object SELECT/WHERE/NAME/DESCRIPTION
* Modify in bulk, these properties in Excel
* Upload/Merge Visually Compare changes and push them back to the CMS

https://www.infolytik.com/unxpert/

(Yes, its free)

_________________
Atul Chowdhury @ Infolytik
http://www.infolytik.com
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.0336 seconds using 17 queries. (SQL 0.0032 Parse 0.0010 Other 0.0293)
CCBot/2.0 (https://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