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


since June 2006

Group memberships:
Premium Members

Joined: 27 Mar 2006
Posts: 123
Location: San Ramon
Points: 1588

Post Posted: Mon Aug 22, 2016 5:10 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: 11.5.0.1
We're on Info Server 11.5.0.1. Does IGC have the ability to view multiple glossary terms and its attribute details in a single page? The closest we can get now is to search, then hover over each term to view attributes (some but not all), such as long description and status. Bonus would be the ability to actually edit attribute values within that view. Users currently have its dictionary/glossary in an Excel spreadsheet, and would like to retain that type of flexibility for editing.

I realize a work-around would be to save as CSV list, then re-import, but would like to be able to do the edits within the IGC UI.

thanks,
Rob
vmcburney

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 23 Jan 2003
Posts: 3573
Location: Australia, Melbourne
Points: 27832

Post Posted: Mon Aug 22, 2016 9:55 pm Reply with quote    Back to top    

Multi Edit is one of the most useful functions in all of IGC. There are a few places in IGC where you can produce a list of business terms that can then be used to open up the multi term editor:

- Use the Search function or Advanced Search function.

- Click on Glossary-Terms and then use the Filter button on the right to filter by name or category or label or modification date.

- Click on the label menu and open up all terms mapping to a specific label.

Each one of these will return a list of business terms with check boxes. You can select all or select some and click on the Edit button. This opens up the Multi Term editor. You then select which attributes you are going to bulk update and then get taken to an edit screen where you set and choose values, these values are then written to all Business Terms chosen.

The only way display a list of Glossary terms where you show extra attributes in the list is to use the Queries section of the IGC and create your own metadata query. This lets you choose which attributes to show but it doesn't let you open a multi editor from the query results.

All these lists can be dumped straight into CSV or Excel.

_________________
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn: Vincent McBurney LinkedIn
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: 54166
Location: Sydney, Australia
Points: 293772

Post Posted: Mon Aug 22, 2016 11:24 pm Reply with quote    Back to top    

In addition to the responses Vincent posted, you can also form a list for multiple edit by using the Drafts folder (one of the three folders in the governance area, the others being Pending Approval a ...

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


since June 2006

Group memberships:
Premium Members

Joined: 27 Mar 2006
Posts: 123
Location: San Ramon
Points: 1588

Post Posted: Tue Aug 23, 2016 12:09 pm Reply with quote    Back to top    

Thanks Ray and Vincent for the tips!

I can see the usefulness of this multiple edit capability. However, our users were specifically looking to be able to edit/view multiple items and update their attributes with distinct values (not necessarily setting the same value for multiple assets) from within the UI and not export to CSV/Excel.

For example, they would like to view asset name, long/short description, and a handful of custom attributes for 10 terms ideally in a table format. Then, have ability to compare values of the 10 terms, and update all or a subset of the attribute values. Does anyone else think this would be a valuable feature? Should it be a new feature request?
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: 54166
Location: Sydney, Australia
Points: 293772

Post Posted: Thu Aug 25, 2016 4:06 pm Reply with quote    Back to top    

You can export in XML format, edit the XML, and import (overwriting).

_________________
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