Visual Filter is not appearing

former_member659091 · ‎03-10-2020

Hi, I just recently started working on SAP and while I managed to create an ALP using a Calc View OData as the source, for some reason the Visual Filter does not appear, it is worth noting that the compact filter boxes do. I was wondering what did I do wrong or what did I miss, thank you in advance for your help.

Here is what I've done so far:

1. Annotation file:

<edmx:Edmx xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx" Version="4.0">
	<edmx:Reference Uri="/ServiceNS/services/sd/presupuesto/services/presupuesto.xsodata/$metadata">
		<edmx:Include Alias="Metadata" Namespace="ServiceNS.services.sd.presupuesto.services.presupuesto"/>
	</edmx:Reference>
	<edmx:Reference Uri="https://wiki.scn.sap.com/wiki/download/attachments/448470968/UI.xml?api=v2">
		<edmx:Include Alias="UI" Namespace="com.sap.vocabularies.UI.v1"/>
	</edmx:Reference>
	<edmx:Reference Uri="https://wiki.scn.sap.com/wiki/download/attachments/448470974/Common.xml?api=v2">
		<edmx:Include Alias="Common" Namespace="com.sap.vocabularies.Common.v1"/>
	</edmx:Reference>
	<edmx:DataServices>
		<Schema xmlns="http://docs.oasis-open.org/odata/ns/edm"
			Namespace="testAnalytic.annotations.annotation0.ServiceNS.services.sd.presupuesto.services.presupuesto">
			<Annotations Target="Metadata.analyticsTotalVendedorType">
				<Annotation Term="UI.SelectionFields">
					<Collection>
						<PropertyPath>AMOUNT_FERT</PropertyPath>
						<PropertyPath>AMOUNT_FITO</PropertyPath>
						<PropertyPath>AMOUNT_SEMI</PropertyPath>
						<PropertyPath>EST_TOTAL</PropertyPath>
						<PropertyPath>FERT_LAST_YEAR_NETO_USD</PropertyPath>
						<PropertyPath>FITO_LAST2_YEAR_NETO_USD</PropertyPath>
						<PropertyPath>FITO_LAST_YEAR_NETO_USD</PropertyPath>
						<PropertyPath>ID</PropertyPath>
						<PropertyPath>NOMBRE_VENDEDOR</PropertyPath>
						<PropertyPath>PART_FITO</PropertyPath>
						<PropertyPath>POTENCIAL_FITO</PropertyPath>
						<PropertyPath>SEMI_LAST_YEAR_NETO_USD</PropertyPath>
						<PropertyPath>VENDEDOR</PropertyPath>
					</Collection>
				</Annotation>
				<Annotation Term="UI.HeaderInfo">
					<Record Type="UI.HeaderInfoType">
						<PropertyValue Property="TypeName" String="{@i18n>ESTIMATE}"/>
						<PropertyValue Property="TypeNamePlural" String="{@i18n>ESTIMATES}"/>
					</Record>
				</Annotation>
				<Annotation Term="UI.Chart">
					<Record Type="UI.ChartDefinitionType">
						<PropertyValue Property="ChartType" EnumMember="UI.ChartType/Column"/>
						<PropertyValue Property="Measures">
							<Collection>
								<PropertyPath>EST_TOTAL</PropertyPath>
							</Collection>
						</PropertyValue>
						<PropertyValue Property="MeasureAttributes">
							<Collection>
								<Record Type="UI.ChartMeasureAttributeType">
									<PropertyValue Property="Measure" PropertyPath="EST_TOTAL"/>
									<PropertyValue Property="Role" EnumMember="UI.ChartMeasureRoleType/Axis1"/>
								</Record>
							</Collection>
						</PropertyValue>
						<PropertyValue Property="Dimensions">
							<Collection>
								<PropertyPath>NOMBRE_VENDEDOR</PropertyPath>
							</Collection>
						</PropertyValue>
						<PropertyValue Property="DimensionAttributes">
							<Collection>
								<Record Type="UI.ChartDimensionAttributeType">
									<PropertyValue Property="Dimension" PropertyPath="NOMBRE_VENDEDOR"/>
									<PropertyValue Property="Role" EnumMember="UI.ChartDimensionRoleType/Category"/>
								</Record>
							</Collection>
						</PropertyValue>
					</Record>
				</Annotation>
				<Annotation Term="UI.LineItem">
					<Collection>
						<Record Type="UI.DataField">
							<PropertyValue Property="Value" Path="NOMBRE_VENDEDOR"/>
						</Record>
						<Record Type="UI.DataField">
							<PropertyValue Property="Value" Path="FITO_LAST2_YEAR_NETO_USD"/>
						</Record>
						<Record Type="UI.DataField">
							<PropertyValue Property="Value" Path="FITO_LAST_YEAR_NETO_USD"/>
						</Record>
						<Record Type="UI.DataField">
							<PropertyValue Property="Value" Path="POTENCIAL_FITO"/>
						</Record>
						<Record Type="UI.DataField">
							<PropertyValue Property="Value" Path="AMOUNT_FITO"/>
						</Record>
						<Record Type="UI.DataField">
							<PropertyValue Property="Value" Path="PART_FITO"/>
						</Record>
						<Record Type="UI.DataField">
							<PropertyValue Property="Value" Path="FERT_LAST_YEAR_NETO_USD"/>
						</Record>
						<Record Type="UI.DataField">
							<PropertyValue Property="Value" Path="AMOUNT_FERT"/>
						</Record>
						<Record Type="UI.DataField">
							<PropertyValue Property="Value" Path="SEMI_LAST_YEAR_NETO_USD"/>
						</Record>
						<Record Type="UI.DataField">
							<PropertyValue Property="Value" Path="AMOUNT_SEMI"/>
						</Record>
						<Record Type="UI.DataField">
							<PropertyValue Property="Value" Path="EST_TOTAL"/>
						</Record>
					</Collection>
				</Annotation>
			</Annotations>
			<Annotations Target="Metadata.analyticsTotalVendedorType/EST_TOTAL">
				<Annotation Term="Common.ValueList">
					<Record Type="Common.ValueListType">
						<PropertyValue Property="CollectionPath" String="AnalyticsTotalVendedor"/>
						<PropertyValue Property="PresentationVariantQualifier" String="EST_TOTAL"/>
					</Record>
				</Annotation>
			</Annotations>
		</Schema>
	</edmx:DataServices>
