10. A combination of characteristics and key figures can be displayed in any desired order by:
a) Activating the download scheduler
b) Switching a query definition to tabular mode
c) Placing key figures in the rows section of a query definition
d) Using scissors and duct tape
An under-utilized tool within the BW query designer is the "table display" icon. Switching the format of a query definition to tabular mode allows a user to specify a specific order of columns for each characteristic and key figure found in the query definition. It also allows characteristic attributes to be displayed in any column position. If tabular mode is not selected, all of the characteristics in a query are displayed first, with the key figures displayed in subsequent columns.
This was first published in April 2006