To calculate QTD in Group Data Analysis Reports

[chillarige_sriramanarasim]

Hi Experts,

we have a business requirement to calculate QTD values in Group Reporting using Group Data Analysis Report. But unfortunately we don't have QTD as one of the period mode at the time of selecting periodicity like how we select YTD as the period mode during execution of GR reports using GDA Fiori app.

Hence wanted to check if there is any solution that for calculating QTD values using Custom Analytical queries or using SAP AFO for GR reports as enhancing CDS views for achieving the same seems to be complex.

Thanks in advance for your help.

Thanks and Regards,

Ajay Chillarige.

[Yogananda]

chillarige.sriramanarasimhaajay

In GR AO Reports / GDA the QTD is not provided as part of the standard solution, however, this can be achieved using the Custom Analytical Queries (SAP Note 2659672), however, the report displays all the QTD columns. You can use Custom Analytical Queries in SAP S/4HANA Embedded Analytics¹².

I hope this helps! Let me know if you have any other questions.

¹: SAP Community ²: SAP Blogs

[chillarige_sriramanarasim]

Hi Yogananda,

Thank you for providing your inputs. Yes we will try using Custom Analytical queries to build the same. we will let you know the outcome.

Thanks and Regards,

Ajay.