#COE#DE01 - Custom Analytical Query error received when attempting to edit it

[kman4247]

Good day,

I am attempting to edit a Custom Analytical Query, but receive the error that can be seen as per the attachment. Please can you confirm how this should be rectified.

Regards,
Keith query-validation-error.png

[MartyMcCormick · Accepted solution]

Hello

You may want to open an incident on component BC-SRV-APS-EXT-AQD to confirm with SAP development directly but I did find several similar messages and customers were told that this is an issue with stricter checks on the query during edit and publish and a solution is part of a hotfix cycle that will reach customers systems Dec 10-12.

Marty

[kman4247]

Thank you all for the attempted answers. A hotfix was implemented by SAP to resolve the issue.

[Cora_Phelan]

can you recreate the query

[Yong_Yu]

Hello Keith,

Your query uses a released CDS view which contains deprecated view elements(Recognition Key).

Could you please check the upgrade documentation of the relevant CDS views, and replace the use of deprecated view elements by their successors as described in the document? Please make sure the CDS view of your query works well first.

BTW, in 2011, New Revenue Recognition Method 360 Days Calendar Year Available for Service Contracts and Provider Contracts.

Best regards,

Yong

[kman4247]

Hi Yu,

Thank you for the response. There is indeed a deprecated element in a relevant CDS view (Recognition Key), thank you. We are in the situation where we do not want to delete the Custom Analytical query in order that we can replace the deprecated element.

Regards,

Keith