Report View Reference
There is no official report view classification, but because several views contain information directly related to SMS reporting, they have been grouped together and will be referred to as the report views.
Report Views
The report views contain information such as report names, report IDs, dashboard ID, which reports are part of a dashboard, which column to use when navigating to linked reports, the SQL query for the report, and so forth. Most often these views will be joined to other report views by using the ReportID column and possibly to other views by using the SecurityKey column. The report views are listed and described in the following table.
Report View |
Description |
|---|---|
v_Report |
Lists all reports in the SMS hierarchy by report ID, security key, report name, report description, report category, SQL query, and so forth. The view can be joined to other views by using the ReportID or SecurityKey columns. |
v_ReportCategory |
Lists the report categories and object key for the category. It is unlikely that this view will be joined to other views. |
v_ReportDashboard |
Lists all reporting dashboards in the SMS hierarchy by dashboard ID, dashboard name, column count, and the vertical limit for each row. The view can be joined to other views by using the DashboardID column. |
v_ReportDashboardReports |
Lists all reporting dashboards in the SMS hierarchy and associated reports by dashboard ID and report ID. The view can be joined to other views by using the DashboardID or ReportID columns. |
v_ReportDrillThroughColumns |
Lists all reports in the SMS hierarchy by report ID and the column that will be used when drilling down into a linked report. This view can be joined to other views by using the ReportID column. |
v_ReportParameter |
Lists all reports in the SMS hierarchy and associated prompt information including variable name, prompt text, if the prompt can be empty, what the default variable value is, and the SQL query for the prompt, when applicable. This view can be joined to other views by using the ReportID column. |