</edmx:Edmx>

2. manifest.json:

{
"_version": "1.7.0",
"sap.app": {
"id": "nsa.budget.analytics.testAnalytic",
"type": "application",
"i18n": "i18n/i18n.properties",
"applicationVersion": {
"version": "1.0.0"
},
"title": "{{appTitle}}",
"description": "{{appDescription}}",
"tags": {
"keywords": []
},
"dataSources": {
"mainService": {
"uri": "/ServiceNS/services/sd/presupuesto/services/presupuesto.xsodata/",
"type": "OData",
"settings": {
"odataVersion": "2.0",
"localUri": "localService/metadata.xml",
"annotations": [
"annotation0"
]
}
},
"annotation0": {
"type": "ODataAnnotation",
"uri": "annotations/annotation0.xml",
"settings": {
"localUri": "annotations/annotation0.xml"
}
}
},
"offline": false,
"sourceTemplate": {
"id": "ALP_WebIDE_Plugin.analyticallistpage",
"version": "1.41.1"
}
},
"sap.ui": {
"technology": "UI5",
"icons": {
"icon": "",
"favIcon": "",
"phone": "",
"phone@2": "",
"tablet": "",
"tablet@2": ""
},
"deviceTypes": {
"desktop": true,
"tablet": false,
"phone": false
}
},
"sap.ui5": {
"resources": {
"js": [],
"css": []
},
"dependencies": {
"minUI5Version": "1.65.6",
"libs": {
"sap.ui.core": {
"lazy": false
},
"sap.ui.generic.app": {
"lazy": false
},
"sap.suite.ui.generic.template": {
"lazy": false
}
},
"components": {}
},
"models": {
"i18n": {
"preload": false,
"type": "sap.ui.model.resource.ResourceModel",
"uri": "i18n/i18n.properties",
"settings": {
"bundleName": "nsa.budget.analytics.testAnalytic.i18n.i18n"
}
},
"i18n|sap.suite.ui.generic.template.AnalyticalListPage|analyticsTotalVendedor": {
"type": "sap.ui.model.resource.ResourceModel",
"uri": "i18n/AnalyticalListPage/analyticsTotalVendedor/i18n.properties"
},
"i18n|sap.suite.ui.generic.template.ObjectPage|analyticsTotalVendedor": {
"type": "sap.ui.model.resource.ResourceModel",
"uri": "i18n/ObjectPage/analyticsTotalVendedor/i18n.properties"
},
"": {
"preload": true,
"dataSource": "mainService",
"settings": {
"defaultBindingMode": "TwoWay",
"defaultCountMode": "Inline",
"refreshAfterChange": false,
"metadataUrlParams": {
"sap-value-list": "all"
}
}
},
"@i18n": {
"type": "sap.ui.model.resource.ResourceModel",
"uri": "i18n/i18n.properties"
}
},
"extends": {
"extensions": {}
},
"contentDensities": {
"compact": true,
"cozy": false
}
},
"sap.ui.generic.app": {
"_version": "1.3.0",
"settings": {
"objectPageHeaderType": "Dynamic"
},
"pages": {
"AnalyticalListPage|analyticsTotalVendedor": {
"entitySet": "analyticsTotalVendedor",
"component": {
"name": "sap.suite.ui.generic.template.AnalyticalListPage",
"list": true,
"settings": {
"condensedTableLayout": true,
"showGoButtonOnFilterBar": true,
"tableType": "AnalyticalTable",
"multiSelect": false,
"autoHide": true,
"smartVariantManagement": true,
"keyPerformanceIndicators": {}
}
},
"pages": {
"ObjectPage|analyticsTotalVendedor": {
"entitySet": "analyticsTotalVendedor",
"component": {
"name": "sap.suite.ui.generic.template.ObjectPage"
}
}
}
}
}
},
"sap.platform.hcp": {
"uri": ""
}
}

