cancel
Showing results for 
Search instead for 
Did you mean: 

Not able to export Data to excel

Former Member
0 Kudos
156

Hi Leads

I am trying to extract report from MII UI dashboard based on input parameters. After running report and extracting to excel, records are not fully getting exported. While running same query in database for extracting report it is giving all records.

Number of records in database 182660

Records exported to Excel 120001

Is there any limitation of excel to export certain number of records? Is there any work around for resolving the issue?

I am using below mentioned url to extract report to excel:

url =servername +"Illuminator?queryTemplate=QUALITY/QUA_I/QUERIES/SelectFilteredFromConfigurationList&Param.5="+escape(wherePart).replace(/\+/g,'%2B')+"&OutputParameter=ID_LIST&Content-Type=text/csv";

window.open(url);

View Entire Topic
Former Member
0 Kudos

Hi Jeremy/Ria

I tried to add filter to the URL but still data is greater the 120K+ rows.

Shall I raise Incident with SAP to get the solution or is there any other way out I can try?

Private_Member_14935
Active Participant
0 Kudos

Hi Rohit,

So I assume changing the Max Row Count in System Properties didn't help.. right..?

Thanks and Best Regards,

Ria

Former Member
0 Kudos

Hi Ria

I am not able to find screen where I change that value. Might be I dont have access to it. Can you  please guide me with  path?

I am using SAP MII 12.1 SP11.

Will it be done by BASIS team?

Private_Member_14935
Active Participant
0 Kudos

Hi Rohit,

This configuration is not available until MII 14.0

Thanks and Best Regards,

Ria