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 ... 18, 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
mike_k
Forum Member
Forum Member



Joined: 18 Aug 2006

Posts: 14



PostPosted: Mon Oct 21, 2013 3:15 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Hi All,

In case anybody has experienced problems with making 'Document a Universe (XIr2).xls' work with BO4 - I've managed to make it work with BO4 on a 64bit Win7 Office2010 desktop. The main problem was that macros in Excel could not find the right object library.
Here is the fix:
1) Excel may open with error due to missing libraries when running on pc with ‘unsupported’ BO version (above XIR2)
This can be overcome by going to Excel >> Developer >> Visual Basic > Tools > References.
2) "References - VBAProject window opens"
3) Here indicate the BO Object Library or BO Designer Object Library that is installed on local PC
4) Press OK. Save the project and try to reopen 'Document a Universe (XIr2).xls'

Other problems that I've encountered - In case of any VB errors or Excel hangs ensure that all related applications are closed: Excel and BO Designer and their processes are not hanging in task manager.

I have successfully documented *.UNV universe but I haven’t tried to document UNX universes.

Hope it helps
M
Back to top
bobjfan45
Forum Member
Forum Member



Joined: 28 Oct 2013

Posts: 7



PostPosted: Tue Oct 29, 2013 3:46 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

Hi,

This utility has been a great handy tool for quite a while with my experience using version 3.1.

Is there are a similar utility for version 4.0 on this forum? Please redirect me to the appropriate link if one exists.

Appreciate any help in advance!

Thanks...
Back to top
HenkK
Forum Associate
Forum Associate



Joined: 02 Mar 2004

Posts: 857
Location: Zwolle, The Netherlands


flag
PostPosted: Wed Oct 30, 2013 3:32 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

After migrating to a new server all documents and universes were moved. Now the documentor only sees 331 docs instead of around 1200 docs. Any idea how this can happen?

HenkK

_________________
BO 4.1.6 ~ XI, Cognos 8 BI icon_wink.gif, Microsoft BI 2005/2008/2012 icon_wink.gif, Oracle/SQL Server
Back to top
fcerussi
Forum Member
Forum Member



Joined: 27 Jan 2009

Posts: 6
Location: Brasil



PostPosted: Tue Nov 05, 2013 8:31 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Hi,

I'm looking for in google an excel macro documentation for Universe Designer 4.0, but i dont found.

Can you share the file comment below?

Regards,

Cerussi
Back to top
HenkK
Forum Associate
Forum Associate



Joined: 02 Mar 2004

Posts: 857
Location: Zwolle, The Netherlands


flag
PostPosted: Wed Nov 06, 2013 3:08 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Please check the Bobs download area.

HenkK

_________________
BO 4.1.6 ~ XI, Cognos 8 BI icon_wink.gif, Microsoft BI 2005/2008/2012 icon_wink.gif, Oracle/SQL Server
Back to top
Judith Dotson
Forum Member
Forum Member



Joined: 16 Aug 2002

Posts: 11
Location: New York


flag
PostPosted: Thu May 22, 2014 11:59 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Hi, does anyone know if there is a similar Excel macro for documenting a 4.0 universe?

Thanks.

_________________
Judith Dotson
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

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


flag
PostPosted: Thu May 22, 2014 12:12 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

You can use the version 3 macro against version 4 UNV files but not UNX files. What you need to do is open the macro and change the references to the newer libraries. For example, if you open the macro I think you will see that it references Version 12.0 for XI 3 and version 14 for BI4.

The VBA macros hosted in Excel will not work against a universe created via Information Design Tool however.

_________________
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
JohnBClark
Forum Enthusiast
Forum Enthusiast



Joined: 27 Mar 2007
ASUG Icon
Posts: 1043
Location: Appleton, WI USA


flag
PostPosted: Thu Jun 19, 2014 9:31 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Dave Rathbun wrote:
You can use the version 3 macro against version 4 UNV files but not UNX files. What you need to do is open the macro and change the references to the newer libraries. For example, if you open the macro I think you will see that it references Version 12.0 for XI 3 and version 14 for BI4.
It appears that there may be a little more to making the conversion for BI4.1. I was able to use the Excel Universe Documentation for BI4.0 but I am getting errors with BI4.1.

I am getting the following error: Run-time error '430': Class does not support Automation or does not support expected interface triggered by
Code:
Set DesApp = New Designer.Application
I have updated the library for the BusinessObjects Designer Object Library to version 14.0.

