Skip to Content
avatar image
Former Member

Regarding the configuration of Visual Filter in Analytical List Report

Dear SAPer,

I'm new with ALP and has met with configuration (annotation) issue with ALP. I keep receive such error as "Uncaught (in promise) TypeError: Cannot read property 'PHASE_ID' of undefined", But I couldn't figure out where my annotation is wrong. Could you please help point it out for me?

As has pasted below, it is a very simple ALP application.

For the sake of debugging, I merge all the annotation into the metadata.xml but it still doesn't work.

I tried to create a visual filter on field PHASE_ID out of Entity ProjectDetail.

The value help is based on the same Entity. I created a ValueFilter under the target of ProjectDetailType/PHASE_ID and one presentationVariant, one UI.Chart and one selectionFields under the target of ProjectDetailType. But the visual filter is not visible...

metadata.xml:

http://schemas.microsoft.com/ado/2007/06/edmx" Version="1.0">


https://refapps-w3763b655.dispatcher.int.sap.hana.ondemand.com/sap/opu/odata/IWFND/CATALOGSERVICE;v=2/Vocabularies(TechnicalName='%2FIWBEP%2FVOC_COMMON',Version='0001',SAP__Origin='LOCAL')/$value" xmlns:edmx=" http://docs.oasis-open.org/odata/ns/edmx">
<edmx:Include Namespace="com.sap.vocabularies.Common.v1" Alias="Common"/>
</edmx:Reference>
https://wiki.scn.sap.com/wiki/download/attachments/448470968/UI.xml?api=v2" xmlns:edmx=" http://docs.oasis-open.org/odata/ns/edmx">
<edmx:Include Alias="UI" Namespace="com.sap.vocabularies.UI.v1"/>
</edmx:Reference>


http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" m:DataServiceVersion="2.0">
http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m=" http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns=" http://schemas.microsoft.com/ado/2008/09/edm" Namespace="I042500_PROJ.odata.project">

<EntityType Name="ProjectDetailType">
<Key>
<PropertyRef Name="PID"/>
</Key>
<Property Name="PID" Type="Edm.Int32" Nullable="false"/>
<Property Name="P_NAME" Type="Edm.String" MaxLength="100"/>
<Property Name="CID" Type="Edm.Int32"/>
<Property Name="C_NAME" Type="Edm.String" MaxLength="100"/>
<Property Name="PHASE_ID" Type="Edm.Int32"/>
<Property Name="COST_PLANNED" Type="Edm.Double"/>
<Property Name="COST_PREDICTED" Type="Edm.Double"/>
<Property Name="COST_DIFF_RATIO" Type="Edm.Double"/>
<Property Name="GROSS_MARGIN" Type="Edm.Double"/>
<Property Name="CR_NUMBER" Type="Edm.Int32"/>
<Property Name="ISSUE_NOT_CLOSED" Type="Edm.Int32"/>
<Property Name="RISK_NOT_CLOSED" Type="Edm.Int32"/>
<NavigationProperty Name="_CurrentMileStone" Relationship="I042500_PROJ.odata.project.A_CurrentMileStoneType" FromRole="ProjectDetailPrincipal" ToRole="CurrentMileStoneDependent"/>
<NavigationProperty Name="_Milestones" Relationship="I042500_PROJ.odata.project.A_MilestonesType" FromRole="ProjectDetailPrincipal" ToRole="MilestonesDependent"/>
</EntityType>


<EntityType Name="CurrentMileStoneType">
<Key>
<PropertyRef Name="PID"/>
</Key>
<Property Name="PID" Type="Edm.Int32" Nullable="false"/>
<Property Name="MID" Type="Edm.Int32" Nullable="false"/>
<Property Name="M_NAME" Type="Edm.String" MaxLength="100"/>
<Property Name="IS_DELAYED" Type="Edm.Int32" Nullable="false"/>
<Property Name="DAYS_DELAYED" Type="Edm.Int32"/>
</EntityType>


<EntityType Name="MilestonesType">
<Key>
<PropertyRef Name="PID"/>
<PropertyRef Name="MID"/>
</Key>
<Property Name="PID" Type="Edm.Int32" Nullable="false"/>
<Property Name="MID" Type="Edm.Int32" Nullable="false"/>
<Property Name="M_NAME" Type="Edm.String" MaxLength="100"/>
<Property Name="IS_DELAYED" Type="Edm.Int32" Nullable="false"/>
<Property Name="DAYS_DELAYED" Type="Edm.Int32"/>
<Property Name="SDATE_PLANNED" Type="Edm.DateTime"/>
<Property Name="SDATE_ACTUAL" Type="Edm.DateTime"/>
<Property Name="EDATE_PLANNED" Type="Edm.DateTime"/>
<Property Name="EDATE_PREDICTED" Type="Edm.DateTime"/>
<Property Name="EDATE_ACTUAL" Type="Edm.DateTime"/>
<Property Name="IS_CURRENT" Type="Edm.Int32"/>
</EntityType>


<Association Name="A_CurrentMileStoneType">
<End Type="I042500_PROJ.odata.project.ProjectDetailType" Role="ProjectDetailPrincipal" Multiplicity="1"/>
<End Type="I042500_PROJ.odata.project.CurrentMileStoneType" Role="CurrentMileStoneDependent" Multiplicity="1"/>
</Association>


