Bex portal report download issue

[Former Member]

Hi All,

Is it possible to restrict the number of records specifically to export to excel when downloading the report. Is it any other way to down load huge data from Bex portal report.Please suggest solution.

Thanks and Regards,

Uma

[yasemin_kilinc · Accepted solution]

Hi Uma,

If your requirement is restricting the number of records transported to excel, you can also think of using top N type of conditions.

Regards

Yasemin..

[Former Member · Accepted solution]

Hi Yasemin and All,

But I cant keep condition to all the queries.Is there any other way to restrict to export data to excel .

After going all the notes we identified there is no parameter BICS_DA_RESULT_SET_LIMIT_XLS  available in our system in RSADMIN table as per note 1622134.

Please can any one suggest solution.

Thanks and regards,

Uma

[sapna_jgurudutt · Accepted solution]

Hi Uma,

Can you please do the settings as mentioned in the following SAP Note and check whether it helps you:

1622134 - Safety belt: Results quantity is too large (Excel/PDF)

Please set the value for parameter BICS_DA_RESULT_SET_LIMIT_XLS for the export to Excel

as per SAP Note 1622134.

It should help you.

Also, please go through the following SAP Note:

1127156 - Safety belt: Result set is too large

Thanks & Regards,

Sapna

[Former Member · Accepted solution]

Hi Sapna,

I could not able to find the parameter.Plese check below screen shot.

As per note mentioned 1127156 below:

RSADMIN parameter

The "Maximum Number" (BICS_DA_RESULT_SET_LIMIT_MAX) and "Default

Number" (BICS_DA_RESULT_SET_LIMIT_DEF) are defined in the customizing table RSADMIN.

l "Maximum Number" (BICS_DA_RESULT_SET_LIMIT_MAX) defines the maximum number of cells that an user

can enter manually for a specific Query View (see above).

l "Default Number" (BICS_DA_RESULT_SET_LIMIT_DEF) contains the number of cells that is used for

all Queries (and Query Views) without any custom-defined number. The value of this parameter has

to be lower than the value of the parameter defining the maximum number of cells.

BICS_DA_RESULT_SET_LIMIT_DEF < BICS_DA_RESULT_SET_LIMIT_MAX

To maintain the RSADMIN table it's recommended to use the program

"SAP_RSADMIN_MAINTAIN" (transaction SE38) and to create both RSADMIN parameters and to define a

proper value.

If we restrict based on the above parameters then the report displaying on portal will effect  or not?

Thanks and Regards,

Uma

[sapna_jgurudutt · Accepted solution]

Hi Uma,

If you are not able to find the parameter BICS_DA_RESULT_SET_LIMIT_XLS then you can add

it in the table RSADMIN by going to transaction SE38 -> using Program SAP_RSADMIN_MAINTAIN

Can you please add this parameter as per SAP Note 1622134 and check whether it helps you

as this parameter BICS_DA_RESULT_SET_LIMIT_XLS is set to Export to Excel.

Thanks & Regards,

Sapna

[Former Member · Accepted solution]

Hi Sapna,

Thanks for your support.It looks like working and will update the details soon.

Thanks and regards,

Uma

[Former Member · Accepted solution]

Hi Sapna and All,

Even after keeping the paramaeter as BICS_DA_RESULT_SET_LIMIT_XLS  as 10,000(ten thousand) in table RS ADMIN. It is allowing export to excel download more than 10,000 records or cells.

Could you please suggest solution.

Excel Download Count:

Thanks and Regards,

Uma

[sapna_jgurudutt · Accepted solution]

Hi Uma,

Did you restart the Java server after setting the value for parameter BICS_DA_RESULT_SET_LIMIT_XLS

If not, can you please do it and check whether it helps you.

Thanks & Regards,

Sapna

[Former Member · Accepted solution]

Hi Sapna,

Thanks for your support.Testing in progress will update if I have any queries

Thanks and regards,

Uma

[sapna_jgurudutt · Accepted solution]

Hi Uma,

