OBS Data for Microsoft Visio

File uploaded by Robert Ensinger on Dec 13, 2014Last modified by Robert Ensinger on Dec 13, 2014
Version 3Show Document
  • View in full screen mode

Here's our contribution to the toolkit for OBS visualizations. This is a portlet that will export OBS information to Microsoft Excel in a format that you can turn into a visual representation in Microsoft Visio via Visio's Organization Chart Wizard.

 

1) Xog in attached OBS Data for Visio portlet to your CA PPM instance. Add it to your UI as you see fit.

 

 

2) In the OBS Filter pick an OBS then click Filter to run the portlet. Export the data to Excel and save the Excel file.

pick_obs.jpg

 

3) In Microsoft Visio, start the Organization Chart Wizard.

01.jpg

 

 

4) Select Information that's already stored in a file or database and click Next.

02.jpg

 

 

5) Select A text, Org Plus or Excel file and click Next.

03.jpg

 

 

6) Navigate to & select the excel file created in step #2. Click Next.

04.jpg

 

 

7) Select Name: OBS Level ID and Reports to: Parent OBS Level ID as shown below. Click Next.

05.jpg

 

 

8) Select OBS Level Name as the Display fields. Click Next.

06.jpg

 

 

9) Select Level Name for Shape Data fields. Click Next.

07.jpg

 

 

10) Click Next - let the system paint your whole OBS before you experiment with pagination & breaking it up.

08.jpg

 

 

11) The final dialog should look similar to this. Click Finish.

09.jpg

 

 

12) You should see a Viso of your OBS.

10.jpg

Outcomes