Share this page

# MREQ_OPENED_CLOSED_BY_DETAIL_D/M

Use this view to assess daily request throughput, and to help indicate trends in open requests over time. These views provide information for request submission and completion activity (throughput), broken down by:

- day or month

- combinations of request type, application, department, priority, and assigned-to user

Thus allowing access to more information than MREQ_OPENED_CLOSED_BY_DETAIL_D/M or MREQ_OPENED_CLOSED_BY_TYPE_D/M .

Results from a query of this view contain records only for days or months on which there were requests opened or closed.

Sample

This creates a report to examine throughput of all work order request types for the IT development department:

    SELECT activity_date,
           application,
           priority,
           total_opened,
           total_closed,
           num_still_open,
           avg_comp_time_opened,
           avg_comp_time_closed
    FROM   mreq_opened_closed_by_detail_d
    WHERE  activity_date BETWEEN '01-APR-01' AND '05-APR-01'
    AND    request_type_name = 'Work Order'
    AND    department = 'Development'
    ORDER BY activity_date;

To get a breakdown by month, replace `activity_date` with `activity_month` and `mreq_opened_closed_by_detail_d` with `mreq_opened_closed_by_detail_m`.

Results

                                                             Avg     Avg
                                                             Num    Comp    Comp
                                             Total   Total Still    Time    Time
    Date               Application Priority   Open  Closed  Open    Open  Closed
    --------- -------------------- -------- ------ ------- ----- ------- -------
    01-APR-01 Manufacturing        Normal        0       2     0           26.06
    01-APR-01 Financials           Normal        0       2     0           31.07
    01-APR-01 Work-in-process      Normal        0       2     0           22.74
    02-APR-01 Documentation        Normal        0       1     0           21.78
    03-APR-01 Bill-of-materials    Low           0       1     0           41.01
    03-APR-01 Bill-of-materials    Normal        0       1     0           26.09
    04-APR-01 Bill-of-materials    Low           0       1     0           47.35
    04-APR-01 Bill-of-materials    Normal        0       2     0           20.60
    04-APR-01 Configuration        Normal        0       1     0           63.18
    04-APR-01 Workflow             Low           0       2     0           20.70
    05-APR-01 Manufacturing        Low           0       2     0           36.90
    05-APR-01 Work-in-process      Normal        0       1     0            4.35

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: