This page explains how to get the list of reports defined on central site and their parameters
Release | Yes/No |
---|---|
8.0.x | |
7.3.x | |
7.2.x | |
7.0.x |
Run this query on your central site to get list of reports defined on the central site and the used parameters
SELECT vr.name AS "Report Name" , vrs.section_name AS "Section Name" , vrs.section_id AS "Section Internal Type", (SELECT vpt.value FROM viewer_parameters vpt, viewer_parameters vp WHERE vpt.component_id = 'ENGLISH' AND vpt.id LIKE vp.value AND vp.id = 'PANEL_REPORTING_CART' AND vp.component_id = vrs.section_id ) AS "Section External Type", vrp.id AS "Parameter ID" , CASE vrp.id WHEN 'object' THEN (SELECT ob.object_name FROM dss_objects ob WHERE TO_CHAR(ob.object_id) = vrp.value ) WHEN 'system' THEN (SELECT ob.object_name FROM dss_objects ob WHERE TO_CHAR(ob.object_id) = vrp.value ) WHEN 'bcrit' THEN (SELECT dmt.metric_name FROM dss_metric_types dmt WHERE TO_CHAR(dmt.metric_id) = vrp.value ) WHEN 'tcrit' THEN (SELECT dmt.metric_name FROM dss_metric_types dmt WHERE TO_CHAR(dmt.metric_id) = vrp.value ) WHEN 'metric' THEN (SELECT dmt.metric_name FROM dss_metric_types dmt WHERE TO_CHAR(dmt.metric_id) = vrp.value ) ELSE vrp.value END AS "Parameter Translated Value", vrp.value AS "Parameter Raw Value" FROM viewer_report_parameters vrp, viewer_report_sections vrs , viewer_reports vr WHERE vrp.report_section_id = vrs.id AND vrs.report_id = vr.id ORDER BY vr.name, vrs.section_offset
Here a sample of query result
Report Name | Section Name | Section Internal Type | Section External Type | Parameter ID | Parameter Translated Value | Parameter Raw Value |
TEST_EGA | SECTION1 | REPORTING_PORTFOLIO_2_1 | Business Map | object | NULL | -1 |
TEST_EGA | SECTION2 | REPORTING_PORTFOLIO_2_1 | Business Map | object | E2E_CM | 2 |
TEST_FLEX | ITEMS-1 | REPORTING_AUTO_ITEMS | FlexReport - Items | weight | -1 | -1 |
TEST_FLEX | ITEMS-1 | REPORTING_AUTO_ITEMS | FlexReport - Items | app | -1 | -1 |
TEST_FLEX | ITEMS-1 | REPORTING_AUTO_ITEMS | FlexReport - Items | metric | NULL | -1 |
TEST_FLEX | ITEMS-1 | REPORTING_AUTO_ITEMS | FlexReport - Items | bcrit | NULL | -1 |
TEST_FLEX | ITEMS-1 | REPORTING_AUTO_ITEMS | FlexReport - Items | dateinit | 2.01009E+11 | 2.01009E+11 |
TEST_FLEX | ITEMS-1 | REPORTING_AUTO_ITEMS | FlexReport - Items | tcrit | NULL | -1 |
TEST_FLEX | ITEMS-1 | REPORTING_AUTO_ITEMS | FlexReport - Items | cost | -1 | -1 |
TEST_FLEX | ITEMS-1 | REPORTING_AUTO_ITEMS | FlexReport - Items | system | E2E_CM | 2 |
TEST_FLEX | ITEMS-1 | REPORTING_AUTO_ITEMS | FlexReport - Items | dateend | 2.01009E+11 | 2.01009E+11 |
TEST_FLEX | ITEMS-1 | REPORTING_AUTO_ITEMS | FlexReport - Items | critical | -1 | -1 |
TEST_FLEX | ITEMS-1 | REPORTING_AUTO_ITEMS | FlexReport - Items | status | 1 | 1 |
This table shows that:
- The central contains 2 reports TEST_EGA and TEST_FLEX
- The TEST_EGA report contains 2 sections SECTION1 and SECTION2
- The TEST_FLEX EGA report contains on only one section ITEMS-1
- Each section of the report TEST_EGA is based on only one parameter called object
- The parameter of the report TEST_FLEX are weight, app, metric, bcrit, dateinit, tcrit, cost system, dateend, critical and status
Example of incoherent parameters
You can see also, for SECTION1 on the TEST_EGA report, the object parameter is set to NULL where it’s set the E2E_CM in SECTION2: So the SECTION1 will be empty (No result reported) since no parameter value is defined.