Skip to Content
0

Calculate Number of cells in Bex

Nov 07, 2016 at 01:43 PM

81

avatar image
Former Member

Dear experts,

I would like to understand how the number of cells is calculated by BW when executing a bex query. number of rows x number of columns ? (in the same way as excel)

I am asking the questions since I have been allowed to execute a query with more than 2 millions of cells (number of rows times number of columns) while the limit set in the BW is 2 million (in BICS_DA_RESULT_SET_LIMIT_MAX)

Could you please help with this ?

Thanks in advance,

Amine

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Nov 17, 2016 at 05:55 AM
0

Hi

Similar to excel.

It count number of rows based on result set only.

to over come this,

Set more aggregated characteristc in Rows column and reduce number of characteristics as well.

Regards,

Jay.

Share
10 |10000 characters needed characters left characters exceeded
Loed Despuig Nov 21, 2016 at 06:40 AM
0

Hi,

It is the same with EXCEL, rows x column = CELLS.

Did you save your BICS_DA_RESULT_SET_LIMIT_MAX? Can you post here the result of your query which is more than 2M?

Regards,

Loed

Share
10 |10000 characters needed characters left characters exceeded