CDS based AFO prompt settings

[former_member813490]

Hi Experts,

I have one requirement where I need to make the Prompt field values to be displayed as Key and Text for most of the fields when using the valuehelp of the field. Currently by default it is just displayed as Text. This is a CDS based report so I tried using annotations "@AnalyticsDetails.query.display: #KEY_TEXT" and also in my technical configuration of Analysis I have maintained KeyText but it did not worked. Please let me know if its possible on a CDS based AFO.

[SeshaP]

Hi Aman,

Please check in rsrt how it is working. What is the back end source for this AFO report is it BW cubes,Dso's or S4 HANA tables?

If it is Bw cubes or DSo then in Bw system check the iobj properties of that field. Make sure you enabled it as key and text.

Thank you

[SeshaP]

Hi,

You have to create an inteface cds view which holds text info. Refer this blog

https://blogs.sap.com/2020/08/03/create-key-text-feature-in-custom-analytical-query-how-to-use-key-t...

Thank you

[former_member813490]

Hi Sesha, Thanks for the reply, the blog tells about enabling the feature, in my case I already have the feature I just want to make "Key and Text" as default for valuhelps of fields in prompt of Analysis for office. Currently its defaulted to "Text" only and users have to select "Key and Text" manually each time.

Thanks,
Aman