How to assign dimensions in query designer as there are different different dimensions like Company code,company area,company code,version,data structure,version ?
It all depends on your requirement how to use the dimensions in rows or columns or free chars or defaults.
If you add the Comp Code in rows you can see the Comp Code wise data by default in your query output and others dimensions in Free Characters which can be used for later point of analysis in the report.
Just drag and drop the required dimensions to rows and free chars to create the initial layout/structure of your report.
It depends on the QUERY that you are going to create. Normally users will give you the design of their reports and you are just going to replicate it.
So normally, keyfigures go in the COLUMN part and the infoobjects in the ROW part. Then some of the infoobjects that will be used to do slice and dice in the report is being put in the FREE CHARACTERISTICS.
What do you mean? You can just drag the fields in the ROW, COLUMN, or FREE CHARACTERISTICS then just play with them after generating the initial layout of your report. Did I get your question?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.