F4 Help in Custom Analytic Query

[ankesh_jindal4]

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

[MioYasutake · Accepted solution]

@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 · Accepted solution]

Hi @MioYasutake,

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

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

I got below Error

[ankesh_jindal4 · Accepted solution]

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 · Accepted solution]

@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 · Accepted solution]

Hi @MioYasutake, Yes that's the thing I discovered while research and did changes and it is working fine now. Thanks for your input