Page History

Anchor
top top

Table of Contents
class contents

Overview

Styleclass
Class topLink

...

View Summary

The view summary allows you to browse the contents of a view without editing it. From the summary you will be able to access information about the purpose of the view and target audience, the columns and tables that are included in the view, view a sub set of the data produced, access the generated SQL and export the view metadata and XML file.

General Information

Styleclass
Class topLink

...

View Summary

The general tab provides a View summary, including the purpose and the intended audience, and the option to edit this information using the Edit Metadata link.

...

When the view is in draft mode you are also presented with the option to change the data source, this is useful when you need to switch from a development connection to production. Click on the Change link next to the data source and you will be able to select one of the same type to redirect to.

Columns

Styleclass
Class topLink

...

View Summary

The columns tab provides summary information of all the columns that are included in the view.

Data

Styleclass
Class topLink

...

View Summary

The data tab shows the first 20 rows of data returned from the data source. This allows you to verify that the view does return the anticipated result set.

SQL

Styleclass
Class topLink

...

View Summary

The SQL tab displays the SQL that has been generated as a result of the business rules implied through the entity relationship diagram and the columns that have been created. You can use this tab to verify that the view you have built is generating the expected output SQL.

Elements

Styleclass
Class topLink

...

View Summary

The elements tab provides a list of all source tables or views used in the view. The source database name, its description and alias are provided. In addition any joins and conditions are specified in detail.

Reports

Styleclass
Class topLink

...

View Summary

This tab provides a list of all reports that use this particular view. This is useful when you want to know what reports may be effected by changes made to a view.

Cache

Styleclass
Class topLink

...

View Summary

This tab provides view caching information. You can use this tab to populate the data manually and view the caching settings.

 

horizontalrule

Styleclass
Class topLink
View Summary

 

...