Data Model Column limitation in SAC

[former_member642540]

Dear SAP team,

As we have got a client requirement to upload a data model of more than 350+ columns in a excel. But we face an error as "Query results exceeded the column count limit of 100. Please upload different data, or edit your query to acquire fewer columns". Kindly provide us an alternative solution to resolve this issue.

With regards,

Monica

[former_member650982 · Accepted solution]

Hi this is a known limitation of SAC - do not know why - as all other products to not have this annoying limitation

But you could read this post

https://answers.sap.com/questions/12664596/sap-analytics-cloud-data-volume-constraints---data.html
use the in-pivot function and have all the KF in one column- ensure you to not hit the 800.000 row limitation

/Renè