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

[Arleigh]

Hi Ajay,

You can definitely create the QTD Query on top of the existing CDS View in 2021 though I don't know the actual steps you have to go through to do that. Hopefully the SAP Note mentioned above or possible google search for a blog will help you do that.

I just wanted to point out that in 2022 SAP has delivered a query that does this and more. But if you are not on 2022 then of course you can't use that.

Check out the SAP Group Reporting Community Page as it has all the latest info including a recap of what's in S/4HANA 2022 and many other things about Group Reporting.

https://community.sap.com/topics/s4hana-group-reporting.

The new Query wasn't mentioned in the 2022 release notes but I did a search for it and found that it was installed with the software. It's going to be used as basis of a new Reporting Tool called the Financial Statement Review booklet that's already in Public Cloud and looks like planned for formal release with Private with the 2023 release this fall. But it was super easy to point Analysis for Office to the query and get AO reports with QTD and other new features.

all the best

Arleigh

[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.

[Arleigh]

One Additional piece of information. If you are on Public Cloud OR OnPrem/Private Cloud Version 2022 there is a new query that is included that can be used by AO to do QTD reports and it comes with Variance columns and various period, QTD and YTD comparisons. But only if you're on 2022 or current Public.

[chillarige_sriramanarasim]

Hi Taylor,

Thank you for the help and providing us the features that are available for version 2022.But we are in version 2021 and looks like we can use Custom Analytical queries to build the same.

Thanks and Regards,

Ajay.

[alexandrekuntge]

Hi arleigh

You said there is a new query up to 2022, but you don't mention the name of it.

What is the name of this object that comes with various period including QTD ?

Tks

Jadir

[Arleigh]

HI Jadir,

The new query provided in 2022 is Query Technical name 2CCCNSLDTISFOE and the InfoProvider Technical name is 2CIMCFNDNENHANCUBE. This is the new query that users FSITEMS. There is another one that users Reporting Items but if your doing standard QTD Financial Reports you want the FSITEM based query. The Reporting Item query is the same name but ends in NOE.

The query works a bit differently as you can see in the 2nd screen shot that you have to choose the columns you want to display through the STRUCTURES. But there is a huge list and in includes various MTD, QTD and YTD with comparison options like this QTD vs pervious QTD. Or This QTD vs Prior Year QTD, etc..

This query was created to support the Fiori based reporting tool currently in public Cloud GR called the Financial Statement Review Booklet (FSRB). It didn't get included in Private or On Prem in the 2022 release but is planned on the last roadmap I saw for the 2023 Release Service Pack 1. But even though FSRB didn't make it into 2022 the underly queries did.

Just point AO at the query and away you go. 🙂

[alexandrekuntge]

Hi arleigh

Thank you so much!

Best Regards,

Jadir Mendes