cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Adapt Filters Fiori could not work (No Data)

Dafintempur77
Newcomer
0 Kudos
108

Dear all,

I have been facing issue that related with Fiori Adapt Filters, especially on Visual Filter,

When I try to use Adapt Filters, it just displays "No Data", How should I do to resolve this issue?
Whereas, The service has been active, and I have tested with SAP Gateway Client the result was 200 Success 

Dafintempur77_0-1749803135947.png

@AbapCatalog.sqlViewName: 'ZSYARD27V_ALP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@OData.publish: true
@EndUserText.label: 'CDS for ALP'


//Logic for KPI card
@UI.selectionPresentationVariant: [
{
//The below qualifier will be there in my mainfest.json file
qualifier: 'KPIORDDIV',
presentationVariantQualifier: 'KPIORDDIVPV',
selectionVariantQualifier: 'KPIORDDIVSEL'
},

{
qualifier: 'KPIORDDIV1',
presentationVariantQualifier: 'KPIORDDIVPV1',
selectionVariantQualifier: 'KPIORDDIVSEL1'
}
]


//Logic for Default Chart w.r.t Sales Organization
@UI.chart: [
{
qualifier: 'chartDefault',
chartType: #COLUMN,
description: 'Sales Information',
dimensions: ['salesorg'],
measures: ['order_qty_total_val'],  //We have to use the Alias Name as Measure in case if we have given so
dimensionAttributes: [{dimension: 'salesorg', role: #CATEGORY }],
measureAttributes: [{measure: 'order_qty_total_val', role: #AXIS_1 }]
},
//Below logic will be for Chart w.r.t Visual Filter
{
qualifier: 'visualDivision',
chartType: #DONUT,
description: 'Division Description',
dimensions: ['divisiondesc'],
measures: ['order_qty_total_val'],
dimensionAttributes: [{dimension: 'divisiondesc', role: #CATEGORY }],
measureAttributes: [{measure: 'order_qty_total_val', role: #AXIS_1 }]
},

//The below Visual Filter is from KPI perspective and not from Visual Filter Perspective
{
qualifier: 'visualDivision1',
chartType: #LINE,
description: 'Division Description',
dimensions: ['divisiondesc'],
measures: ['open_qty_total_val'],
dimensionAttributes: [{dimension: 'divisiondesc', role: #CATEGORY }],
measureAttributes: [{measure: 'open_qty_total_val', role: #AXIS_1 }]
},

{
qualifier: 'visualDistribution',
chartType: #BAR,
description: 'Distribution Channel Description',
dimensions: ['distchldesc'],
measures: ['order_qty_total_val'],
dimensionAttributes: [{dimension: 'distchldesc', role: #CATEGORY }],
measureAttributes: [{measure: 'order_qty_total_val', role: #AXIS_1 }]
},

{
qualifier: 'VisualPlantDesc',
chartType: #LINE,
description: 'Filter by Plant Description',
dimensions: ['plantdesc'],
measures: ['order_qty_total_val'],
dimensionAttributes: [{ dimension: 'plantdesc', role: #CATEGORY }],
measureAttributes: [{ measure: 'order_qty_total_val', role: #AXIS_2 }]
},

{
qualifier: 'visualMonthYear',
chartType: #LINE,
description: 'Sales by Month-Year',
dimensions: ['document_date'],
measures: ['order_qty_total_val'],
dimensionAttributes: [{dimension: 'document_date', role: #CATEGORY }],
measureAttributes: [{measure: 'order_qty_total_val', role: #AXIS_1 }]
}

]

// Presentationvariant -> This is required to generate the UI layout; Without which we wont be able to see
//   the Default Chart
@UI.presentationVariant: [
{
//The qualifier name inside Visualizations have to be same as that give for @ui.chart...and the other main qualifier
//  has to be maintained in the manifest.json file under Settings under pages
qualifier: 'Default', visualizations: [{type: #AS_CHART, qualifier: 'chartDefault' }]
},
//Here we will start adding the Visual Filter Chart Qualifier as in the Presentation Variant Qualifier
{
qualifier: 'PresentationVisualDiv', visualizations: [{type: #AS_CHART, qualifier: 'visualDivision' }]
},

{
qualifier: 'presentationVisualDist', visualizations: [{type: #AS_CHART, qualifier: 'visualDistribution' }]
},

 {
 qualifier: 'PresentationVisualPlnt', visualizations: [{type: #AS_CHART, qualifier: 'VisualPlantDesc' }]
 },

{
qualifier: 'presentationMonthYear', sortOrder: [{ by: 'document_date',direction: #ASC }],
visualizations: [{type: #AS_CHART, qualifier: 'visualMonthYear' }]
},

//The below logic is for KPI card
{
qualifier: 'KPIORDDIVPV',
//The below text is optional as I didn't find any impact in UI
//text: 'KPI: Order Qty by Division',
//The KPI chart w.r.t Dimension will be same as that of Visual Filter
visualizations: [{type: #AS_CHART, qualifier: 'visualDivision' },
{type: #AS_DATAPOINT, qualifier: 'order_qty_total_val' }]
},

//Logic for 2nd KPI card
{
qualifier: 'KPIORDDIVPV1',
visualizations: [{type: #AS_CHART, qualifier: 'visualDivision1' },
{type: #AS_DATAPOINT, qualifier: 'open_qty_total_val' }]
}
]

@UI.selectionVariant: [{
qualifier: 'KPIORDDIVSEL'

}]

@UI.headerInfo: {typeName: 'Sales Report', typeNamePlural: 'Sales Report'}
define view ZCDS_ALP_REPORT as select from ZSALESDATA_HEAD
left outer join t247 as month on  month.spras = $session.system_language
                                  and month.mnr   = substring(documentdate, 5, 2)
{

@UI.lineItem: [{position: 10 }]
@EndUserText.label: 'Sales Document'
key salesdoc,
@UI.lineItem: [{position: 20 }]
key item@<EndUserText.label: 'Item',
key salesorg,
@UI.selectionField: [{position: 10 }]
@UI.lineItem: [{position: 30 }]
@EndUserText.label: 'Plant'
plant,
@UI.lineItem: [{position: 40 }]
@EndUserText.label: 'Plant Description'
plantdesc@<UI.selectionField: [{ position: 20 }],
@UI.selectionField: [{position: 40 }]  //Mandatory for Visual filter and changing the position changes the Visual Filters layput
@UI.lineItem: [{position: 50 }]
@EndUserText.label: 'Division Description'
divisiondesc,
@UI.selectionField: [{position: 30 }]
@UI.lineItem: [{position: 60 }]
@EndUserText.label: 'Distribution Channel Description'
distchldesc,
//The text that we specify as a part of Title; this will get displayed on my KPI..
@UI.dataPoint.title: 'Total Order Quantity Value'
@UI.lineItem: [{position: 70 }]
@EndUserText.label: 'Order Quantity Total Value'
@DefaultAggregation: #SUM
orderqtytotalvalue as order_qty_total_val,
//We will use the document_date alias for showing the output w.r.t Sorted Order (Ascending)
//This annotation renders the Text Element to the UI
@ObjectModel.text.element: ['month_year']
//The below annotation renders only the Text to the UI front-end and the value #TEXT_ONLY is the best option
@UI.textArrangement: #TEXT_ONLY
substring(documentdate, 1, 6) as document_date@<UI.lineItem: [{ position: 80 }] @<UI.selectionField: [{ position: 50 }] @<EndUserText.label: 'Document Date',
//Date Formatting eg:- JAN-2020
concat(concat(month.ktx,'-'),substring(documentdate, 1, 4)) as
month_year,
@DefaultAggregation: #SUM
openqtytotalvalue as open_qty_total_val@<UI.dataPoint.title: 'Total Open Quantity Value' @<EndUserText.label: 'Open Quantity Total Value'
}
{
  "_version": "1.48.0",
  "sap.app": {
    "id": "fiorianalytics",
    "type": "application",
    "i18n": "i18n/i18n.properties",
    "applicationVersion": {
      "version": "0.0.1"
    },
    "title": "{{appTitle}}",
    "description": "{{appDescription}}",
    "resources": "resources.json",
    "sourceTemplate": {
      "id": "@sap/generator-fiori:alp",
      "version": "1.17.3",
      "toolsId": "85af8d2e-e6e7-4ec1-8e23-643077416d97"
    },
    "dataSources": {
      "ZCDS_ALP_REPORT_CDS_VAN": {
        "uri": "/sap/opu/odata/IWFND/CATALOGSERVICE;v=2/Annotations(TechnicalName='ZCDS_ALP_REPORT_CDS_VAN',Version='0001')/$value/",
        "type": "ODataAnnotation",
        "settings": {
          "localUri": "localService/mainService/ZCDS_ALP_REPORT_CDS_VAN.xml"
        }
      },
      "annotation": {
        "type": "ODataAnnotation",
        "uri": "annotations/annotation.xml",
        "settings": {
          "localUri": "annotations/annotation.xml"
        }
      },
      "mainService": {
        "uri": "/sap/opu/odata/sap/ZCDS_ALP_REPORT_CDS/",
        "type": "OData",
        "settings": {
          "annotations": [
            "ZCDS_ALP_REPORT_CDS_VAN",
            "annotation"
          ],
          "localUri": "localService/mainService/metadata.xml",
          "odataVersion": "2.0"
        }
      }
    }
  },
  "sap.ui": {
    "technology": "UI5",
    "icons": {
      "icon": "",
      "favIcon": "",
      "phone": "",
      "phone@2": "",
      "tablet": "",
      "tablet@2": ""
    },
    "deviceTypes": {
      "desktop": true,
      "tablet": true,
      "phone": true
    }
  },
  "sap.ui5": {
    "flexEnabled": true,
    "dependencies": {
      "minUI5Version": "1.108.9",
      "libs": {
        "sap.m": {},
        "sap.ui.core": {},
        "sap.ushell": {},
        "sap.f": {},
        "sap.ui.comp": {},
        "sap.ui.generic.app": {},
        "sap.suite.ui.generic.template": {}
      }
    },
    "contentDensities": {
      "compact": true,
      "cozy": true
    },
    "models": {
      "i18n": {
        "type": "sap.ui.model.resource.ResourceModel",
        "settings": {
          "bundleName": "fiorianalytics.i18n.i18n"
        }
      },
      "": {
        "dataSource": "mainService",
        "preload": true,
        "settings": {
          "defaultBindingMode": "TwoWay",
          "defaultCountMode": "Inline",
          "refreshAfterChange": false,
          "metadataUrlParams": {
            "sap-value-list": "none"
          }
        }
      },
      "@i18n": {
        "type": "sap.ui.model.resource.ResourceModel",
        "uri": "i18n/i18n.properties"
      }
    },
    "resources": {
      "css": []
    },
    "routing": {
      "config": {},
      "routes": [],
      "targets": {}
    }
  },
  "sap.ui.generic.app": {
    "_version": "1.3.0",
    "settings": {
      "forceGlobalRefresh": false,
      "objectPageHeaderType": "Dynamic",
      "considerAnalyticalParameters": true,
      "showDraftToggle": false
    },
    "pages": {
      "AnalyticalListPage|ZCDS_ALP_REPORT": {
        "entitySet": "ZCDS_ALP_REPORT",
        "component": {
          "name": "sap.suite.ui.generic.template.AnalyticalListPage",
          "list": true,
          "settings": {
            "condensedTableLayout": true,
            "showGoButtonOnFilterBar": true,
            "useBatch": false,
            "autoHide": true,
            "qualifier": "Default",
            "smartVariantManagement": false,
            "selectionPresentationVariant": {
        "selectionVariant": "KPIORDDIVSEL",
        "presentationVariant": "KPIORDDIVPV"
      },
            "tableSettings": {
              "multiSelect": false,
              "type": "AnalyticalTable"
            },
            "keyPerformanceIndicators": {}
          }
        },
        "pages": {
          "ObjectPage|ZCDS_ALP_REPORT": {
            "entitySet": "ZCDS_ALP_REPORT",
            "defaultLayoutTypeIfExternalNavigation": "MidColumnFullScreen",
            "component": {
              "name": "sap.suite.ui.generic.template.ObjectPage"
            }
          }
        }
      }
    }
  },
  "sap.fiori": {
    "registrationIds": [],
    "archeType": "analytical"
  }
}



Thank You,
Best Regards.

DafinTempur77

Accepted Solutions (0)

Answers (0)