Editing Objects Properties

For Excel, Text and Free-Hand SQL data sources, you previously changed your object properties in the Query Panel. As this Query Panel was replaced to make it unique for all data sources, you now change these properties after having run your query.

Changing the properties in this way has also been extended to other data sources. The precise properties that can be changed depend on the data source and are listed in the following table:

Once the query has been run, select an object in the Main Side Panel → Document Dictionary tab. The properties of object are displayed in the Build Side Panel → Object Properties tab. You can modify these properties and click Apply to validate your changes. The Document Dictionary tab is updated to reflect these changes.

Changing the qualification, the type, or the aggregation of an object coming from an Excel, Text and Free-Hand SQL data sources purges the corresponding query.

You can also modify some properties of an object coming from Universes, Web Intelligence Documents, SAP HANA, SAP BW or OData locally, i.e., without having to do it in the data source.

To distinguish local change you made from the semantic defined by the data source, an icon is displayed beside the object to highlight that it has been modified compared to its data source. Hover the mouse over the object to show its previous and new values. Unselect the Display Info icon checkbox in the View Modes and Settings menu to hide this icon. In the Object Properties tab, the Reset button is available beside each changed property. Click it to restore the previous values or click the Revert button on the bottom of the tab to reset them all. In both cases, click Apply to validate your changes.

The context of such changes is the data source: all queries based on this data source benefit from them.

You can define a display format for numeric or date/time values directly on the object rather than defining it for each table or chart in which it is used.

In Design mode, select an object in the Main Side Panel → Document Dictionary tab. In the Build Side Panel → Object Properties tab, click the Edit Format link to open the Display Format dialog box. Assign a format to this object and click OK.

A preview sample using this format is displayed in the Build Side Panel → Object Properties tab. To harmonize the user interface, the same Edit Format link that opens the Display Format dialog box is also used when defining a formatting rule.

The format defined at object level is not only used for tables and charts, but also for input controls that use this object.

The display format applying in order of priority to a value is the one defined in:

• A formatting rule, if any.
• A table or a chart, if any.
• An object, if any.
• A universe, if any, in case the object is defined in a universe.

Display Format Dialog Box

The Display Format dialog box has been overhauled to better manage custom and assigned formats.

To create a custom format, select an existing (predefined or custom) format, and click Add Custom Format. The selected format is used as a model for the new custom format. In the New Custom Format dialog box, select the data type in the Type drop-down menu. Depending on your selection, you may enter the tokens that define values for:

• Positive, negative, null, or undefined values, if the selected data type is Number.
• Positive or undefined values, if the selected data type is Date/Time.
• True, false, or undefined values if the selected data type is Boolean.

It is not yet possible to edit a custom format, but you can:

• Hover the mouse over a custom format to display its definition in a tooltip.
• Explicitly unassign a format from the selected formatting rule, table, chart, or object by selecting the No Format is Explicitly Assigned radio button.
• Delete custom formats that are no longer used by clicking the Delete button beside a custom format in the Custom category. If this button is not displayed, the custom format is still used in the document and cannot be deleted.