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 ... 10, 11, 12 ... 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
margarita
Senior Member
Senior Member



Joined: 08 Nov 2005

Posts: 98
Location: London



PostPosted: Thu Sep 17, 2009 9:40 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

Nick Daniels wrote:
margarita wrote:
Any thoughts on what else I can check ?
Check whether anyone in this thread has got the code working on Vista and/or Excel 2007.


Thanks for the constructive comments Nick icon_wink.gif

I appreciate this macro was designed and tested on a previous OS and Excel version. I'm sure I can get this to work, and the documentation that it provides is too valuable to me to just give up on it.
Back to top
EIC_Rich
Forum Member
Forum Member



Joined: 17 Dec 2008

Posts: 1



PostPosted: Mon Sep 21, 2009 2:18 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

This is great - We have been talking about possibly building a SQL knowledge base from the columns in the spreadseet and accessing that information via a universe. I looked for the universe name to be imbedded somewhere in the spreadsheet but didn't see anything. Is the name and business objects folder available anywhere in the actual spreadsheet?

Thanks
Rich
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: Wed Sep 23, 2009 12:29 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

margarita wrote:
It seems like Excel cannot connect to the correct dll to launch Designer at runtime. Any thoughts on what else I can check ?


No, and it's so frustrating. I know that it DOES work with Vista / Excel 2007. I got a shiny new computer a few months back, and it works flawlessly, but I can't explain why.

_________________
Dwayne Hoffpauir
Image link
Back to top
margarita
Senior Member
Senior Member



Joined: 08 Nov 2005

Posts: 98
Location: London



PostPosted: Thu Sep 24, 2009 4:20 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

I got it eventually icon_biggrin.gif

For me it was a combination of :
- local admin rights to pc
- explicitly set Designer.exe to run as Administrator
- turn off Vista User Account Control (UAC)
- added config file to directory containing Excel.exe to point to correct .NET Framework. I haven't experimented removing this file to see if this makes a difference.

It makes it difficult if you work in a locked down environment. I have to change the UAC setting every day that I want to run the macro as it resets each night icon_rolleyes.gif
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: Fri Sep 25, 2009 1:00 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

margarita wrote:
For me it was a combination of :
- local admin rights to pc
- explicitly set Designer.exe to run as Administrator
- turn off Vista User Account Control (UAC)
- added config file to directory containing Excel.exe to point to correct .NET Framework. I haven't experimented removing this file to see if this makes a difference.

Good stuff! Hopefully we can get a few more folks to confirm if these steps help, because it's been quite the mystery for some time!

_________________
Dwayne Hoffpauir
Image link
Back to top
srijoy
Forum Member
Forum Member



Joined: 29 Sep 2009

Posts: 5



PostPosted: Wed Oct 07, 2009 4:23 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

wow!!!! thumbsup.gif
amazing tool. Thanks a lot.

I am trying to find the Class to which the object belongs? The RootClass function returns the name of the root class. How can i get the name of the immediate Class and not the root class?

If this Question has already been answered in this huge thread can u please guide me to that post.

Thanks in advance
Back to top
yohab
Principal Member
Principal Member



Joined: 24 Dec 2003

Posts: 265



PostPosted: Thu Oct 08, 2009 5:36 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Hi,

How can the script be ajusted so it will fetch all the universes info ?

Yoav
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: Thu Oct 08, 2009 9:01 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

srijoy wrote:
I am trying to find the Class to which the object belongs? The RootClass function returns the name of the root class. How can i get the name of the immediate Class and not the root class?

Not sure I follow the question exactly. The .RootClass property returns the "parent" class of the given object. If you are looking for all of the intervening classes above it (the class "folder" structure), I can see two choices. First, you "sort of" have this information on the Classes tab of the utility. Second, you could tweak the code to successively concatenate a string with the "trail" of classes ... say, inserting a "/" between each level.

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



Joined: 24 Dec 2003

Posts: 265



PostPosted: Thu Oct 08, 2009 12:08 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

