How to remove dimension from report

[former_member190501]

Dear All,

I have created a report using Drag and Drop option as explained in the following link with 2 dimensions in rows and 1 dimension in column. Now I would like to remove one of the dimension from existing report. As explained in the below link I could not able to see the option called Remove Dim from design mode as well as preview mode.

http://help.sap.com/saphelp_bpc70/helpdata/en/32/5facaf79c14163b3ae976733d4ae65/content.htm

SAP Help: To remove a dimension, right-click on the dimension name block and select Remove Dim. You can remove dimensions only when more that one exists on either your columns or rows.

Please, can anybody shed some light on this issue.

thanks in advance..

regards,

Raju

[pravin_datar]

Hi Raju,

To remove a dimension, go to the report in design mode and simply drag that dimension out from the grid to anywhere in the Excel sheet and it will go awy from the report.

Regards

Pravin

[former_member190501]

Dear Pravin,

Thanks for the reply.

I have tried this drag and drop option. But the problem with this option is existing format is getting disturbed and some junk values appearing in place of removed dimension.

thanks and regards,

Raju

[former_member190501]

Drag and drop option is working when we create a report using Drag and drop reporting option.The same option is not working in reports which are created with EvDRE Builder.

Thanks and regards,

Raju

[pravin_datar]

If you have created report with EVDRE builder, then you should edit the expansions in EVDRE to add or remove dimensions.

Regards

Pravin