Can you please clarify regarding whether the previous reply I provided here helped you.

Thanks & Regards,

Sapna

[Former Member · Accepted solution]

Hi Sapna,

Still able to download more records.I dont know why it is not working .Any suggestion from your side.

Thanks and Regards,

Uma

[sapna_jgurudutt · Accepted solution]

Hi Uma,

Can you please check whether you have set the value for parameter BICS_DA_RESULT_SET_LIMIT_XLS properly as per the following SAP Note:

1622134 - Safety belt: Results quantity is too large (Excel/PDF)

Thanks & Regards,

Sapna

[Former Member · Accepted solution]

Hi Sapna,

Could you please check below screen shot and restarted BW Java server restarted.Any clue from your side.

Thanks and Regards,

Uma

[Former Member · Accepted solution]

Hi Sapna,

Please check the below screen shots of our system:

As per note will it works could you please suggest me

Thanks and Regards,

Uma

[Former Member · Accepted solution]

Hi Sapna,

Along with BI Java server do we need to restart BI ABAP server also?

Thanks and Regards,

Uma

[sapna_jgurudutt · Accepted solution]

Hi Uma,

Can you please try restarting ABAP server too and check whether it helps you.

Thanks & Regards,

Sapna

[Former Member]

Hi All,

Can any one suggest solution to the above issue.

Thanks and regards,

Uma

[sapna_jgurudutt]

Hi Uma,

Can you please set the RSADMIN parameter RSWR_EXPORT_STRATEGY as per the following SAP Note and check whether it helps you:

1697539 - BEx Web 7.30: Memory Usage Reduction on Export Scenarios

Also, please refer the following SAP KBA Note:

1913710 - BI Java Memory Improvements for NW 7.30

Thanks & Regards,

Sapna

[Former Member]

Hi Sapna,

The level we are using is 005.Please check below screen shot.

Thanks and Regards,

Uma

[sapna_jgurudutt]

Hi Umakanth Jaldu,

Can you please clarify regarding whether the following SAP Notes which I mentoined here on 16.05.2015 helped you as it is not clear:

1622134 - Safety belt: Results quantity is too large (Excel/PDF)

2069568 - BI Java OOM dumps caused by export operations

1178857 - Additional information: Export to Excel functions

Thanks & Regards,

Sapna

[Former Member]

Hi Sapna,

Thanks for your support.I am annalyzing the notes and will come back if I have any queries.

Thanks and regards,

Uma

[Former Member]

Hi Uma,

Excel is not a tool to export huge amount of data.

With excel you can only download approx. 750,000 cells.

If you try to download huge amount of data it will not work.

But you can try using export to PDF for downloading more amount of data than in case of excel.

What you can also do is check whether you are using SAP BI Export library functionality for PDF export as it allows relatively to download greater amount of data.

How to set the SAP BI Export library for PDF export  , you can follow solution part of note of below note:

1112132 - The SAP BI Export Library

Also in case you want to restrict the number of data to be download during either PDF or excel export , below note will be helpful:

1622134 - Safety belt: Results quantity is too large (Excel/PDF)

Regards,

Amit

[former_member230898]

Hi Umakanth,

You can always use and it is highly recommended to use "SAP Open Hub functionality"  for large data exports .

this should help you .

Regards,

Bhaskar

[sapna_jgurudutt]

Hi Uma,

Please note that it is not recommended to export large amount of data using Export to Excel.

Can you please refer the following SAP Notes and check whether it helps you:

1622134 - Safety belt: Results quantity is too large (Excel/PDF)

2069568 - BI Java OOM dumps caused by export operations

1178857 - Additional information: Export to Excel functions

Thanks & Regards,

Sapna

[Former Member]

Hi All,

Please suggest if any other solutions are available.

Thanks and Regards,

Umakanth Jaldu

[ccc_ccc]

Hi Uma,

Create APD and extract data into flat file.

Or use Tcode

RSCRM_BAPI to extract data into flatfile/table

Thank you,

Nanda