Bi L3 Bex Query Designer Unit 4

BEx Query Designer

Unit 4: Properties and Attributes of Characteristics

7/17/2007

Properties of Characteristics •No Display •Key and text •Text •Key •Text and You Key can use this function to normalize key figure values to a specific characteristi c.

•Always •Never •With Only One Value

One of the following, sorted by key or name: •The characteristic itself •All attributes of the characteristic

Slide 2

Attributes Characteristics can be displayed in more detail through attributes. Example: You can assign Country and Region to the Sold-to party characteristic. Display vs. Navigation? Display attributes can be shown in the report as a drilldown. Navigation is not possible. Navigational attributes enable you to view current data with characteristic values from the past or view past data with current characteristic values. Slight loss in query performance may occur. Slide 3

Hierarchical Display in Reports Display the characteristics included in the query definition as a hierarchy.

Select external hierarchy as a display hierarchy for a characteristic in the query definition.

Slide 4

Properties of the Display Hierarchy Expand to Level To determine the hierarchy level to which the hierarchy is expanded in the report. In the “U” column, put a check in the checkbox and enter the required value. Position of Lower Level Nodes Put a check mark in the “U” column and choose whether the subordinate nodes are positioned above (Up) or below (Down) a superior node. Values of Posted Nodes Put a check mark in the “U” column and choose whether you want to Display or Suppress the values of posted nodes. Nodes with Only One Lower-Level Node Put a check in the checkbox and choose whether you want to Display or Suppress nodes with only one lower level node. Slide 5