Maximum number of columns in a report.

[Former Member]

Dear All,

Can anyone tell me the maximum number of colomns that can be shown in a report.

i.e. the maximum number of info-objects that can be used in a query.

Regards,

Aravind.

[former_member205352]

Maximum number of columns supported by excel is 128 and rows is 65536.

Maximum number of key figs supported by cube itself is 233.

Hope this gives some idea.

[Former Member]

I dont think there is any limitation on number of columns

But the count shold be kept low as these reports are ment for managers and they are only interested in the summary of the report not the long report that can not be even printed in a landscape mode

Hope this helps

[Former Member]

Dear Akshay,

Thnaks for the inputs.

In our requirement the user want 65 fields to be displayed. we are not able to add more than 50 fields in the report (we are able to add but when we execute the query it throws an error that there are more than 50 columns in the DRILL DOWN).So want to have a clarification regarding the same.

Regards,

Aravind.

[yogesh8984]

Hi Arvind,

You are correct in saying that only 50 columns can be shown in the BW report at a time. It will allow you to place more than 50 fields in the query definition but the query will not execute.

If you want to show more than 50 columns, you can add those extra columns in the FREE CHARACTERISTICS of the query definition. So at the time of execution of the query user will see the 50 columns by default and if he wants to see those additional columns, he can replace the already existing columns by the fields in the free characteristics. This can be achieved by DRILL DOWN and DRILL ACROSS.

This is the way to go about it. We also did the same thing in our case.

Regards,

Yogesh