DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
deboots



Group memberships:
Premium Members

Joined: 23 Feb 2012
Posts: 71
Location: Portland, OR
Points: 777

Post Posted: Mon Jul 02, 2012 10:41 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Server
OS: Unix
We are getting ready to implement InfoSphere Business Glossary and link it to Cognos. As most of you know, we can easily change the Cognos configuration to use BG as the source for definitions. However, there have been some implementations through the years where developers embedded term definitions within the Cognos packages using tooltips/screentips. It's difficult to assess whether these are being used. I don't want to remove functionality from the business. I'd like to be able to harvest this data in some way. If I could access it easily I could then format it to batch load it into the Business Glossary.

Anyone know how to get this tooltip / screentip data out of Cognos?
Anyone know an easy way to scan and determine where tooltips/screentips exist within Cognos?

Thanks!
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54283
Location: Sydney, Australia
Points: 294429

Post Posted: Mon Jul 02, 2012 4:46 pm Reply with quote    Back to top    

After you've imported the Cognos BI report definitions, does perhaps the bi2bg utility pick up terms defined in tooltips?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
vmcburney

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 23 Jan 2003
Posts: 3584
Location: Australia, Melbourne
Points: 28037

Post Posted: Mon Jul 02, 2012 10:57 pm Reply with quote    Back to top    

This is easier of version 8.7 than earlier versions. First you run the Metadata Asset Manager to import the Cognos metadata from Cognos into the Information Server. The Metadata Asset Manager has a wizard and shows the bridge parameters for your import. You should test it out with one smaller cognos folder or package first to get it working.

Next run the aforementioned bi2bg option for istools on the Information Server. This will convert the Cognos model into a Business Glossary - it should come through with the report headings and the tooltips.
bi2bg Documentation .

Both processes may fail if you try it on an entire Glossary model so I would trial it on a subset first.

_________________
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn: Vincent McBurney LinkedIn
Rate this response:  
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54283
Location: Sydney, Australia
Points: 294429

Post Posted: Mon Jul 02, 2012 11:28 pm Reply with quote    Back to top    

Indeed it can fail even on a medium sized Cognos model. One way we have had to implement is to replace the 32-bit JVM that installs with the product with a 64-bit JVM provided by IBM suppor ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
deboots



Group memberships:
Premium Members

Joined: 23 Feb 2012
Posts: 71
Location: Portland, OR
Points: 777

Post Posted: Mon Jul 30, 2012 2:48 pm Reply with quote    Back to top    

Thanks for the documentation link, Vince. However, we still didn't find this to be very easy - even on 8.7. We were able to import the BI model into the repository - though had to guess at what was needed on some of the prompt screens. However, could never get the bi2bg parameters on istools to run.

One of the programmers did however write a python script that pulls the tool tip text into an Excel file along with the context/path. Since I wanted the Stewards to review those prior to load - that gives me what I really need (since I can now reformat that into the .csv import format that BG really wants).

I still want to be able to use the bi2bg process - but at this point may just wait to corner or bribe someone at IOD to walk me through it. Wink
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54283
Location: Sydney, Australia
Points: 294429

Post Posted: Mon Jul 30, 2012 5:19 pm Reply with quote    Back to top    

I'm running bi2bg successfully at my current site (finishing there today) so let's catch up at IOD. We've scripted it to run out of a third party scheduler, but the script itself is very straight ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
eostic

Premium Poster



Group memberships:
Premium Members

Joined: 17 Oct 2005
Posts: 3778

Points: 30336

Post Posted: Tue Jul 31, 2012 5:34 am Reply with quote    Back to top    

Hi Ray... Thanks......though I'm not certain that bi2bg picks up all of the possible description properties that may have originated in FrameWorker Manager for a particular Package that you've im ...

_________________
Ernie Ostic

blogit!
Open IGC is Here!
Rate this response:  
Not yet rated
eostic

Premium Poster



Group memberships:
Premium Members

Joined: 17 Oct 2005
Posts: 3778

Points: 30336

Post Posted: Tue Jul 31, 2012 5:37 am Reply with quote    Back to top    

Hi Ray... Thanks......though I'm not certain that bi2bg picks up all of the possible description properties that may have originated in FrameWorker Manager for a particular Package that you've im ...

_________________
Ernie Ostic

blogit!
Open IGC is Here!
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54283
Location: Sydney, Australia
Points: 294429

Post Posted: Tue Jul 31, 2012 3:41 pm Reply with quote    Back to top    

I have finished at that site, so can not confirm or deny whether all properties are received for each query item - nor even if they use tool tips at all.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours