Skip to Content
avatar image
Former Member

Maximum number of columns in a report.

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Sep 04, 2008 at 09:33 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • Sep 04, 2008 at 09:36 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded