on 03-30-2017 5:50 PM
Hi Experts,
Will the IBP Workbook display master data more than the excel limit of 1.1 million. For example if we have around 10 million records for a master data will IBP load all the data in the excel or limit it to 1.1 million which is excel limit.
Regards,
Aditya
Dear Aditya,
As explained by Jorge, there is a Global Configuration parameter MASTER_DATA_OP->MAX_BATCH_SIZE that controls the number of master data records that can be downloaded from the Excel UI. The parameter has the recommended value of 10000.
You can still increase the parameter value, but please note that you can have some performance implications and possible runtime errors due to lack of memory. You might face issues when opening the workbook, like "An error has occurred on the server".
We would recommend using an HCI Export task to extract the large number of extracted records.
Please review the KBA 2437063 - IBP: Master Data Download Recommendations for Excel
Best regards,
Matheus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Aditya
you can use the next parameter, maybe it can help you
MASTER_DATA_OP MAX_BATCH_SIZEHope this can help you
Jorge
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Aditya,
The limitation exists because of performance reasons, so if you do adjust the parameter, bear that in mind.
Best regards,
Nuane
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Aditya,
If you maintain above parameter also planning template can not show more than excel batch size (1,048,576 rows).
Best Regards,
Lingaiah
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
4 | |
3 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.