cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Fiori Analytical List Pages(1.58) Compact Filter value help is not coming

0 Kudos
2,179

Hello,

I need some help regarding Analytical List pages project. I have created one Analytical List Pages in WebIDE using Hana CDS view, Data is properly showing based on mandatory filters(Company Code as 1010) set from backend selected.

But Compact filter's F4 help data list for Purch. Organization filter is not coming, only showing as Define Condition.

Which is coming properly in Query Browser.

List of Company Code showing correctly in Query Browser based on CDS, but Value list is not showing in Compact Filter F4 help.

Please let me know if anyone has any concern on this.

Accepted Solutions (0)

Answers (4)

Answers (4)

freilinger
Participant

Hi everybody,

from my point of view the problem with the usage of value helps in the Analytical List Page is a big gap in the SAP documentation. I hope my answer can solve both question by Biplab Chakraborty and Tyler Keenan.

As it is not possible to use RDS for Analytical Query Views (or associations within the Quaery View) the main question is: How do you bring a second entity (which serves as a value help) to your service:

We picked the option "Include Gateway Service" in SEGW. There we have a service, which includes two OData.Publish:true services - (1)the main data for the ALP and (2) the service for the value help (and (n) for each additional value help).

Within the local annotations of the ALP now you are able to follow the SAP documentation:

https://ui5.sap.com/#/topic/16d43eb0472c4d5a9439ca1bf92c915d

Short story considering the documentation: In the following annotation now you can define the company code field as target (which you already do) and within the collection path you can choose the entity (2), which contains the company code value help. In this way you combine your main service with the value help entity, coming from the second service in your include service. From an ALP point of view however it is only one (include) segw service (containing (1) and (2)).

I hope it helps - best regards,

Sebastian

Jocelyn_Dart
Product and Topic Expert
Product and Topic Expert

HI Biplab,

You need to show us your CDS View. You should have a foreignkey annotation in the CDS View itself that should be related to the association you are using to the value help. This is NOT a UI annotation and local annotations cannot be used as a substitute for this.

Rgds

Jocelyn

Former Member
0 Kudos

Hi Jocelyn,

I'm having a bit of a problem surrounding this issue.

Regarding an Analytical List Page in the making, so far I've not successfully added value help for each compact filter, even though I've apparently placed the needed associations and annotations.

