4 weeks ago
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
@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
Request clarification before answering.
User | Count |
---|---|
40 | |
15 | |
10 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.