Analytical List Page value help

[former_member605045]

Hi Felipe,

I created an Analytical List Page with 5 filters. So far so good.

Unfortunately I am not able to create a value help for the common filters.Maybe you have a hint.

Please have a look at the attachments with my codung

I guess I also have to customize something in the WEB IDE???

There is no value help for the Dimension Product. Can you help me with what is missing?

Thanks a lot in advance

Ute

Here is my view

@AbapCatalog.sqlViewName:'ZHM_VI_REP_ZBW03'

@AbapCatalog.compiler.compareFilter:true

@AccessControl.authorizationCheck:#CHECK

@EndUserText.label:'GBIS: View Umsatzdaten'

defineview ZHM_VI_REP_TD_ZBW03

asselectfromZHM_TF_REP_TD_ZBW03( SAPClient:$session.client)as Rev_Data

…………

association[0..1]to ZHM_DI_MD_PRODUCTas _Producton$projection.Product = _Product.Product

association[0..1]to ZHM_DI_REP_MD_BPas _BpAGon$projection.CustomernumberAG = _BpAG.PartnerNumber

association[0..1]to ZHM_DI_REP_MD_BPas _BPErpon$projection.CustomernumberERP = _BPErp.PartnerNumber

association[0..1]to I_Currencyas _Currencyon$projection.Currency = _Currency.Currency

{

……

// Produktgruppe

//@Consumption.valueHelpDefinition: [{entity : {name: 'ZHM_DI_MD_PRODUCT',element : 'Product' }}]

Product,// Produkt

Rev_Data.ProfitCenter,// ProfitCenter

concat(Rev_Data.ProfitCenter, CONTR_AREA.ControllingArea )as ProfitCenterKey,// künstlicher Schlüssel Profitcenter

ObsPc,// OPS des ProfitCenters

ObsAg,// OBS des Auftraggebers

ObsProduct,// OBS des produktes

@Semantics.amount.currencyCode:'Currency'

RevenueAmount,// Umsatz

Currency,// Währungsschlüssel

// Assoziationen

_SalesOrganisation,// Verkaufsorganisation

_ProfitCenter,// ProfitCenter

_ObsCodeAg,// ObsAg

_ObsCodePc,// ObsPc

_ObsCodeProduct,// ObsProduct

_Product,// Product

_BPErp,// Businesspartner ERP

_BpAG,// Businesspartner Ag

_Currency// Währungsschlüssel

}

Here is my cube

@AbapCatalog.sqlViewName:'ZHM_CU_REP_BW03'

@AbapCatalog.compiler.compareFilter:true

@AbapCatalog.preserveKey:true

@AccessControl.authorizationCheck:#CHECK

@EndUserText.label:'GBIS: Cube Umsatzdaten ZBW03'

@Analytics.dataCategory:#CUBE

defineview ZHM_CU_REP_ZBW03

asselectfrom ZHM_VI_REP_TD_ZBW03

{

/** DIMENSIONS**/

………

@EndUserText.label:'Product'

//@Search.defaultSearchElement: true

@Consumption.valueHelp:'_Product'

@ObjectModel.foreignKey.association:'_Product'

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

Product,

@EndUserText.label:'Material'

Material,

/**Measures**/

@EndUserText.label:'Total of Revenue'

@DefaultAggregation:#SUM

RevenueAmount,

@EndUserText.label:'Currency'

@Semantics.currencyCode:true

Currency,

// Assoziationen

_SalesOrganisation,// Verkaufsorganisation

_ProfitCenter,// ProfitCenter

_ObsCodeAg ,// ObsAg

_ObsCodePc,// ObsPc

_ObsCodeProduct,// ObsProduct

_Product,// Product

_BPErp,// BusinessPartner ERp

_BpAG,// BusinessPartner AG

_Currency// Währungsschlüssel

}

//where FiscalYear >= left($parameters.sydat, 4)

Here is my consumer

@AbapCatalog.sqlViewName:'ZHM_CO_REP_BW03'

@AbapCatalog.compiler.compareFilter:true

@AccessControl.authorizationCheck:#CHECK

@EndUserText.label:'GBIS: Umsatzanalyse'

@Analytics.query:true

@VDM.viewType:#CONSUMPTION

@OData.publish:true

@Analytics.dataExtraction.enabled:true

….

defineview ZHM_CO_REP_ZBW03

asselectfrom ZHM_CU_REP_ZBW03

{….

@AnalyticsDetails.query.sortDirection:#ASC

@AnalyticsDetails.query.axis:#ROWS

@Consumption.valueHelp:'_Product'

@ObjectModel.foreignKey.association:'_Product'

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

@AnalyticsDetails.query.display:#KEY_TEXT

@UI.selectionField.position:40

@UI.lineItem.position:60

Product,

….

}

But the value help is not showing

I guess I need to customize the value help in the WEB IDE???

Can you help me?

[sireesha_varada]

Please refer the below link.

https://wiki.wdf.sap.corp/wiki/display/fioritech/Fiori+Development+Guidelines+For+Analytics#FioriDev...

[scj1234]

Hi Ute,

Did u find the solution to this problem? I am also stuck with same issue.

[former_member731865]

Is this issue resolved? I am also facing issue while assigning to filter value help in Analytical list page

[former_member605045]

Thanks a lot to both of you. Will try to change the Position of the code. Unfortunately our System is now locked 🙂

The Link I will read at home, our Company blocks it 🙂

[former_member182874]

Hi Ute,

Your code is partly correct and may be the position of code is not proper.

----------------------------------------------------------------------------------------------------

Header annotations

-> Use association to your "ZVALUEHELP_VIEW"

association [0..1] to ZVALUEHELP_VIEW as _Product on consumptionview.xyz = _Product.xyz

{

@UI.Lineitem

@UI.SelectionField

@Consumption.valueHelp:'_Product'

consumptionview.xyz,

_Product //Declaration of value help alias

}

--------------------------------------------------------------------------------------------------------

ZVALUEHELP_VIEW : will contain the select query on your table to get the list of items in your value help.