Structure Properties 

Use

In the Structure Properties dialog, you can change the description of a structure and get information on the technical name and the last changes made to the structure.

Features

Technical name

If the structure has been saved as a reusable structure, the technical name of the structure is displayed here and you can no longer change it.

You can enter a technical name for local structures. However, this is optional.

Note that the technical name must be unique across all queries.

For access from external interfaces (such as Crystal Reports, from URLs or using OLE DB for OLAP), a technical name is necessary for structures, since the structure is considered a table field and has to be uniquely accessible. If you do not enter a technical name, the unique ID (UID) is used for access from external interfaces for uniquely identifying the structure. However, the UID has 25 characters, which can lead to problems when you change queries.

You can change the technical name. When you do so, a warning appears that tells you that when you use the structure in external interfaces, the references can be destroyed.

Description

The name of the structure appears automatically here. You can overwrite this text.

Applying zero row/column suppression to this structure also

If you made a setting for zero row/column suppression in the query properties, this setting is not transferred automatically to the structures that you use in the query. If you do not want to suppress rows or columns that contain zeros for this structure, select Also Apply Zero Row/Column Suppression to This Structure.

For more information about the setting options for Suppressing Zero Rows/Columns, see Query Properties.

Last changed

This is where you can see details of the owner and person who last changed the structure, as well as the corresponding data and time that the structure was changed. This information can be useful since structures deal with reusable objects.

Activities

Select the structure and choose Properties from the context menu (secondary mouse click). The Structure Properties dialog box appears.