Skip to Content

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

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.

query-browser.png (169.9 kB)
scor-kpi-data1.png (103.6 kB)
company-list.png (185.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 23, 2018 at 06:13 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 27, 2018 at 06:43 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 05, 2018 at 10:09 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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_cache=true

      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,    
        
                  (...)
           }
      
      p.png (37.2 kB)
      xx.png (18.7 kB)