Add 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
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 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

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

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.

Some BW dimensions have "Attributes" that can be displayed. The "Attributes" basically correspond to "Master data" in SAP ERP.

To display attributes :

Difference between dimension and attribures

There are some difference between dimensions and attributes :