Drag and Drop fields in Tabular Reports
Business Objects Reporting BOBJ (Pilot)
WEBI Reports Drag and Drop
Drag and Drop fields in Tabular Reports A dimension characteristic or measure can be added on a tabular report in Design mode using drag and drop in a Web Intelligence report.
Drag and Drop a field in a blank column A dimension characteristic or measure can be drag and dropped on a table blank column in a Web Intelligence report in Design mode. 1. Open a Web Intelligence document in Design mode. 2. Select a column in the report and then insert a blank column either left or right side using the context menu item ‘Insert’ or from Table Layout subtab in Report Elements tab.
3. Select the dimension attribute or measure from Available Objects panel that you want to add to the report.
8/7/2015
OSC
Page |1
Business Objects Reporting BOBJ (Pilot)
WEBI Reports Drag and Drop
4. Press and hold the left mouse key and keep dragging towards the blank column. You will notice a rectangle icon moving along with the mouse cursor saying drop here to replace cell. 5. Also notice the rectangular empty boxes appearing in the column header directing you with the additional information that the dropped column will fill in the space.
If you keep moving the cursor inside all corner of this box with still holding the left mouse key, you will see the message inside rectangle icon
8/7/2015
OSC
changes to
Page |2
Business Objects Reporting BOBJ (Pilot)
WEBI Reports Drag and Drop
drop here to replace or insert cell. In this example, we are going to choose replace cell to replace the blank column. But if you are dragging an object and dropping near an existing nonblank column, before you release the mouse key, please read this icon message carefully and drop it. If your icon says replace cell, it means it is replacing the current column. If the icon says insert cell which means you are inserting either before or after the cell depending on your cursor location.
6. Drop inside the rectangle box or inside the cell in the column with the drop icon message still says ‘Drop here to replace cell’.
Notice the new selected field attribute occupies the blank column with the #REFRESH value in the cells. 7. Repeat from step 2 if you want to add more columns. 8. Refresh the report again to see the correct values in the drag and dropped column.
8/7/2015
OSC
Page |3
Business Objects Reporting BOBJ (Pilot)
WEBI Reports Drag and Drop
Drag and Drop a field near non-blank columns A dimension characteristic or measure can be drag and dropped on a table column that will insert or replace in a Web Intelligence report in Design mode. 1. Open a Web Intelligence document in Design mode. 2. Select a dimension attribute or measure from Available Objects panel that you want to add to the report.
3. Press and hold the left mouse key and keep dragging towards the blank column. You will notice a rectangle icon moving along with the mouse cursor saying drop here to replace cell. 4. Also notice the rectangular empty boxes appearing in the column header directing you with the additional information that the dropped column will fill in the space.
8/7/2015
OSC
Page |4
Business Objects Reporting BOBJ (Pilot)
WEBI Reports Drag and Drop
If you keep moving the cursor inside all corner of this box with still holding the left mouse key, you will see the message inside rectangle icon changes to drop here to replace or insert cell. But if you are dragging an object and dropping near an existing non-blank column, before you release the mouse key, please read this icon message carefully and drop it. If your icon says replace cell, it means it is replacing the current column. If the icon says insert cell which means you are inserting either before or after the cell depending on your cursor location.
In picture above, a new column that will be inserted next to Job Pay area on the right side is depicted. 5. Now drag and drop near the right side of the rectangle box or inside the cell in the column with the drop icon message still says ‘Drop here to insert cell’.
8/7/2015
OSC
Page |5
Business Objects Reporting BOBJ (Pilot)
WEBI Reports Drag and Drop
Notice the new selected field attribute occupies the blank column with the #REFRESH value in the cells. 6. Repeat from step 2 if you want to add more columns. 7. Refresh the report again to see the correct values in the drag and dropped column.
Scenarios Insert a column on the left side To insert a column on the left side of Job Pay Area column, drag and drop when you see a picture like this:
Replace a column on the right side To replace the column Job Pay Area column, drag and drop on the middle as you see a picture like this:
8/7/2015
OSC
Page |6
Business Objects Reporting BOBJ (Pilot)
WEBI Reports Drag and Drop
Insert a column on the right side To insert a column on the right side of Job Pay Area column, drag and drop when you see a picture like this:
8/7/2015
OSC
Page |7
WEBI Reports Drag and Drop
Drag and Drop fields in Tabular Reports A dimension characteristic or measure can be added on a tabular report in Design mode using drag and drop in a Web Intelligence report.
Drag and Drop a field in a blank column A dimension characteristic or measure can be drag and dropped on a table blank column in a Web Intelligence report in Design mode. 1. Open a Web Intelligence document in Design mode. 2. Select a column in the report and then insert a blank column either left or right side using the context menu item ‘Insert’ or from Table Layout subtab in Report Elements tab.
3. Select the dimension attribute or measure from Available Objects panel that you want to add to the report.
8/7/2015
OSC
Page |1
Business Objects Reporting BOBJ (Pilot)
WEBI Reports Drag and Drop
4. Press and hold the left mouse key and keep dragging towards the blank column. You will notice a rectangle icon moving along with the mouse cursor saying drop here to replace cell. 5. Also notice the rectangular empty boxes appearing in the column header directing you with the additional information that the dropped column will fill in the space.
If you keep moving the cursor inside all corner of this box with still holding the left mouse key, you will see the message inside rectangle icon
8/7/2015
OSC
changes to
Page |2
Business Objects Reporting BOBJ (Pilot)
WEBI Reports Drag and Drop
drop here to replace or insert cell. In this example, we are going to choose replace cell to replace the blank column. But if you are dragging an object and dropping near an existing nonblank column, before you release the mouse key, please read this icon message carefully and drop it. If your icon says replace cell, it means it is replacing the current column. If the icon says insert cell which means you are inserting either before or after the cell depending on your cursor location.
6. Drop inside the rectangle box or inside the cell in the column with the drop icon message still says ‘Drop here to replace cell’.
Notice the new selected field attribute occupies the blank column with the #REFRESH value in the cells. 7. Repeat from step 2 if you want to add more columns. 8. Refresh the report again to see the correct values in the drag and dropped column.
8/7/2015
OSC
Page |3
Business Objects Reporting BOBJ (Pilot)
WEBI Reports Drag and Drop
Drag and Drop a field near non-blank columns A dimension characteristic or measure can be drag and dropped on a table column that will insert or replace in a Web Intelligence report in Design mode. 1. Open a Web Intelligence document in Design mode. 2. Select a dimension attribute or measure from Available Objects panel that you want to add to the report.
3. Press and hold the left mouse key and keep dragging towards the blank column. You will notice a rectangle icon moving along with the mouse cursor saying drop here to replace cell. 4. Also notice the rectangular empty boxes appearing in the column header directing you with the additional information that the dropped column will fill in the space.
8/7/2015
OSC
Page |4
Business Objects Reporting BOBJ (Pilot)
WEBI Reports Drag and Drop
If you keep moving the cursor inside all corner of this box with still holding the left mouse key, you will see the message inside rectangle icon changes to drop here to replace or insert cell. But if you are dragging an object and dropping near an existing non-blank column, before you release the mouse key, please read this icon message carefully and drop it. If your icon says replace cell, it means it is replacing the current column. If the icon says insert cell which means you are inserting either before or after the cell depending on your cursor location.
In picture above, a new column that will be inserted next to Job Pay area on the right side is depicted. 5. Now drag and drop near the right side of the rectangle box or inside the cell in the column with the drop icon message still says ‘Drop here to insert cell’.
8/7/2015
OSC
Page |5
Business Objects Reporting BOBJ (Pilot)
WEBI Reports Drag and Drop
Notice the new selected field attribute occupies the blank column with the #REFRESH value in the cells. 6. Repeat from step 2 if you want to add more columns. 7. Refresh the report again to see the correct values in the drag and dropped column.
Scenarios Insert a column on the left side To insert a column on the left side of Job Pay Area column, drag and drop when you see a picture like this:
Replace a column on the right side To replace the column Job Pay Area column, drag and drop on the middle as you see a picture like this:
8/7/2015
OSC
Page |6
Business Objects Reporting BOBJ (Pilot)
WEBI Reports Drag and Drop
Insert a column on the right side To insert a column on the right side of Job Pay Area column, drag and drop when you see a picture like this:
8/7/2015
OSC
Page |7
