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: BOB is going to retire...please see details here.
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, 22  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
rpatel18
Forum Member
Forum Member



Joined: 14 Aug 2007

Posts: 4



PostPosted: Wed Jul 02, 2014 8:55 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

where is the dll located for the BO 14 library...I'm missing the reference in my VBA but can't seem to find the right dll...
Back to top
rpatel18
Forum Member
Forum Member



Joined: 14 Aug 2007

Posts: 4



PostPosted: Wed Jul 02, 2014 9:03 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

ok, I think I found it now but now I'm getting this error:

-------------------------
Faiulure in DocumentUniverse()
Runtime error '430' class does not support Automation or does not support expected interface
--------------------------
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

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


flag
PostPosted: Wed Jul 02, 2014 9:07 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

This is sometimes fixed by running Designer at least once as Administrator on your computer.
_________________
Dave's Adventures in Business Intelligence Image link

Latest Blog Posts
• 2019-09-19 Stephen Few Blog Post on Multivariate Visualization
• 2019-02-11 Update on Query Banding
• 2018-10-19 BI Evolution
Back to top
2spots
Forum Member
Forum Member



Joined: 29 Jul 2008

Posts: 20


flag
PostPosted: Wed Jul 15, 2015 3:21 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

I'm getting this error too and running Designer as Administrator didn't fix it. Other ideas?
Back to top
cipherk
Forum Member
Forum Member



Joined: 26 Jul 2012

Posts: 4



PostPosted: Tue Jul 21, 2015 10:57 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

Thanks Dave,

Could you please point me to the right Library file for BO 4.1 ?

I am having difficulty in running the macro.

The error I am getting is :

VBAProject - 430: Class Does not support Automation or does not support expected interface.


Note: Used Designer.dll in

<InstalledPath> \SAP BusinessObjects Enterprise XI 4.0\win32_x86


Many thanks.
Back to top
rnola
Principal Member
Principal Member



Joined: 26 Mar 2006
ASUG Icon
Posts: 144
Location: DE



PostPosted: Fri Jul 31, 2015 11:18 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

I'm struck with the same error what 'cipherk' has got, has there been any success here ? And would the version of the MS office matter here ?

Thank you all.
Back to top
di652
Forum Enthusiast
Forum Enthusiast



Joined: 24 Feb 2005

Posts: 1180



PostPosted: Tue Oct 13, 2015 9:24 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

cipherk wrote:
Thanks Dave,

Could you please point me to the right Library file for BO 4.1 ?

I am having difficulty in running the macro.

The error I am getting is :

VBAProject - 430: Class Does not support Automation or does not support expected interface.


Note: Used Designer.dll in

<InstalledPath> \SAP BusinessObjects Enterprise XI 4.0\win32_x86


Many thanks.



I think you are trying to run this utility against a UNX universe. If this is so forget about it.
This and other great automated scripts using Excel will not work against the UNX universe.
Back to top
rnola
Principal Member
Principal Member



Joined: 26 Mar 2006
ASUG Icon
Posts: 144
Location: DE



PostPosted: Tue Jul 19, 2016 11:59 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

I finally got this to work.

Yes, I had the same VBA 430 automation error when tried to execute the macro. Here's the trick.

Before you run the spreadsheet, log into the designer ( preferably with Admin rights ). DO NOT CLOSE the designer application. Then open the spreadsheet and try running it. I didn't had to modify any of the lists in 'References'.
Back to top
newbie38
Forum Member
Forum Member



Joined: 04 Aug 2016

Posts: 1



PostPosted: Thu Aug 04, 2016 11:12 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Hello,

I use BO IDT 4.1. When I enter all the elements on connection dialog box, I have the issue :
Cannot access the repository (USR0013)
and in details :
"[repo_proxy 13] SessionFacade::openSessionLogon with user info has failed(Unable to connect to cluster @ebsboasdev01.samse.fr:6400 to retrieve CMS member list. Locally cached member list not present. Logon cannot continue.(hr=#0x80042a01)"

Did it happen to anybody ? What is the solution ?

Thank u

nb38
Back to top
Nivi s
Senior Member
Senior Member



Joined: 10 May 2012

Posts: 51



PostPosted: Wed Nov 30, 2016 3:25 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

Thanks for the sharing the file.

This is the first time I am using the file. I receive the following error-
"VBAProject- 430:Class does not support Automation or does not support expected interface"

Appreciate your time and support!

Nivi
Back to top
di652
Forum Enthusiast
Forum Enthusiast



Joined: 24 Feb 2005

Posts: 1180



PostPosted: Thu Dec 08, 2016 10:42 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

newbie38 wrote:
Hello,

I use BO IDT 4.1. When I enter all the elements on connection dialog box, I have the issue :
Cannot access the repository (USR0013)
and in details :
"[repo_proxy 13] SessionFacade::openSessionLogon with user info has failed(Unable to connect to cluster @ebsboasdev01.samse.fr:6400 to retrieve CMS member list. Locally cached member list not present. Logon cannot continue.(hr=#0x80042a01)"

Did it happen to anybody ? What is the solution ?

Thank u

nb38




Did you ever resolve this? I had this same issue and it got shelved but now its up again and I would really like to document a universe like I can with UNV files.
Seems that MACROS really don't work with the new and garbaged IDT nonod.gif

But, I would really like to be wrong on this one if anyone has insight!!?? icon_idea.gif
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



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


flag
PostPosted: Mon Jan 23, 2017 3:49 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

The challenge is that unx universes have a completely different format than unv universes. The Designer SDK that is used to get the information for unvs will not work with unxs.

Unfortunately, the only way to get the same information for a unx is through the Semantic Layer SDK, which is a Java only tool, so you can't use it from Excel.

-Dell

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



Joined: 23 Dec 2005

Posts: 472
Location: Des Moines Iowa


flag
PostPosted: Tue Feb 07, 2017 8:39 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Values for cardinality and joins in spread sheet
cardinality
many to many = 4
many to one = 3
one to many = 2
one to one =1

joins
full outer = 4
right outer = 3
left outer = 2
no outer = 1

Got to love search bringing me back to a 2008 post

_________________
Mike Murray
Back to top
di652
Forum Enthusiast
Forum Enthusiast



Joined: 24 Feb 2005

Posts: 1180



PostPosted: Thu Mar 23, 2017 8:28 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Any way to get an automated version for the 4.x unx files?
Back to top
di652
Forum Enthusiast
Forum Enthusiast



Joined: 24 Feb 2005

Posts: 1180



PostPosted: Thu Mar 23, 2017 8:31 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Dave Rathbun wrote:
I downloaded the XIR2 version from the first post and updated the library reference to BI4.0. I ran it against a simple BI4 universe and it seemed to work, so I am attaching it here on this post.


This will probably work on the UNV universes but not on the IDT-UNX files
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Page 20 of 22 All times are GMT - 5 Hours
Goto page Previous  1, 2, 3 ... 19, 20, 21, 22  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.0315 seconds using 17 queries. (SQL 0.0036 Parse 0.0010 Other 0.0269)
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