Clarity

  • Private Community
 View Only
Back to discussions
Expand all | Collapse all

Clarity PPM v15.6.1 - Creating Advanced Reporting Adhoc view to display latest status report

  • 1.  Clarity PPM v15.6.1 - Creating Advanced Reporting Adhoc view to display latest status report

    Posted Oct 24, 2019 01:33 AM
    Hello Everyone,
    I am trying to create a simple adhoc view in advanced reporting. I want to display a table of few custom fields from the latest status report from selected projects (based on OBS).

    It is quite straightforward to drag and drop the fields I need and to get the format and scheduling. What I am struggling with is, how to retrieve only the latest status report from each project. I tried using calculated fields option but the "validate" button is disabled. 

    Can someone please help me with this. 

    Appreciate your time and help!

    Regards,
    Poonam Madan


  • 2.  RE: Clarity PPM v15.6.1 - Creating Advanced Reporting Adhoc view to display latest status report
    Best Answer

    Posted Oct 24, 2019 07:18 PM
    Hi Poonam, 

    That might be tricky with the out of the box domain, as you cannot edit the SQL query of the adhoc report. A similar thread was discussed earlier: https://community.broadcom.com/communities/community-home/digestviewer/viewthread?MID=786094

    ​Alternatively, you may need a custom domain(copy of ootb) and make the change in domain query in the way you need. Otherwise, this might be straightforward if you are doing this through a studio report.

    Regards

    ------------------------------
    Praneeth Desur
    Clarity PPM Specialist
    Toyota Finance Australia
    ------------------------------

    Original Message