Skip to Content
0
Mar 19, 2019 at 05:27 PM

Analytical List Page value help

644 Views

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?

Attachments

xebgh.png (13.7 kB)
aalgy.png (11.6 kB)
7zise.png (14.9 kB)
plmh0.png (28.2 kB)
guuke.png (64.7 kB)
6xocl.png (95.9 kB)
4qkdi.png (63.5 kB)
uueex.png (40.9 kB)
vqd2z.png (80.5 kB)