Overview

top

The Report Details button, found on an active report's menu bar, allows you to view a useful collection of information on the report.

Report Details

top

When you click on the Report Details button you will be presented with a window consisting of three tabs, the first of which is the Report Details tab. On this tab you will be presented with the following:

Report Details

 

Name

Name of the report, supplied by the report writer.

Description

Description of the report, supplied by the report writer.

Category

The category the report is currently stored in.

Sub Category

The sub category the report is currently stored in.

Expert

If the sub category requires approval, provides the assigned user or group.

Update Type

Edit Existing Report

Report Template

Display option of the report, Eg. Table, Table and Chart, etc.

Max Rows Returned

Max number of rows to be returned in the report. Set at the source connection and confirmed on the report data page. Eg. 10000

Source System

The source connection the report is based on.

Created By

Method of report builder used. Eg. Drag and Drop Builder

View Name

The view the report is based on.

View Description

Description of the view the report is based on. Provided by the view builder.

Report URL

URL generated for the report.

Report Stats

 

Run Count

Number of times the report has been run.

Average Run Time

Average length of time the report takes to run.

Last Run

The length of time the report took to run last.

Modified

Last modified date and time.

Access Rights

 

Level of Access

Access setting applied to the report sub category.

Column Definitions

top

The second tab in the Report Details window contains information on the fields used in the report.

Each field will have the following information listed:

Property

Description

Field

Name of the field, defined at the view level.

Group

Name of the category the field is attached to in the view.

Type

Type of field (Metric or Dimension)

Data Type

Field type defined in the source database

Description

Description of the field, defined at the view level.

SQL Statement

top

The third tab in the Report Details window contains the SQL generated by Yellowfin for the report. This tab can be restricted through Role Permissions so that only advanced users can view it if necessary. This tab also contains an Export SQL button, allowing you to export the query to a .sql file.

 

top