cancel
Showing results for 
Search instead for 
Did you mean: 

F4 Help in Custom Analytic Query

ankesh_jindal4
Participant
166

Hi Experts,

I am trying to create F4 help to Custom analytic query, I added below annotation to make field act as filter but I tried various ways to add Value help but without any success. field is not parameterized, it is made filter by addition below annotation form projection list.

@Consumption.filter: {selectionType: #INTERVAL, multipleSelections: true, mandatory: false}

Can you please guide how to achieve it

Ankesh

View Entire Topic
MioYasutake
Active Contributor

@ankesh_jindal4 

Please try adding @ObjectModel.foreignKey.association: '_AssociationTarget' in the underlying cube view. 

In the example below, I_Material will be used for value help.

 

define view I_SalesOrderItem 
  association [0..1] to I_Material as _Material 
    on $projection.Material = _Material.Material ... { 
      @ObjectModel.foreignKey.association: ’_Material’
      Material,
      _Material, ...
}

 

 

ankesh_jindal4
Participant
0 Kudos

Hi @MioYasutake,

Thanks for your response, this is working fine where we have text association like in below example @ObjectModel.text.association: '_countrytext'

ankesh_jindal4_0-1719323010820.png

But I have another CDS which does not have text association, Is it mandatory to have text association, if I want to use value help without text association based on just CEPC-name1(as in below example) how should I do that

ankesh_jindal4_1-1719323064085.png

I got below Error

ankesh_jindal4_2-1719323119142.png

 

 

 

ankesh_jindal4
Participant
0 Kudos

Hi @MioYasutake, I think it is not related to text association because I removed text association and it is still working. my simple requirement is to show CEPC-NAME1 or CEPC-NAME2 as value help in other CDS.  one thing I noticed is BUKRS as MATNR in your example has value table but NAME1 does not have any value table? I am not sure though will it have any implication? 

Can you please share your observations 

MioYasutake
Active Contributor
0 Kudos
@ankesh_jindal4 The view ZCDS_VH_TEMP needs to have the profit center code as a key field. Otherwise, the association won't work.
ankesh_jindal4
Participant
Hi @MioYasutake, Yes that's the thing I discovered while research and did changes and it is working fine now. Thanks for your input