extract the list of worksets under the products in Dimensions database.

Manikandan A's picture
Manikandan A asked on October 17, 2014 - 2:08am | Replies (1).

Please provide the procedure to extract the list of worksets under the products from the oracle database (Serena Dimensions).

1 Answer

Drew Benson's picture

Via GUI:

Per Product:
Select Global Catalog ==> All Projects/Streams ==> Select required Product & Open (all)
from presented screen save output to file (csv or HTML) - Obviously you can change the displayed/saved columns.

All Products:
Edit ==> Find ==> Projects...
Clear out Product field (ie "ALL" Products)
Select ==> Open
from presented screen save output to file (csv or HTML) - Obviously you can change the displayed/saved columns

You could also use the published views and link using ODBC (via excel or whatever) and pick your way thorugh the tables or knock out some SQL - if you wanted something mor ethan a quick one off!

 

 

CMCrossroads is a TechWell community.

Through conferences, training, consulting, and online resources, TechWell helps you develop and deliver great software every day.