/scripts/ahub.form.attachments.js
1

Error when using SmartChart

Jun 20, 2017 at 10:53 AM

138

avatar image

Hello,

I am encountering an error when trying to use SmartChart. Following is logged in the browsers Console:

"Uncaught (in promise) Invalid navigation property from parameter entity set to query result in resource path"

The service I am using is an OData service created on a Bex Query.

I am adding the annotations from WebIDE, where I have created an annotations file, that is linked to the model

Can anyone provide me a hint, regarding what could be wrong?

I am posting the contents of the metadata and annotations file below.

Thanks,

Gerald

annotation.xml:

<edmx:Edmx xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx" Version="4.0">
	<edmx:Reference xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx"
		Uri="https://webide-s0015740598trial.dispatcher.hanatrial.ondemand.com/destinations/Inspiricon-WS/sap/opu/odata/sap/TBI_02_R33_SRV/$metadata">
		<edmx:Include xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx" Namespace="TBI_02_R33_SRV"/>
	</edmx:Reference>
	<edmx:Reference Uri="http://docs.oasis-open.org/odata/odata-data-aggregation-ext/v4.0/cs02/vocabularies/Org.OData.Aggregation.V1.xml">
		<edmx:Include Alias="Aggregation" Namespace="Org.OData.Aggregation.V1"/>
	</edmx:Reference>
	<edmx:Reference Uri="http://docs.oasis-open.org/odata/odata/v4.0/errata03/os/complete/vocabularies/Org.OData.Capabilities.V1.xml">
		<edmx:Include Alias="Capabilities" Namespace="Org.OData.Capabilities.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:Reference Uri="https://wiki.scn.sap.com/wiki/download/attachments/448470971/Communication.xml?api=v2">
		<edmx:Include Alias="vCard" Namespace="com.sap.vocabularies.Communication.v1"/>
	</edmx:Reference>
	<edmx:Reference Uri="http://docs.oasis-open.org/odata/odata/v4.0/errata03/os/complete/vocabularies/Org.OData.Core.V1.xml">
		<edmx:Include Alias="Core" Namespace="Org.OData.Core.V1"/>
	</edmx:Reference>
	<edmx:Reference Uri="http://docs.oasis-open.org/odata/odata/v4.0/errata03/os/complete/vocabularies/Org.OData.Measures.V1.xml">
		<edmx:Include Alias="CQP" Namespace="Org.OData.Measures.V1"/>
	</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:DataServices>
		<Schema xmlns="http://docs.oasis-open.org/odata/ns/edm">
			<Annotations Target="TBI_02_R33_SRV.TBI_02_R33Result">
				<Annotation Term="UI.Chart">
					<Record Type="UI.ChartDefinitionType">
						<PropertyValue Property="ChartType" EnumMember="UI.ChartType/Column"/>
						<PropertyValue Property="Measures">
							<Collection>
								<PropertyPath>A0EP63AIXTZ46C634DXM6OMRGR</PropertyPath>
								<PropertyPath>A0EP63AIXTZ46C634DXM6OMXSB</PropertyPath>
							</Collection>
						</PropertyValue>
						<PropertyValue Property="Dimensions">
							<Collection>
								<PropertyPath>TBI_MNG</PropertyPath>
								<PropertyPath>TBI_MNG__TBI_DDIV</PropertyPath>
							</Collection>
						</PropertyValue>
					</Record>
				</Annotation>
			</Annotations>
			<Annotations Target="TBI_02_R33_SRV.VAR_20170614134434">
				<Annotation Term="Common.SemanticObject"/>
			</Annotations>
			<Annotations Target="TBI_02_R33_SRV.VAR_20170614134954">
				<Annotation Term="Common.SemanticObject"/>
			</Annotations>
			<Annotations Target="TBI_02_R33_SRV.TBI_02_R33Result/TBI_MNG"/>
			<Annotations Target="TBI_02_R33_SRV.TBI_02_R33Result/TBI_MNG__TBI_DDIV"/>
			<Annotations Target="TBI_02_R33_SRV.TBI_02_R33Parameters/VAR_20170614134434"/>
			<Annotations Target="TBI_02_R33_SRV.TBI_02_R33Parameters/VAR_20170614134434Text"/>
			<Annotations Target="TBI_02_R33_SRV.TBI_02_R33Parameters/VAR_20170614134954"/>
			<Annotations Target="TBI_02_R33_SRV.TBI_02_R33Parameters/VAR_20170614134954Text"/>
		</Schema>
	</edmx:DataServices>
