The maximum number of data columns allowed in a report (60) has been reached

[former_member950462]

Dear SAP community,

I need help as I am unable to export this report which has 68 columns. However, during my previous months, I was able to export this report even though the number of columns I have in the report is more than 60. I tried to adjust the drill limits but it doesn't seem to help... Can anyone help me? Thank you!

[William_Yu]

Hi atyh19,

The drill limit can be uplifted, you can enter the limitation edit screen via the table widget header detail

Best regards, William

[former_member950462]

Hi william.yu,

Thanks for your reply. Yes, this helps in the report presentation on SAC but the export still shows the error despite the adjustment 😞

[William_Yu]

Hi atyh19,

That's strange, I can export all columns exceeding 60...

Best regards, William

[mfrieser]

I think the error message was misleading at the time.

Actually, not 60 columns are not allowed. It is the count of measures which is not allowed to exceed 60 (in combination with other dimensions such as date).

It seems that the error message has changed since then:

I am also facing this issue. atyh19 did you find a workaround for this issue?

Is there a known improvement request? I could not find any.

Or is it recommended to create a support ticket?

This is a rather crucial issue in our project ...

BR

Michael

[mfrieser]

I just experimented with the new data analyzer and there is no limitation on the amount of measure columns in the excel export.

I would recommend to use this instead of a story table export.

BR

Michael

[GovindaRaoBanothu]

Thanks, current as work around we can use Data Analyzer until 2024.QRC3 (2024.14). Please refer the KB note: https://userapps.support.sap.com/sap/support/knowledge/en/3523565