3. metadata.xml: (AnalyticsTotalVendedor is the view from where I get the data)

<EntityType Name="analyticsTotalVendedorType" sap:semantics="aggregate">
<Key><PropertyRef Name="ID"/></Key><Property Name="ID" Type="Edm.String" Nullable="false" MaxLength="2147483647" sap:filterable="false"/><Property Name="NOMBRE_VENDEDOR" Type="Edm.String" MaxLength="35" sap:label="NOMBRE_VENDEDOR" sap:aggregation-role="dimension"/><Property Name="VENDEDOR" Type="Edm.String" MaxLength="10" sap:label="VENDEDOR" sap:aggregation-role="dimension"/><Property Name="FITO_LAST2_YEAR_NETO_USD" Type="Edm.Decimal" Precision="18" Scale="2" sap:filterable="false"
sap:label="FITO_LAST2_YEAR_NETO_USD" sap:aggregation-role="measure"/><Property Name="FITO_LAST_YEAR_NETO_USD" Type="Edm.Decimal" Precision="18" Scale="2" sap:filterable="false"
sap:label="FITO_LAST_YEAR_NETO_USD" sap:aggregation-role="measure"/><Property Name="POTENCIAL_FITO" Type="Edm.Decimal" Precision="18" Scale="2" sap:filterable="false" sap:label="POTENCIAL_FITO"
sap:aggregation-role="measure"/><Property Name="AMOUNT_FITO" Type="Edm.Decimal" Precision="18" Scale="2" sap:filterable="false" sap:label="AMOUNT_FITO"
sap:aggregation-role="measure"/><Property Name="PART_FITO" Type="Edm.Int32" sap:filterable="false" sap:label="PART_FITO" sap:aggregation-role="measure"/><Property Name="AMOUNT_FERT" Type="Edm.Decimal" Precision="18" Scale="2" sap:filterable="false" sap:label="AMOUNT_FERT"
sap:aggregation-role="measure"/><Property Name="FERT_LAST_YEAR_NETO_USD" Type="Edm.Decimal" Precision="18" Scale="2" sap:filterable="false"
sap:label="FERT_LAST_YEAR_NETO_USD" sap:aggregation-role="measure"/><Property Name="SEMI_LAST_YEAR_NETO_USD" Type="Edm.Decimal" Precision="18" Scale="2" sap:filterable="false"
sap:label="SEMI_LAST_YEAR_NETO_USD" sap:aggregation-role="measure"/><Property Name="AMOUNT_SEMI" Type="Edm.Decimal" Precision="18" Scale="2" sap:filterable="false" sap:label="AMOUNT_SEMI"
sap:aggregation-role="measure"/><Property Name="EST_TOTAL" Type="Edm.Decimal" Precision="20" Scale="2" sap:filterable="false" sap:label="EST_TOTAL"
sap:aggregation-role="measure"/></EntityType>

Attached is the rendered ALPresults.png

Visual Filter is not appearing

Accepted Solutions (0)

Answers (0)

S4HANA Cloud - Error Logs

Download large file using REST adapter in SAP PO 7...

How to set the file name in SAPUI5 PDFViewer for b...

Re: How to do data modelling of 200+ plus tables i...

inventory in warehouse report