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

Register | Login 

Sunset Ride 
Sunset Ride 

General Notice: BOB is going to retire...please see details here. All BOB forums have been converted to "read only" as of September 1st.
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 ... 12, 13, 14 ... 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
twofivepie
Principal Member
Principal Member



Joined: 16 Oct 2008

Posts: 224


flag
PostPosted: Mon Jan 04, 2010 6:10 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Is there an XIR3 version of this coming?
Back to top
Dwayne Hoffpauir
Forum Groupie
Forum Groupie



Joined: 19 Sep 2002
ASUG Icon
medal_gold.gif*2speaker.gif*5medal_bronze.gif
Posts: 8641
Location: Plano, TX USA


flag
PostPosted: Mon Jan 04, 2010 9:11 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

twofivepie wrote:
Is there an XIR3 version of this coming?

No need. The description in the XIr2 version download states the following ... "Version XIr2 - also works with XI 3.0 (in VB editor, go to Tools, References... and change to 12.0 library if needed)."

_________________
Dwayne Hoffpauir
Image link
Back to top
twofivepie
Principal Member
Principal Member



Joined: 16 Oct 2008

Posts: 224


flag
PostPosted: Mon Jan 04, 2010 9:24 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

so it does...sorry
Back to top
Robin Cotton
Forum Member
Forum Member



Joined: 17 Oct 2002

Posts: 10
Location: Wichita, KS


flag
PostPosted: Fri Jan 15, 2010 12:49 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

Love this tool, but would be very interested to see if anyone has modified this to document ALL universes in the repository rather than limiting to single execution.
_________________
Robin Cotton
Cargill
BI Enterprise Architect
Back to top
chaithu1983
Senior Member
Senior Member



Joined: 19 May 2009

Posts: 59
Location: Singapore



PostPosted: Thu Feb 04, 2010 5:14 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Hi, I am facing the below error message while trying to click the button.

"VBAProject - 430; Class does not support automation or does not support expected interface"

Macro was set to Medium: for you info.

please guide what can be done now.

This app is very impressive.
Back to top
chaithu1983
Senior Member
Senior Member



Joined: 19 May 2009

Posts: 59
Location: Singapore



PostPosted: Thu Feb 04, 2010 5:19 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

The error code in VB Scirpt is taking to the line:

ErrorHandler:

vbCritical, "Failure in DocumentUniverse()"

Hope it is useful info.
Back to top
Dwayne Hoffpauir
Forum Groupie
Forum Groupie



Joined: 19 Sep 2002
ASUG Icon
medal_gold.gif*2speaker.gif*5medal_bronze.gif
Posts: 8641
Location: Plano, TX USA


flag
PostPosted: Tue Feb 23, 2010 9:05 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

chaithu1983 wrote:
Hi, I am facing the below error message while trying to click the button.

"VBAProject - 430; Class does not support automation or does not support expected interface"

Has "something" to do with permissions on your machine. The suggestions here have helped some to get it working.

_________________
Dwayne Hoffpauir
Image link
Back to top
Naveen Vanaparthi
Principal Member
Principal Member



Joined: 01 Jul 2008

Posts: 134



PostPosted: Thu Mar 04, 2010 3:32 pm 
Post subject: The macros in the project are diabled

HI,
using this Excel file (Document a universe XI2) can't proceed? i clicked many times on "Document a universe" Button,but iam getting"The macros in the project are diabled" in Vb editor of Excel ?may be the the problem with Excel macro or my universe?
Back to top
Naveen Vanaparthi
Principal Member
Principal Member



Joined: 01 Jul 2008

Posts: 134



PostPosted: Thu Mar 04, 2010 5:08 pm 
Post subject: Re: The macros in the project are diabled

I found this because Macros Disables in Excel File, i have Enabled in Excelmthen i documented the universe
Back to top
loic_cadiot
Senior Member
Senior Member



Joined: 05 Jan 2007

Posts: 32



PostPosted: Thu Mar 11, 2010 9:38 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Do you know this solution has been transposed in BOXI v3?
It seems that all info is not retrieved with this version of BO? (only some sheets, no objects, class or filter retrieval)

Thansk,
Back to top
loic_cadiot
Senior Member
Senior Member



Joined: 05 Jan 2007

Posts: 32



PostPosted: Fri Mar 12, 2010 9:14 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Robin Cotton wrote:
Love this tool, but would be very interested to see if anyone has modified this to document ALL universes in the repository rather than limiting to single execution.

I have the exact same need.
Back to top
JohnBrooking
Senior Member
Senior Member



Joined: 22 Dec 2009

Posts: 68



PostPosted: Thu Mar 25, 2010 2:46 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

+1 on a great tool! It's just what we were looking for!

Well, almost. What would be even cooler is a similar tool to compare two universes, such as corresponding production and development universes, to confirm what has been modified in development. Output could be similar to this, with only the differences listed.

I could write it myself, but I thought I'd ask here first if anyone already had. If I do get around to it, I'll post it here, but I'm not at all sure I'll find the time. (Although it would probably only take about the same amount of time as going through 2-3 manual comparisons, the first of which I'm in the middle of now!) icon_neutral.gif
Back to top
Ilkster
Forum Member
Forum Member



Joined: 16 Sep 2002

Posts: 2
Location: Weybridge, Surrey, UK


flag
PostPosted: Wed Mar 31, 2010 6:46 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Hi!
I was wondering if there is a way to discover which classes and objects are hidden in a universe.

What is the purpose of Show() property? It seems to be true for all classes and objects, even hidden ones. Am I barking at the wrong tree?

I've been writing a vb.net variation of this excellent utility for a while now and this is one of the final problems I have. banghead.gif

_________________
Ilkka Salminen
VLA
Weybridge, Surrey, England


Last edited by Ilkster on Wed Mar 31, 2010 6:52 am, edited 1 time in total
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11524
Location: Manchester, UK


flag
PostPosted: Wed Mar 31, 2010 6:49 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

loic_cadiot wrote:
Robin Cotton wrote:
Love this tool, but would be very interested to see if anyone has modified this to document ALL universes in the repository rather than limiting to single execution.

I have the exact same need.


Personally I'd document them one at a time.
Much easier to maintain if you've got one spreadsheet per universe, especially if they're not related.

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
sdimb
Senior Member
Senior Member



Joined: 18 Apr 2007

Posts: 73


flag
PostPosted: Wed Mar 31, 2010 9:53 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

I have this running on XIr3.1 sp2 and its is great - except - I am getting an error with detail dimensions when it is trying to get the associated dimension.
The error is 'Designer - 107: Cannot Get AssociatedAxis'
Has anyone else seen this and knows how to solve it please ?
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Page 13 of 22 All times are GMT - 5 Hours
Goto page Previous  1, 2, 3 ... 12, 13, 14 ... 20, 21, 22  Next
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0336 seconds using 17 queries. (SQL 0.0047 Parse 0.0010 Other 0.0280)
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