Clarity

OBS Data for Microsoft Visio 

Dec 12, 2014 10:43 PM

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

Statistics
0 Favorited
6 Views
1 Files
0 Shares
2 Downloads
Attachment(s)
zip file
osuwmc_obs_data_for_visio_write.zip   3 KB   1 version
Uploaded - May 29, 2019

Related Entries and Links

No Related Resource entered.