How to change the default F4 association in a CDS view query for Analysis for Office

[andres_rodriguez_guapacha]

Good morning

I have a CDS query based on a Cube from I_MatrixConsolidationReportC.

I use the @Consumption.filter annotation on the FiscalYearPeriod field, but I need to change the F4 value help list.

I tried implementing the solution in this example but even though I add the association in the cube and assign it in the query, the Value Help doesn't change.

I created a simplified version of the views for testing:

Query:

@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@Analytics.query: true
@EndUserText.label: 'test query'
define view y_c_rprt_003_test
  as select from y_cds_brd_view_test(P_KeyDate: '20211101')
{
  key y_cds_brd_view_test.ConsolidationLedger,
  key y_cds_brd_view_test.ConsolidationDimension,
  key y_cds_brd_view_test.FiscalYear,
  key y_cds_brd_view_test.ConsolidationDocumentNumber,
  key y_cds_brd_view_test.ConsolidationPostingItem,
      y_cds_brd_view_test.FiscalYearVariant,
      @Consumption.filter: { selectionType:#RANGE, multipleSelections: true, mandatory: true }
      @Consumption.valueHelp: '_association_name'
      y_cds_brd_view_test.FiscalYearPeriod
}

Cube:

@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@Analytics.dataCategory: #CUBE
@EndUserText.label: 'Test'
define view y_cds_brd_view_test
  with parameters
    P_KeyDate : sydate

  as select from I_MatrixConsolidationReportC( P_ConsolidationUnitHierarchy: '$',
                 P_ConsolidationPrftCtrHier:'$',
                 P_ConsolidationSegmentHier:'$', P_KeyDate:$parameters.P_KeyDate ) as V1
  association [0..1] to Y_I_FiscalYearPeriodOutput as _association_name on $projection.FiscalYearPeriod = _association_name.FiscalYearPeriod
{
  key ConsolidationLedger,
  key ConsolidationDimension,
  key FiscalYear,
  key ConsolidationDocumentNumber,
  key ConsolidationPostingItem,
      @Semantics.fiscal.yearVariant: true
      FiscalYearVariant,
      @Semantics.fiscal.yearPeriod: true
      FiscalYearPeriod,
      _association_name // Make association public
}

The association is a simple 1 field view with the type conversion desired for the value help.

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Fiscal Year Period conv. rout PERI7'
@Metadata.ignorePropagatedAnnotations: true
@Analytics.dataCategory: #DIMENSION
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view Y_I_FiscalYearPeriodOutput
  as select distinct from I_FiscalCalYearPeriodForCoCode
{
  key cast( FiscalYearPeriod as fincs_fiscyearper preserving type ) as FiscalYearPeriod
}

The value help shown is the one that belongs to the original data element, but we require the one that can be generated from the associated table.

Is there anything I am missing on my code? Or could it be that I need to apply some of the OSS notes cited here?

Thanks for any help you can give me