VLDB Properties at the Report Level

The report level contains numerous VLDB properties. The most commonly used are listed below. The top level of the list indicates the folder in the VLDB Properties dialog box in which the property is found.

• Joins:
• Cartesian Join Warning
• Full Outer Join Support
• Preserve All Final Pass Result Elements
• Preserve All Lookup Table Elements

  The term "cross join" is used interchangeably with Cartesian join in these sections.

• Metrics:
• Null Check
• Zero Check

  The metric properties above can also be set at the metric level, although the setting at the report level overwrites it. These properties are described in VLDB Properties at the Metric Level.

• Pre/Post Statements:
• Report Post Statement
• Report Pre Statement
• Table Post Statement
• Query Optimizations:
• Sub Query Type
• WHERE Clause Driving Table
• Select/Insert:
• Attribute and Attribute Form Selection Option for Intermediate Passes Properties
• Attribute and Attribute Form Selection Option for Intermediate Passes Properties
• GROUP BY ID Attribute
• GROUP BY Non-ID Attribute
• SQL Hint
• UNION Multiple INSERT
• Tables:
• Drop Temp Table Method
• FallBack Table Type
• Intermediate Table Type
• Table Option and Table Space Properties
• Table Option and Table Space Properties

  For information on other report level VLDB properties, refer to the System Administration Guide.

Accessing Report VLDB Properties

To set these properties, open the report in the Report Editor or Report Viewer. Select VLDB Properties from the Data menu to access the VLDB Properties (Report) dialog box. The properties are saved in different folders, as indicated in the previous list.

The following settings are advanced properties which are hidden by default:

• Full Outer Join Support
• Preserve All Final Pass Result Elements
• GROUP BY ID Attribute

To access them, in the VLDB Properties (Report) dialog box, choose Tools > Show Advanced Settings.