Display field as filter but hide as dimension in Analytical Query

[aoyang]

Hi,

We are building custom analytical query and we have a requirement to show a field as filter in the prompt but hide the field as dimension. Below is a sample scenario where custom analytical query is built on I_GLAccountLineItemCube.

'AccountingDocument' is where this requirement should be applied. Now I've tried with three different annotations, but none of them seems to fulfil the requirement:

@UI.hidden: true

@Consumption.hidden: true

@AnalyticsDetails.query.hidden: true

As yo can see in the screenshots(tcode RSRT), either field appears both as filter and as dimension, or neither of them. Is it possible to show the field as filter in the prompt but hide the field as dimension?

@EndUserText.label: 'Journal Entry Analyzer'
@VDM.viewType: #CONSUMPTION
@Analytics.query: true
@Analytics.settings.maxProcessingEffort: #HIGH
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.modelingPattern: #ANALYTICAL_QUERY
@ObjectModel.supportedCapabilities: [ #ANALYTICAL_QUERY ]

define view entity YC_GLLINEITEMSQ0001
  as select from I_GLAccountLineItemCube as I_GLAccountLineItemCube
{

  @Consumption.filter: { selectionType: #SINGLE, multipleSelections: true, mandatory: false }
  @AnalyticsDetails.query.axis: #ROWS
  @AnalyticsDetails.query.totals: #SHOW
  @AnalyticsDetails.query.display: #KEY_TEXT
  GLAccount,

  @Consumption.filter: { selectionType: #RANGE, multipleSelections: true, mandatory: false }
  @AnalyticsDetails.query.axis: #FREE
  @AnalyticsDetails.query.totals: #SHOW
  PostingDate,

  @AnalyticsDetails.query.axis: #FREE
  @Consumption.filter: { selectionType: #RANGE, multipleSelections: true, mandatory: false }
  @UI.hidden: true
  @Consumption.hidden: true
  @AnalyticsDetails.query.hidden: true
  AccountingDocument

};

Best regards,

Aocheng