Besides that, I cannot even reference it via SEGW so then I could redefine its metadata annotations and import search helps or such (which wouldn't be ideal, either way), since Analytics are envolved in Analytical List Pages.

I've also come across with these two tutorials (value help through modelled view and through foreign key relationship), with no further success:

> https://help.sap.com/doc/saphelp_nw75/7.5.5/en-US/8a/8415c033d441b2b079a53aff129463/frameset.htm
> https://help.sap.com/doc/saphelp_nw75/7.5.5/en-US/1b/9a9e9d759e4302890c44cf5e10b5b1/content.htm?no_c...

Apparently, unlike the entities themselves, the issue is that the entity sets doesn't seem to be working (throws an /IWBEP/CX_MGW_BUSI_EXCEPTION).

Example of an entity:

Example of an entity set:

Nevertheless, it works in a List Report I quickly developed for the matter of testing.

Let me know if you have any solution to this kind of problem.

Looking forward to any kind of feedback,
Tyler



** Here are the CDS Views: **
Cube:

@AbapCatalog.sqlViewName: 'ZCDS_PROD_CUBE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Analytics.dataCategory: #CUBE
@Analytics.dataExtraction.enabled: true
@VDM.viewType: #COMPOSITE


define view ZCDS_PROD_CUBE_V
    as select from zip_producao as cube
    association [1..1] to I_CalendarDate as _date on $projection.hsdat = _date.CalendarDate
    association [1..1] to I_Material as _mat on $projection.matnr = _mat.Material
    association [1..1] to I_CompanyCode as _bukrs on $projection.bukrs = _bukrs.CompanyCode
    association [1..1] to I_Plant as _werks on $projection.werks = _werks.Plant    
    association [1..1] to I_StorageLocation as _lgort on $projection.lgort = _lgort.StorageLocation      
    association [1..1] to ZCDS_PROD_DIM_FASE as _fase on $projection.fase = _fase.fase
    {               
        (...)


        @EndUserText.label: 'Material'  
        @Consumption.valueHelp: '_mat'
        @ObjectModel.foreignKey.association: '_mat'
        @Consumption.filter: { selectionType: #SINGLE, multipleSelections: false, mandatory: false }          
        matnr,


        (...)
    }

Consumption View:

@AbapCatalog.sqlViewName: 'ZCDS_PROD_ALP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION 
@Analytics.query: true
@OData.publish: true
@Analytics.dataExtraction.enabled: true

(.. UI Annotations ..)


define view ZCDS_PROD_ALP_DDL
    as select from ZCDS_PROD_CUBE_V 
    {        
            (...)

            @AnalyticsDetails.query.sortDirection: #ASC             
            @AnalyticsDetails.query.axis: #ROWS              
            @Consumption.valueHelp: '_mat'
            @ObjectModel.foreignKey.association: '_mat'            
            @Consumption.filter: { selectionType: #SINGLE, multipleSelections: false, mandatory: false }
            @AnalyticsDetails.query.display: #KEY_TEXT                                    
            @UI.selectionField.position: 60
            @UI.lineItem.position: 60        
            key matnr,    
  
            (...)
     }
0 Kudos

Hello Tejas,

Thanks for your answer.

I have used Abap CDS view currently, for value help they provide multiple entity set and one custom entity set. Now I am using one valueHelp entity set(C_MM_CompanyCodeValueHelpType) to show filter F4 help for Company code. Now when I have added valuelist to this entity set then no Select from list is coming in F4 help. And if I have used valuelist in custom entity set(ZC_BU_POITEMKPI_C008Type) then Select from list is coming but no data is coming. Because Company code data list is present in C_MM_CompanyCodeValueHelpType.

<Annotations Target="Z_SCORE_KPI_SRV.ZC_BU_POITEMKPI_C008Type/CompanyCodeH"> <Annotation Term="Common.ValueList"> <Record Type="Common.ValueListType"> <PropertyValue Property="CollectionPath" String="CompanyCodeH"/> <PropertyValue Property="Label" String="CompanyCode"/> <PropertyValue Property="SearchSupported" Bool="true"/> <PropertyValue Property="Parameters"> <Collection> <Record Type="Common.ValueListParameterInOut"> <PropertyValue Property="LocalDataProperty" PropertyPath="CompanyCodeH"/> <PropertyValue Property="ValueListProperty" String="Company Code"/> </Record> <Record Type="Common.ValueListParameterDisplayOnly"> <PropertyValue Property="ValueListProperty" String="CompanyCode"/> </Record> </Collection> </PropertyValue> </Record> </Annotation> </Annotations>

<Annotations Target="Z_SCORE_KPI_SRV.C_MM_CompanyCodeValueHelpType/CompanyCode"> <Annotation Term="Common.ValueList"> <Record Type="Common.ValueListType"> <PropertyValue Property="CollectionPath" String="CompanyCodeH"/> <PropertyValue Property="Label" String="Company Code"/> <PropertyValue Property="SearchSupported" Bool="false"/> <PropertyValue Property="Parameters"> <Collection> <Record Type="Common.ValueListParameterInOut"> <PropertyValue Property="LocalDataProperty" PropertyPath="CompanyCode"/> <PropertyValue Property="ValueListProperty" String="CompanyCodeH"/> </Record> <Record Type="Common.ValueListParameterDisplayOnly"> <PropertyValue Property="ValueListProperty" String="CompanyCodeName"/> </Record> </Collection> </PropertyValue> </Record> </Annotation> </Annotations>

My query is how can I get company code data in resepective filter value help. Please find attach files with screenshots.

no-select-from-list.png

f4help-select-from-list.png

scor-kpi-target.png

data-companycode-table-chart.png

former_member182874
Active Contributor
0 Kudos

Hi Biplab,

Value help doesn't come by default. You have to add associations in your consumption CDS view as _companyCode or use standard I_CompanyCode(example don't remember exact name). And pass the association in your @consumption annotation in your property while defining in @UI.Selectionfields for company code.

Also please don't use version 1.58 as this is not stable yet. You should be using 1.56.8 or 11. 1.58 is by far the beta version as per SAP.

Regards,

Tejas