BEx – Query Designer

Log into the BEx Query Designer -  Create a new query – select a InfoProvider – Drag Key Figure to Column & Drag Dimensions to Row.

Free Characteristic -  If you put the dimension; the report will show overall summarize result.  You will have capability to drill down

Default Values – If you want to put restriction on Data Set coming from the Dimension when displaying Query; you can define restrict here on the respective dimension by Right Clicking on the dimension and select Restriction based on History, Single Values, Value Ranges, Variables(across InfoProvider)