Creating custom reports

[former_member93989]

Hi;

I was wondering what companies out there are doing to create custom reports. Many times we can't find existing CDS views/Analytical queries that have the data we need. When we try to create custom CDS Views or queries by joining existing ones, we still are missing data we know are in the standard tables. Just curious what others are doing.

Appreciate any insight,

George

#coe

[former_member95896 · Accepted solution]

Hi George,

We're creating custom analytical queries, SAC stories, CDS views and pulling by API (where we can this is limited), or taking the existing reports and dumping to excel and adding the additional mapping or details. Unfortunately with large data sets we have to do this anyway since SAP reporting struggles with more than 10,000 rows of data and we need to combine all of the extracts.

Regards,

Ryan

[NAME · Accepted solution]

I also find that the native reports struggle with large data sets. In extracting data from the Goods Movement Analysis report, for example, we have to do it in two-month increments or else it hangs. I wonder if this is common for all cloud-based ERPs being that they obviously depend on available Internet bandwidth between the client and server.

Ralph