Remove Selection Variable Rows

[Former Member]

Hi,

Is there any way to remove the selection variable rows from the BEx Analyzer report? I am on BW 3.5.

I want to display only the columns and rows data and nothing else.

I have to use this result set to display in Excel from the portal.

Thanks in advance.

Bhargava

[Former Member · Accepted solution]

In 3.5 you can do this by referencing the saved workbook. I don't believe you can do it from the query itself.

After running the query, go to the layout menu --> move result area.

Then you can display the result area (rows and columns only) on a different tab in the workbook.

[Former Member · Accepted solution]

I cannot use workbook options at all here. I have to export the results from portal to excel. I am seeing ways of removing the free chars and name of query from the results in the query itself so I can call use a web template on this query and export to excel function.

Bhargava

[Former Member]

Or:

In the Excel workbook simply delete the rows you do not want (highlight the rows, & use the Delete option in the Edit pull-down menu).

Then resave the workbook.