<Association Name="A_MilestonesType">
<End Type="I042500_PROJ.odata.project.ProjectDetailType" Role="ProjectDetailPrincipal" Multiplicity="1"/>
<End Type="I042500_PROJ.odata.project.MilestonesType" Role="MilestonesDependent" Multiplicity="*"/>
</Association>


<EntityContainer Name="project" m:IsDefaultEntityContainer="true">
<EntitySet Name="ProjectDetail" EntityType="I042500_PROJ.odata.project.ProjectDetailType"/>
<EntitySet Name="CurrentMileStone" EntityType="I042500_PROJ.odata.project.CurrentMileStoneType"/>
<EntitySet Name="Milestones" EntityType="I042500_PROJ.odata.project.MilestonesType"/>
<AssociationSet Name="A_CurrentMileStone" Association="I042500_PROJ.odata.project.A_CurrentMileStoneType">
<End Role="ProjectDetailPrincipal" EntitySet="ProjectDetail"/>
<End Role="CurrentMileStoneDependent" EntitySet="CurrentMileStone"/>
</AssociationSet>
<AssociationSet Name="A_Milestones" Association="I042500_PROJ.odata.project.A_MilestonesType">
<End Role="ProjectDetailPrincipal" EntitySet="ProjectDetail"/>
<End Role="MilestonesDependent" EntitySet="Milestones"/>
</AssociationSet>
</EntityContainer>


http://docs.oasis-open.org/odata/ns/edm">

<Annotation Term="Common.ValueList">
<Record>
<PropertyValue Property="Label" String="Project Phase"/>
<PropertyValue Property="CollectionPath" String="ProjectDetail"/>
<PropertyValue Bool="false" Property="SearchSupported"/>
<PropertyValue Property="Parameters">

<Collection>
<Record Type="Common.ValueListParameterInOut">
<PropertyValue Property="LocalDataProperty" PropertyPath="PHASE_ID"/>
<PropertyValue Property="ValueListProperty" PropertyPath="PHASE_ID"/>
</Record>
</Collection>

</PropertyValue>
<PropertyValue Property="PresentationVariantQualifier" String="PV_PHASE"/>
</Record>
</Annotation>
</Annotations>

http://docs.oasis-open.org/odata/ns/edm">

<Annotation Term="UI.SelectionFields">
<Collection>
<PropertyPath>PHASE_ID</PropertyPath>
</Collection>
</Annotation>

<Annotation Term="UI.LineItem">
<Collection>
<Record Type="UI.DataField">
<PropertyValue Property="Value" Path="P_NAME"/>
<PropertyValue Property="Label" String="{@i18n>PROJECT_NAME}"/>
</Record>
<Record Type="UI.DataField">
<PropertyValue Property="Value" Path="C_NAME"/>
<PropertyValue Property="Label" String="{@i18n>CUSTOMER_NAME}"/>
</Record>
<Record Type="UI.DataField">
<PropertyValue Property="Value" Path="_CurrentMileStone/M_NAME"/>
<PropertyValue Property="Label" String="{@i18n>CURRENT_MILESTONE}"/>
</Record>
</Collection>
</Annotation>

<Annotation Term="UI.PresentationVariant" Qualifier="PV_PHASE">
<Record Type="UI.PresentationVariantType">
<PropertyValue Property="SortOrder"/>
<PropertyValue Property="GroupBy">
<Collection>
<PropertyPath>PHASE_ID</PropertyPath>
</Collection>
</PropertyValue>
<PropertyValue Property="TotalBy"/>
<PropertyValue Property="Total"/>
<PropertyValue Property="Visualizations">
<Collection>
<AnnotationPath>@UI.Chart#DETAIL_PHASE_ID</AnnotationPath>
</Collection>
</PropertyValue>
<PropertyValue Property="RequestAtLeast"/>
</Record>
</Annotation>

<Annotation Term="UI.Chart" Qualifier="DETAIL_PHASE_ID">
<Record Type="UI.ChartDefinitionType">
<PropertyValue Property="ChartType" EnumMember="UI.ChartType/Donut"/>

<PropertyValue Property="Measures">
<Collection>
<PropertyPath>CR_NUMBER</PropertyPath>
</Collection>
</PropertyValue>


<PropertyValue Property="MeasureAttributes">
<Collection>
<Record Type="UI.ChartMeasureAttributeType">
<PropertyValue Property="Measure" PropertyPath="CR_NUMBER"/>
<PropertyValue Property="Role" EnumMember="UI.ChartMeasureRoleType/Axis1"/>
</Record>
</Collection>
</PropertyValue>


<PropertyValue Property="Dimensions">
<Collection>
<PropertyPath>PHASE_ID</PropertyPath>
</Collection>
</PropertyValue>
<PropertyValue Property="DimensionAttributes">
<Collection>
<Record Type="UI.ChartDimensionAttributeType">
<PropertyValue Property="Dimension" PropertyPath="PHASE_ID"/>
<PropertyValue Property="Role" EnumMember="UI.ChartDimensionRoleType/Category"/>
</Record>
</Collection>
</PropertyValue>


<PropertyValue Property="Actions"/>
</Record>
</Annotation>


</Annotations>
</Schema>
</edmx:DataServices>
</edmx:Edmx>

Thanks and Best Regards

Shady

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 16 at 04:01 AM

    Hi Shady ,

    Good day

    I am also facing the same issue. were you able to resolve it . If yes can you please let me know the solution for this.

    Thanks,

    Saranya Sakthi.

    Add comment
    10|10000 characters needed characters exceeded