Limitation on Number of Rows - analysis office

[Former Member]

How to find what is the maximum rows which we can display in analysis office.

I have a case where I display number of months in column and list of product in row

we have around 30000+ product where value is there and 70000+ product where value is not there and number of months is 12. I would like to display only cell with value.

if I run the report with Quarter in the column. it displays , if I run the report with month in the column, it does not display, gives a error maximum row exceed.

but end out put of number rows in excel will remain only 30000.

not sure. from where the maximum rows exceeded is coming

we are using analysis office 1.4 and Open hana model.

Note - I have already increase in the registerly the max number of rows to 9000000 as seen in some blog.

Regards

Amar

[former_member151004]

Hi Amarnath R.R,

Please check the wiki page http://wiki.scn.sap.com/wiki/x/EYhRFw in order to help you.

Thanks,

Diego Ferrary

[former_member110741]

Hi Amarnath R.R,

Please check this from admin guide

Hope this helps

Subhash

[Former Member]

In my context we are not using BW querys for analysis office. we are using open hana model directly in analysis office.

whether this hold good for that case also

[former_member110741]

Hi Amrnath,

i beleive this setting on crosstab level, could you give it atry and check

Subhash

[filipe_zeuch]

Hi Amarnath,

The ResultSetSizeLimit is also valid for HANA data sources.