Clarity

  • Private Community
Back to discussions
Expand all | Collapse all

Looking for a query that shows a task heirarchy from the data warehouse

  • 1.  Looking for a query that shows a task heirarchy from the data warehouse

    Posted Jul 30, 2018 03:51 PM

    Does anyone have a simple query that project and task with task heirachy?



  • 2.  Re: Looking for a query that shows a task heirarchy from the data warehouse

    Broadcom Employee
    Posted Jul 30, 2018 09:32 PM

    Hi julian926,

     

    Unfortunately, I don't have a sample query that you want.

     

    I found that Project Management Domain has below columns.

    - Projects->Tasks->General->WBS Level

    - Projects->Tasks->General->WBS Sequence

    You will be able to use above columns to get task hierarchy.

     

    For example, I have task1, summary01, summary02, task2 as below hierarchy.

     

    I created simple Adhoc view like as below. I understand task hierarchy by using WBS Level and WBS Sequence. 

     

    If you want to access DWH table directly, DWH_INV_TASK_HIERARCHY table maybe useful for task hierarchy.

    You will use PARENT_TASK_KEY, CHILD_TASK_KEY columns to get task hierarchy.

     

    SQL> desc DWH_INV_TASK_HIERARCHY


    Name                                                Null?               Type
    -----------------------------------------        --------              ----------------------------
    INVESTMENT_KEY                         NOT NULL       NUMBER
    PARENT_TASK_KEY                       NOT NULL       NUMBER
    CHILD_TASK_KEY                           NOT NULL       NUMBER
    DW_UPDATED_DATE                      NOT NULL       DATE

     

    Regards,

    SHoichi