Clarity PPM

Expand all | Collapse all

upgraded clarity from version 12.04 to 13.3 problem with portfolio tables - unsolved!!

  • 1.  upgraded clarity from version 12.04 to 13.3 problem with portfolio tables - unsolved!!

    Posted 07-20-2015 10:35 AM

    we have multiple queries that stopped working due to the changes made in the database regarding the portfolio tables. We now are struggeling to find all the info (fields) in the new structure.

     

    one of our problems is; we don't know where to locate the field pfm_portfolios.bdgt_cst_total in the following query:

     

    SELECT DISTINCT u.unique_name AS kpl,
      (pf.bdgt_cst_total) PFBUDGET
    FROM (prj_obs_associations a
    RIGHT JOIN prj_obs_units u
    ON a.unit_id = u.ID)
    INNER JOIN prj_obs_types t
    ON u.type_id = t.ID
    INNER JOIN inv_investments p
    ON a.record_id = p.ID
    INNER JOIN pfm_Investments pfc
    ON p.id = pfc.investment_id
    INNER JOIN pfm_portfolios pf
    ON pfc.PORTFOLIO_ID = pf.ID
    WHERE t.unique_name = 'obs_m_sth'
    AND a.table_name = 'SRM_PROJECTS'
    AND pfc.ODF_OBJECT_CODE = 'project'
    AND TO_CHAR (pf.start_date, 'YYYY') = TO_CHAR (SYSDATE, 'YYYY');

     

    can you help us?



  • 2.  Re: upgraded clarity from version 12.04 to 13.3 problem with portfolio tables

    Posted 07-20-2015 12:30 PM

    Hi Pega5u5,

     

    Please have a look at the link

     

    https://support.ca.com/cadocs/0/CA%20Clarity%20PPM%2013%202%2000%20%20On%20Premise%20-TRK/Bookshelf_Files/HTML/xog/index.htm?toc.htm?1387015.html

     

    For example pfm_portfolios.bdgt_cst_total  will map to CAP_SCENARIOS.BDGT_CST_TOTAL

     

    Hope this helps.

     

    Regards

    Suman Pramanik



  • 3.  Re: upgraded clarity from version 12.04 to 13.3 problem with portfolio tables

    Posted 07-27-2015 09:18 AM

    but then, how do you join the PFM_Portfolio table to this CAP_SCENARIO table?

     

    also the link you provided, talks about xog. and i'm missing the link to the portfolio tables.