</edmx:Edmx>

$metadata.xml:

<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="1.0" xmlns:edmx="http://schemas.microsoft.com/ado/2007/06/edmx" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:sap="http://www.sap.com/Protocols/SAPData">
	<edmx:DataServices m:DataServiceVersion="2.0">
		<Schema Namespace="TBI_02_R33_SRV" sap:schema-version="1" xml:lang="en" xmlns="http://schemas.microsoft.com/ado/2008/09/edm">
			<EntityType Name="TBI_02_R33Result" sap:content-version="1" sap:semantics="aggregate">
				<Key>
					<PropertyRef Name="ID"/>
				</Key>
				<Property Name="ID" Nullable="false" Type="Edm.String" sap:label="ID" sap:updatable="false"/>
				<Property Name="TotaledProperties" Type="Edm.String" sap:aggregation-role="totaled-properties-list" sap:is-annotation="true" sap:label="Totaled Properties" sap:updatable="false"/>
				<Property MaxLength="30" Name="TBI_MNG__TBI_DDIV" Type="Edm.String" sap:aggregation-role="dimension" sap:creatable="false" sap:label="Division" sap:updatable="false"/>
				<Property MaxLength="30" Name="TBI_MNG" Type="Edm.String" sap:aggregation-role="dimension" sap:creatable="false" sap:label="Manager" sap:updatable="false"/>
				<Property MaxLength="30" Name="TBI_MNG_N" Type="Edm.String" sap:filterable="false" sap:hierarchy-node-for="TBI_MNG" sap:label="Manager Node ID"/>
				<Property MaxLength="60" Name="TBI_MNG_P" Type="Edm.String" sap:filterable="false" sap:hierarchy-parent-node-for="TBI_MNG_N" sap:label="Manager Parent ID"/>
				<Property Name="TBI_MNG_L" Type="Edm.Int16" sap:filterable="false" sap:hierarchy-level-for="TBI_MNG_N" sap:label="Manager Level"/>
				<Property MaxLength="9" Name="TBI_MNG_D" Type="Edm.String" sap:filterable="false" sap:hierarchy-drill-state-for="TBI_MNG_N" sap:is-annotation="true" sap:label="Manager Drilldown State"/>
				<Property Name="A0EP63AIXTZ46C634DXM6OMRGR" Precision="36" Scale="16" Type="Edm.Decimal" sap:aggregation-role="measure" sap:creatable="false" sap:filterable="false" sap:label="Plan Sales" sap:text="A0EP63AIXTZ46C634DXM6OMRGR_F" sap:updatable="false"/>
				<Property MaxLength="60" Name="A0EP63AIXTZ46C634DXM6OMRGR_F" Type="Edm.String" sap:creatable="false" sap:filterable="false" sap:label="Plan Sales (Formatted)" sap:updatable="false"/>
				<Property Name="A0EP63AIXTZ46C634DXM6OMXSB" Precision="36" Scale="16" Type="Edm.Decimal" sap:aggregation-role="measure" sap:creatable="false" sap:filterable="false" sap:label="Actual Sales" sap:text="A0EP63AIXTZ46C634DXM6OMXSB_F" sap:updatable="false"/>
				<Property MaxLength="60" Name="A0EP63AIXTZ46C634DXM6OMXSB_F" Type="Edm.String" sap:creatable="false" sap:filterable="false" sap:label="Actual Sales (Formatted)" sap:updatable="false"/>
				<Property Name="A0EP63AIXTZ46C634DXM6ON43V" Precision="36" Scale="16" Type="Edm.Decimal" sap:aggregation-role="measure" sap:creatable="false" sap:filterable="false" sap:label="Quantity Sold-Actual" sap:text="A0EP63AIXTZ46C634DXM6ON43V_F" sap:updatable="false"/>
				<Property MaxLength="60" Name="A0EP63AIXTZ46C634DXM6ON43V_F" Type="Edm.String" sap:creatable="false" sap:filterable="false" sap:label="Quantity Sold-Actual (Formatted)" sap:updatable="false"/>
				<Property Name="A0EP63AIXTZ46C634DXM6ONAFF" Precision="36" Scale="16" Type="Edm.Decimal" sap:aggregation-role="measure" sap:creatable="false" sap:filterable="false" sap:label="Quantity Sold-Plan" sap:text="A0EP63AIXTZ46C634DXM6ONAFF_F" sap:updatable="false"/>
				<Property MaxLength="60" Name="A0EP63AIXTZ46C634DXM6ONAFF_F" Type="Edm.String" sap:creatable="false" sap:filterable="false" sap:label="Quantity Sold-Plan (Formatted)" sap:updatable="false"/>
			</EntityType>
			<EntityType Name="TBI_02_R33Parameters" sap:content-version="1" sap:semantics="parameters">
				<Key>
					<PropertyRef Name="VAR_20170614134434"/>
					<PropertyRef Name="VAR_20170614134954"/>
				</Key>
				<Property MaxLength="30" Name="VAR_20170614134434" Nullable="false" Type="Edm.String" sap:filterable="false" sap:label="Div Var" sap:parameter="optional" sap:text="VAR_20170614134434Text"/>
				<Property MaxLength="60" Name="VAR_20170614134434Text" Type="Edm.String" sap:filterable="false"/>
				<Property MaxLength="30" Name="VAR_20170614134954" Nullable="false" Type="Edm.String" sap:filterable="false" sap:label="Man Var" sap:parameter="optional" sap:text="VAR_20170614134954Text"/>
				<Property MaxLength="60" Name="VAR_20170614134954Text" Type="Edm.String" sap:filterable="false"/>
				<NavigationProperty FromRole="ToRole_VAR_20170614134434ToListOfValues" Name="VAR_20170614134434Details" Relationship="TBI_02_R33_SRV.VAR_20170614134434ToListOfValues" ToRole="FromRole_VAR_20170614134434ToListOfValues"/>
				<NavigationProperty FromRole="ToRole_VAR_20170614134954ToListOfValues" Name="VAR_20170614134954Details" Relationship="TBI_02_R33_SRV.VAR_20170614134954ToListOfValues" ToRole="FromRole_VAR_20170614134954ToListOfValues"/>
				<NavigationProperty FromRole="FromRole_TBI_02_R33ParametersToResult" Name="Results" Relationship="TBI_02_R33_SRV.TBI_02_R33ParametersToResult" ToRole="ToRole_TBI_02_R33ParametersToResult"/>
			</EntityType>
			<EntityType Name="VAR_20170614134434" sap:content-version="1">
				<Key>
					<PropertyRef Name="VAR_20170614134434_ID"/>
				</Key>
				<Property MaxLength="30" Name="VAR_20170614134434_ID" Nullable="false" Type="Edm.String" sap:creatable="false" sap:label="Div Var" sap:text="Text" sap:updatable="false"/>
				<Property Name="VAR_20170614134434_TEXT" Type="Edm.String" sap:creatable="false" sap:filterable="false" sap:updatable="false"/>
			</EntityType>
			<EntityType Name="VAR_20170614134954" sap:content-version="1">
				<Key>
					<PropertyRef Name="VAR_20170614134954_ID"/>
				</Key>
				<Property MaxLength="30" Name="VAR_20170614134954_ID" Nullable="false" Type="Edm.String" sap:creatable="false" sap:label="Man Var" sap:text="Text" sap:updatable="false"/>
				<Property Name="VAR_20170614134954_TEXT" Type="Edm.String" sap:creatable="false" sap:filterable="false" sap:updatable="false"/>
			</EntityType>
			<Association Name="VAR_20170614134434ToListOfValues" sap:content-version="1">
				<End Multiplicity="1" Role="FromRole_VAR_20170614134434ToListOfValues" Type="TBI_02_R33_SRV.VAR_20170614134434"/>
				<End Multiplicity="*" Role="ToRole_VAR_20170614134434ToListOfValues" Type="TBI_02_R33_SRV.TBI_02_R33Parameters"/>
				<ReferentialConstraint>
					<Principal Role="FromRole_VAR_20170614134434ToListOfValues">
						<PropertyRef Name="VAR_20170614134434_ID"/>
					</Principal>
					<Dependent Role="ToRole_VAR_20170614134434ToListOfValues">
						<PropertyRef Name="VAR_20170614134434"/>
					</Dependent>
				</ReferentialConstraint>
			</Association>
			<Association Name="VAR_20170614134954ToListOfValues" sap:content-version="1">
				<End Multiplicity="1" Role="FromRole_VAR_20170614134954ToListOfValues" Type="TBI_02_R33_SRV.VAR_20170614134954"/>
				<End Multiplicity="*" Role="ToRole_VAR_20170614134954ToListOfValues" Type="TBI_02_R33_SRV.TBI_02_R33Parameters"/>
				<ReferentialConstraint>
					<Principal Role="FromRole_VAR_20170614134954ToListOfValues">
						<PropertyRef Name="VAR_20170614134954_ID"/>
					</Principal>
					<Dependent Role="ToRole_VAR_20170614134954ToListOfValues">
						<PropertyRef Name="VAR_20170614134954"/>
					</Dependent>
				</ReferentialConstraint>
			</Association>
			<Association Name="TBI_02_R33ParametersToResult" sap:content-version="1">
				<End Multiplicity="1" Role="FromRole_TBI_02_R33ParametersToResult" Type="TBI_02_R33_SRV.TBI_02_R33Parameters"/>
				<End Multiplicity="*" Role="ToRole_TBI_02_R33ParametersToResult" Type="TBI_02_R33_SRV.TBI_02_R33Result"/>
			</Association>
			<EntityContainer Name="TBI_02_R33_SRV_Entities" m:IsDefaultEntityContainer="true" sap:supported-formats="atom json xlsx">
				<EntitySet EntityType="TBI_02_R33_SRV.TBI_02_R33Parameters" Name="TBI_02_R33" sap:content-version="1" sap:creatable="false" sap:deletable="false" sap:updatable="false"/>
				<EntitySet EntityType="TBI_02_R33_SRV.VAR_20170614134434" Name="VAR_20170614134434" sap:content-version="1" sap:creatable="false" sap:deletable="false" sap:updatable="false"/>
				<EntitySet EntityType="TBI_02_R33_SRV.VAR_20170614134954" Name="VAR_20170614134954" sap:content-version="1" sap:creatable="false" sap:deletable="false" sap:updatable="false"/>
				<EntitySet EntityType="TBI_02_R33_SRV.TBI_02_R33Result" Name="TBI_02_R33Results" sap:content-version="1" sap:creatable="false" sap:deletable="false" sap:updatable="false"/>
				<AssociationSet Association="TBI_02_R33_SRV.VAR_20170614134954ToListOfValues" Name="VAR_20170614134954ToListOfValues_AssocSe" sap:content-version="1" sap:creatable="false" sap:deletable="false" sap:updatable="false">
					<End EntitySet="VAR_20170614134954" Role="FromRole_VAR_20170614134954ToListOfValues"/>
					<End EntitySet="TBI_02_R33" Role="ToRole_VAR_20170614134954ToListOfValues"/>
				</AssociationSet>
				<AssociationSet Association="TBI_02_R33_SRV.VAR_20170614134434ToListOfValues" Name="VAR_20170614134434ToListOfValues_AssocSe" sap:content-version="1" sap:creatable="false" sap:deletable="false" sap:updatable="false">
					<End EntitySet="VAR_20170614134434" Role="FromRole_VAR_20170614134434ToListOfValues"/>
					<End EntitySet="TBI_02_R33" Role="ToRole_VAR_20170614134434ToListOfValues"/>
				</AssociationSet>
				<AssociationSet Association="TBI_02_R33_SRV.TBI_02_R33ParametersToResult" Name="TBI_02_R33ParametersToResult_AssocSet" sap:content-version="1" sap:creatable="false" sap:deletable="false" sap:updatable="false">
					<End EntitySet="TBI_02_R33" Role="FromRole_TBI_02_R33ParametersToResult"/>
					<End EntitySet="TBI_02_R33Results" Role="ToRole_TBI_02_R33ParametersToResult"/>
				</AssociationSet>
			</EntityContainer>
			<atom:link href="https://webidetesting2907460-s0015740598trial.dispatcher.hanatrial.ondemand.com/sap/opu/odata/sap/TBI_02_R33_SRV/$metadata" rel="self" xmlns:atom="http://www.w3.org/2005/Atom"/>
			<atom:link href="https://webidetesting2907460-s0015740598trial.dispatcher.hanatrial.ondemand.com/sap/opu/odata/sap/TBI_02_R33_SRV/$metadata" rel="latest-version" xmlns:atom="http://www.w3.org/2005/Atom"/>
		</Schema>
	</edmx:DataServices>
</edmx:Edmx>
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Gerald,

Facing the exact same problem. Did you manage to figure it out?

Regards,

Yiannis

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mariana Naboka
Oct 12, 2017 at 03:26 PM
0

Hi Gerald,

do you see any errors when opening your annotation file with Annotation Modeler?

Best Regards,

Mariana

Share
10 |10000 characters needed characters left characters exceeded
Skip to Content