Hey Dwayne,

i was actually asking if it's possible to document all the universes files rather than just one at a time.

Thanks

Yoav
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

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


flag
PostPosted: Thu Oct 08, 2009 12:10 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

yohab wrote:
i was actually asking if it's possible to document all the universes files rather than just one at a time.

He was answering the post prior to yours.

It doesn't make sense, in my opinion, to do everything at once. If you wanted to, I am sure you could put a "wrapper" loop around the base code provided in the utility and loop through all of the universes. You would need to figure out how to store the information.

_________________
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
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 Oct 12, 2009 12:41 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

Dave Rathbun wrote:
If you wanted to, I am sure you could put a "wrapper" loop around the base code provided in the utility and loop through all of the universes. You would need to figure out how to store the information.

I considered including that feature in the utility, but came to the same conclusion as Dave. It just didn't make sense to me. Most users of the information would immediately put in a filter to look at one universe at a time. That said, if you wanted to document all universes stored locally, you could adapt the "recursion" technique shown in this utility, and apply it to *.unv files.

_________________
Dwayne Hoffpauir
Image link
Back to top
rodlangham
Senior Member
Senior Member



Joined: 13 Apr 2004

Posts: 39


flag
PostPosted: Wed Oct 14, 2009 2:39 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

I too had difficulty in getting this to work for BOXI 3.1 on Vista, but thanks to Margarita's tips I got it working with:
1. Developer i.e local admin rights on Vista
2. Setting the Designer.exe to run as Administrator
3. Turned off User Account Control
(FWIW I didn't need to do the last step involving a config file.)
Thanks to Dwayne & Margarita
Back to top
rbrito
Senior Member
Senior Member



Joined: 06 Sep 2007

Posts: 77
Location: Miami


flag
PostPosted: Fri Oct 16, 2009 1:58 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

Thanks for this great tool Dwayne! thumbsup.gif

I was wondering if there is a way to get the connection information, such as Connection Name, Database, and User, using your macro.

Please let me know.

Thanks!
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: Wed Oct 21, 2009 8:52 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

rbrito wrote:
I was wondering if there is a way to get the connection information, such as Connection Name, Database, and User, using your macro.

Sure, give these a try:
Code:
DesApp.Connections(Univ.Connection).Name
DesApp.Connections(Univ.Connection).DatabaseEngine
DesApp.Connections(Univ.Connection).DatabaseSource
DesApp.Connections(Univ.Connection).UserName

_________________
Dwayne Hoffpauir
Image link
Back to top
mrsnow
Senior Member
Senior Member



Joined: 16 Nov 2006

Posts: 64



PostPosted: Thu Nov 12, 2009 9:24 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Dwaine, this is an absolutely fantastic utility - ive been using it for quite a while now and its saved me significant abouts of time.

I have been trying to modify some of the code slightly with limited success. I basically want to change the Table Name(s) column on the Objects tab, so that rather than a list of the distinct tables used in each object, it displays a distinct list of the table names & column names... (ie - tbale1.column1, table 1.column2, table2.column1 etc)

We have a number of complicated objects in one of our Universes with multiple table/column references (decodes/case etc).

The code is:

For Each Tbl In Obj.Tables
Rng(RowNum, 7) = Rng(RowNum, 7) & Tbl.Name & ", "
Next Tbl
'... but remove the trailing comma
If Obj.Tables.Count > 0 Then
Rng(RowNum, 7) = Left(Rng(RowNum, 7), Len(Rng(RowNum, 7)) - 2)
End If

I have tried modifying it, including 'Dim Col As Designer.Column' at the start - but I keep getting compiler/compatability error's.

Do you think this is possible, and (if so), would you be able to point me in the right direction please??
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Page 11 of 22 All times are GMT - 5 Hours
Goto page Previous  1, 2, 3 ... 10, 11, 12 ... 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.1106 seconds using 17 queries. (SQL 0.0126 Parse 0.0677 Other 0.0303)
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