New View Element Dialog
The New View Element dialog appears when you,
- Do any of the following in the Business View Editor:
- Select Menu > Insert > Group/Aggregation/Detail.
- Select New Group, New Aggregation or New Detail on the toolbar.
- Right-click the business view or a category and select New View Element from the shortcut menu.
- Right-click a business view or a category and select New View Element on the shortcut menu in the Catalog Manager resource tree.
It helps you to add a new view element into a business view, and consists of the following tabs:
Applies all changes and closes the dialog.
Does not retain changes and closes the dialog.
Displays the help document about this feature.
Specifies properties of the view element. See the dialog.
Specifies the display name of the view element which is intuitive to the end user.
Specifies the mapping name of the field to which the view element is mapped. Select to select the field.
Specifies the type of the view element.
Group objects are the view elements that will become the basis for analyzing data in a report. They characteristically return text data or dates. For example they may return items like country, state and year to use for grouping data in reports. Group elements can also show detail data for a table. If you have any question if something should be a detail or a group make it a group. A group can be used everywhere a detail can be used.
Aggregation objects are numeric view elements that are calculated at the time the report runs. The values they return are dependent on the group objects which they are used with. For example you may want a sales total by year. They are also used to count the number of records or the number of unique values. For example you may want a count of all orders and a count of all unique customers. Any value which is null will not be counted so be sure when using count to pick a field that will never be null.
Detail objects provide additional information. They can be bound to DBFields and formulas. Detail objects are not used for analysis in charts and crosstabs but are useful in tables to show detail information such as addresses and phone numbers.
Available only when the type of the view element is defined as Aggregation. It specifies the function for the aggregation object. For details about each function, see Math Functions.
Available only when the type of the view element is defined as Aggregation. If checked, you can create a custom aggregation by writing a formula.
Opens the Formula Editor to compose a formula using resources in the current business view, which can return an aggregation.
Specifies the tooltip of the view element which will be shown when you hover the mouse pointer over the element in the Resources panel of Web Report Studio or the Data panel of Page Report Studio.
Specifies the description of the view element.
Specifies user accessibility to members of the group objects in all the business views in current data source. See the tab.
For details about options in the tab, refer to Edit Business View Security dialog.