cancel
Showing results for 
Search instead for 
Did you mean: 

Analytical Query on SAP Public Cloud: Parameter value help problem when creating query.

BerkSaldır
Discoverer
0 Kudos
302

Hello everyone,

I want to create an analytical query in public cloud system. The base CDS view was created in ADT. The CDS is as follows.

berksaldir_0-1722526478274.png

I defined value help definition for both fields Fiscal Period and Fiscal Year in cds. Firstly I tried to create a custom cds view in customizing system with that cds. Then, I created an analytical query with that custom cds. Value help of parameters when the query is published is as follows.

berksaldir_1-1722527760781.png    berksaldir_2-1722527777760.png

Value helps don't appear. Analytical query and custom cds look like the following in ADT.

berksaldir_3-1722528178066.pngberksaldir_4-1722528223186.png

As you can see, value help annotations didn't transfer to custom cds and analytical query. Then, I created an analytical query with cds which was created in ADT. Second analytical query's parameter value help is as follows.

berksaldir_5-1722529029664.png     berksaldir_6-1722529044759.png

Value helps don't appear again. Second analytical query looks like the following in ADT.

berksaldir_7-1722529254607.png

As you can see, value help annotations didn't transfer to analytical query. I found a solution for that problem. If correct value table is used in domain, value help is appeared but using tables in domain value table is restricted.

Is there any solution for that problem? Or is there a step I'm doing wrong? 

Thanks in advance for any input.

Berk.

 

Enda
Product and Topic Expert
Product and Topic Expert
0 Kudos
Adding tag SAP S/4HANA Cloud for Finance
HenrikeGrötecke
Product and Topic Expert
Product and Topic Expert
0 Kudos
forwarded to experts
View Entire Topic
Santosh_Jha1
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello,

You can refer to the following blog, on how to add value help for parameter in ABAP CDS Analytical query.

https://community.sap.com/t5/enterprise-resource-planning-blogs-by-sap/how-to-add-value-help-for-par...

Thank You!