Add dimensions to rows and columns
3 ways to add rows/columns into the table :
- Click on
to show the right Analysis Panel - Go to the Analysis Tab
- Select the wanted dimension and right click on it
- Select Add to Rows or Add to Columns
- Click on to show the right Analysis Panel
- Go to the Analysis Tab
- Select the wanted dimension and right click on it
- Drag & drop the dimension to the rows or column panel
- Click on to show the right Analysis Panel
- Go to the Analysis Tab
- Select the wanted dimension and right click on it
- Drag & drop the dimension from the right panel directly into the cross table and drop it where you want to add it. A red line shows where it will be added.
Remove dimension from rows and columns
3 ways to remove rows/columns into the table :
In the Analysis window, right click on the dimension and select Remove.
Drag and drop from the "Rows" or "Columns" panels to the left panel.
Drag and drop from the crosstable to the Analysis window
Add or remove measures(key figures)
To do this, you can't just drag and drop like dealing with a dimension, you need to right click on Measures and then "Filter by member".
Swap/Replace a dimension by another
Solution 1: Select the Dimension in the Display Panel, drag and drop to the column you need to switch.
Solution 2: Select the dimension in the crosstab, drag and drop to the dimension you need to switch
Change order of dimensions
Solution 1: Select the Dimension in the Display Panel, drag and drop before the dimension you need to change.
Solution 2: Select the Dimension, drag and drop before the column you need to change.
Solution 3: Right click on the Dimension in the display panel, select "Move In front of" and select the second dimension.
Change order of key figures
On some queries, we can't change the order, for example, the training query "Resort Booking Evolution" on PQ1.
But on some other queries, like "Shipment costs analysis new(core query)", we can, in the same way as changing order of dimensions.
But we don't know where this is configurated so far.
Display Attributes ("Master data")
Some BW dimensions have "Attributes" that can be displayed. The "Attributes" basically correspond to "Master data" in SAP ERP.
To display attributes :
- From available field in Design Panel
- Expand the Dimension and Attribute Node
- Drag and drop Attribute to the Row. Use [CTRL] for Multiple selection
Difference between dimension and attributes
There are some difference between dimensions and attributes :
- You cannot display an attribute without displayed the attached dimension
- You cannot filter on the attributes values
- You cannot sort by attribute
Add a customized key figure by adding a calculation
- In Design Panel / Analysis tab, select on a key figure( or measure), right click, then select "Add Advanced Calculation".
- You can create your own calculation by "Insert Member" and "Insert Function".
Syntax is correct so possible to click Ok button 
Syntax is incorrect , you need to correct it
The best way to get IT support is to use the new
Service One Platform.