Clarity

  • 1.  Number of projects created using templates

    Posted May 09, 2013 01:13 AM
    Hi,

    Currently we have three templates

    1 - Template Name: TI Projects / Code: ti_projects
    2 - Template Name: External Projects / Code: external_projects
    3 - Template Name: Other Projects / Code: other_projects

    I know that there are the following tables:

    INV_INVESTMENTS
    INV_PROJECTS
    SRM_PROJECTS
    SRM_PROJECTS_PROJ_V
    ODF_CA_PROJECT

    I noticed that in INV_PROJECTS there a column named 'IS_TEMPLATE' (1 corresponds Template, 0 not ...), however I'm not able how I can get the relationship to known count of projects that were created using specific template.

    I want to build a custom report with the following information:

    Template Name | Number of Projects |

    TI Projects | 300 |
    External Projects | 188 |
    Other Projects | 200 |

    Where I can to find this relationship?

    Thanks you,
    Juan


  • 2.  RE: Number of projects created using templates

    Posted May 09, 2013 04:45 AM
    Don't think that the system captures that data out-of-the-box. :sad

    You could introduce a custom attribute to your project, set it in the templates and then that would be copied to the projects created from that template - this is not going to help you with any historic data though, only newly created projects.


  • 3.  RE: Number of projects created using templates

    Posted May 09, 2013 04:57 AM
    See also
    Is there any way to know which template was used to create a project?
    98259075

    Gurjeet:
    As Chris mentioned we can think different options for the Future Data but it doesn't look like Clarity contains any direct information for already created projects from templates.
    If it is really urgent and you are happy to spend time then below count queries can help you to eliminate some data.

    Select Count(*) from prdependency where prpredtaskid in (select prid from prtask where prprojectid = ???? ) ;

    Select count(*) from prtask where prprojectid = ???;

    For future you can use Chris advice.

    Martti K.


  • 4.  RE: Number of projects created using templates

    Posted May 09, 2013 09:57 AM
    1 - Template Name: TI Projects / Code: ti_projects
    2 - Template Name: External Projects / Code: external_projects
    3 - Template Name: Other Projects / Code: other_projects

    In case if you have defined different set of tasks (it should be unique for each template) for the above 3 different templates then based on the task set you can identify the template and then you can build an report.
    But if users have modified the WBS with different template then it will not be accurate.

    cheers,
    sundar


  • 5.  RE: Number of projects created using templates

    Posted May 10, 2013 06:48 AM
    Try with this query:

    select inv.NAME, count(*)
    from ODF_CA_PROJECT odf left outer join INV_INVESTMENTS inv on odf.OBJ_METHODOLOGY=inv.ID
    where odf.OBJ_METHODOLOGY is not null
    group by inv.NAME

    Regards


  • 6.  RE: Number of projects created using templates

    Posted May 10, 2013 08:06 AM
    Does that work with user created templates and not just the templates that come with the content pack.

    What about using non-template projects as templates?

    Martti K.


  • 7.  RE: Number of projects created using templates

    Posted Apr 11, 2014 03:24 PM

    See also
    TEC600149

    Title:  Clarity: How to identify template used in the created project?

    https://support.ca.com/irj/portal/anonymous/kbtech?docid=600149

     

    Martti K.