icon_question.gif Has anyone been able to get the spreadsheet to work with BI4.1?

Edit:I found that I was able to run the spreadsheet if I ran it as an Administrator on my machine. This poses all kinds of problems as that ID doesn't have access to Business Objects to log in to Designer. It also poses a problem as the universe is saved under the regular user ID's data.

_________________
BusinessObjects BI4.2sp4, SQL Server 2016 (CMS)
Clustered for fail over redundancy
Reporting Tools: Crystal Reports 2016sp4, Web Intelligence
Operating System: Windows 2016 running on VMWare
Reporting databases: SQL Server, Teradata, DB2, Oracle, Hive
Information Steward 4.2sp10
History: BO5, BO6, XIR2, XI3.1, BI4.1.x
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

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


flag
PostPosted: Mon Jun 23, 2014 11:46 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

JohnBClark wrote:
Edit:I found that I was able to run the spreadsheet if I ran it as an Administrator on my machine. This poses all kinds of problems as that ID doesn't have access to Business Objects to log in to Designer. It also poses a problem as the universe is saved under the regular user ID's data.

I think if you run Designer at least once as Administrator it clears this up. After that the Excel macro should be able to launch the application.

_________________
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
JohnBClark
Forum Enthusiast
Forum Enthusiast



Joined: 27 Mar 2007
ASUG Icon
Posts: 1043
Location: Appleton, WI USA


flag
PostPosted: Mon Jun 23, 2014 1:55 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

Dave Rathbun wrote:
I think if you run Designer at least once as Administrator it clears this up. After that the Excel macro should be able to launch the application.
Thanks Dave, it did work to run Designer as the local administrator once first. After that, I could run the Excel macro just fine under my "non-administrator" account that security at our company prefers. Have a cookie.gif
_________________
BusinessObjects BI4.2sp4, SQL Server 2016 (CMS)
Clustered for fail over redundancy
Reporting Tools: Crystal Reports 2016sp4, Web Intelligence
Operating System: Windows 2016 running on VMWare
Reporting databases: SQL Server, Teradata, DB2, Oracle, Hive
Information Steward 4.2sp10
History: BO5, BO6, XIR2, XI3.1, BI4.1.x
Back to top
Charles Killam
Principal Member
Principal Member



Joined: 24 Apr 2003

speaker.gif*3
Posts: 310
Location: Colorful Colorado!!!!


flag
PostPosted: Mon Jun 30, 2014 10:25 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Duane,

Is there a copy of the universe documentor for v4.1?? If so please let me know where I can get it... icon_smile.gif

_________________
Charles A. Killam
Business Intelligence Consultant
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

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


flag
PostPosted: Mon Jun 30, 2014 11:04 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Charles, long time no see. icon_smile.gif

As mentioned only a couple of posts ago, the utility should work fine against .UNV universes in 4.1 as long as you update the library references. Simply open the macro, select Tools and then References and make sure the proper version of the BOBJ library files are marked.

_________________
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
Charles Killam
Principal Member
Principal Member



Joined: 24 Apr 2003

speaker.gif*3
Posts: 310
Location: Colorful Colorado!!!!


flag
PostPosted: Mon Jun 30, 2014 11:34 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Well, the coding part has always been my weakness. Where do I find the designer object library?? I am not a rocket scientist in this space:)
Sorry about the DUH factor:) Thanks

_________________
Charles A. Killam
Business Intelligence Consultant
Back to top
Charles Killam
Principal Member
Principal Member



Joined: 24 Apr 2003

speaker.gif*3
Posts: 310
Location: Colorful Colorado!!!!


flag
PostPosted: Mon Jun 30, 2014 11:47 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Well, when I get the macro open and go to Tool, the reference choice is grayed out?? icon_sad.gif BUMMER.....
_________________
Charles A. Killam
Business Intelligence Consultant
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

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


flag
PostPosted: Mon Jun 30, 2014 12:29 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

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.


Document a Universe BI4.zip
 Description:
Updated library reference for BI4

Download
 Filename:  Document a Universe BI4.zip
 Filesize:  44.09 KB
 Downloaded:  3894 Time(s)


_________________
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
Display posts from previous:   
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Page 19 of 22 All times are GMT - 5 Hours
Goto page Previous  1, 2, 3 ... 18, 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.0991 seconds using 19 queries. (SQL 0.0074 Parse 0.0626 Other 0.0291)
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