Clarity PPM

Expand all | Collapse all

How to expand and export OBS structure

Jump to Best Answer
  • 1.  How to expand and export OBS structure

    Posted 04-16-2019 01:02 PM

    Hi. we have our OBS structure set up with multiple / hierarchical levels - is there a way we can export or run a report to maintain the level structure and show the attached instances (Resource and Projects)?  When I export to excel through resources it doesn't maintain the structure.


    Thank you


    Clarity 15.1.1

  • 2.  Re: How to expand and export OBS structure

    Posted 04-16-2019 03:38 PM

    You could create a NSQL query based portlet and export from that.

    The query could be something like (Oracle)

    SELECT OBS_type_nAME,
      prj_obs_types.UNIQUE_NAME Type_unique_name,
    (NVL(,'') || NVL(|| '/','') || NVL('/' ,'') || NVL( ||
     '/','') ||
    NVL( || '/','') ||NVL( || '/','') || NVL( || '/','') || NVL(
     || '/','') ||
    NVL( || '/','') || NVL( || '/','') || OBS_full_PATH,
      prj_obs_units.NAME Unit_name,
      prj_obs_units.UNIQUE_NAME Unit_unique_name, OBS_unit_id,
    prj_obs_units left join prj_obs_units Parent1 on
    left join prj_obs_units Parent2 on
    left join prj_obs_units Parent3 on
    left join prj_obs_units Parent4 on
    left join prj_obs_units Parent5 on
    left join prj_obs_units Parent6 on
    left join prj_obs_units Parent7 on
    left join prj_obs_units Parent8 on
    left join prj_obs_units Parent9 on
    left join prj_obs_units Parent10 on


    optionally also

    and   prj_obs_types.UNIQUE_NAME ='your OBS code'


    To get the attached resource units left join something like
    and prj_obs_associations.table_name= 'SRM_RESOURCES'


    and similar for projects

  • 3.  Re: How to expand and export OBS structure
    Best Answer

    Posted 04-17-2019 09:50 PM

    Try to xogout OBS by using obs_read.xml in <XOG_Install_Directory>/xml folder.

    It will xogout OBS structure and attached instances.