How to extract all the products and worksets of dimensions from browser client?

Manikandan A's picture
Manikandan A asked on December 15, 2014 - 3:32am | Replies (2).

I would like to extract all the dimensios products and assocaited worksets in one shot from browser client (admin console). Please let me know, how to do? i have the steps to extrct from desktop client.

2 Answers

Drew Benson's picture

I don't think the Adminconsole is the place to do this.

As per my previous answer (when you asked how to do it from the full Client) I woudl suggest knocking something up using ODBC and excel (or whatever).

The basic sql to get your data could be something like:

SELECT PCMS_WORKSET_INFO.PRODUCT_ID, PCMS_WORKSET_INFO.WORKSET_NAME, PCMS_WORKSET_INFO.STATUS
FROM YOURCODB.PCMS_WORKSET_INFO PCMS_WORKSET_INFO
ORDER BY PCMS_WORKSET_INFO.PRODUCT_ID, PCMS_WORKSET_INFO.WORKSET_NAME

The Output looks something like:

PRODUCT_ID    WORKSET_NAME       STATUS
$GENERIC        $GLOBAL                   UNLOCKED
YOUR_PROD1   YOUR_WS_NAME_1    OPEN
YOUR_PROD1   YOUR_WS_NAME_2    OPEN
YOUR_PROD1   YOUR_WS_NAME_3    OPEN
YOUR_PROD2   YOUR_WS_NAME_4    OPEN
etc ........ etc ...... etc

Obviously you could limit by Product or whatever.  

 

 

 

 

 

Drew Benson's picture

If you use the Web Browser (Client rather than Admin Console)
Change to Generic Global
Select "Projects" ==> Catalog
And save the Output to a csv

You can use various filters as well (Names etc) 

You could repeat this for Streams as well.  

CMCrossroads is a TechWell community.

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