This page explains how to get the list of reports defined on central site and their parameters



Release
Yes/No
8.0.x(tick)
7.3.x(tick)
7.2.x(tick)
7.0.x(tick)



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.