Skip to Content
0
Jun 19, 2018 at 05:58 PM

Fiori Element Default Grouping not working properly

248 Views

Dear experts,

I am trying to achieve default grouping by Sales Document Number in Fiori Element using Analytical Table. Please refer to the following screen shot as result.

There are duplicate entries and also expend doesn't show the grouped items.

Here is the annotation from WebIDE:

And metadata:

<?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="ZGC_MOCK_SRV" xml:lang="en" sap:schema-version="1" xmlns="http://schemas.microsoft.com/ado/2008/09/edm">
      <EntityType Name="zcomplete" sap:semantics="aggregate" sap:content-version="1">
        <Key>
          <PropertyRef Name="GeneratedId"/>
          <PropertyRef Name="SalesDocument"/>
          <PropertyRef Name="SalesDocumentItem"/>
        </Key><Property Name="GeneratedId" Type="Edm.String" Nullable="false" MaxLength="32" sap:unicode="false" sap:creatable="false"
          sap:updatable="false" sap:sortable="false" sap:filterable="false"/>
        <Property Name="SalesDocument" Type="Edm.String" Nullable="false" MaxLength="10" sap:aggregation-role="dimension" sap:unicode="false"
          sap:creatable="false" sap:updatable="false" sap:filterable="false"/>
        <Property Name="SalesDocumentItem" Type="Edm.String" Nullable="false" MaxLength="6" sap:aggregation-role="dimension" sap:unicode="false"
          sap:creatable="false" sap:updatable="false" sap:sortable="false" sap:filterable="false"/>
        <Property Name="GroupingRule" Type="Edm.String" Nullable="false" MaxLength="32" sap:unicode="false" sap:creatable="false"
          sap:updatable="false" sap:sortable="false" sap:filterable="false"/>
        <Property Name="AvgCurrentPercentage" Type="Edm.Int16" Nullable="false" sap:unicode="false" sap:label="Signed INT2 / int16"
          sap:creatable="false" sap:updatable="false" sap:sortable="false" sap:filterable="false"/>
        <Property Name="CurrentPercentage" Type="Edm.Int16" Nullable="false" sap:aggregation-role="measure" sap:unicode="false"
          sap:label="Signed INT2 / int16" sap:creatable="false" sap:updatable="false" sap:sortable="false" sap:filterable="false"/></EntityType>
      <EntityContainer Name="ZGC_MOCK_SRV_Entities" m:IsDefaultEntityContainer="true" sap:supported-formats="atom json xlsx">
        <EntitySet Name="zcomplete_set" EntityType="ZGC_MOCK_SRV.zcomplete" sap:creatable="false" sap:updatable="false" sap:deletable="false"
          sap:searchable="true" sap:pageable="false" sap:content-version="1"/>
      </EntityContainer><atom:link rel="self"
        href="https://webidecp-fiori.dispatcher.int.sap.hana.ondemand.com/destinations/ER9CLNT001/sap/opu/odata/sap/ZGC_MOCK_SRV/$metadata"
        xmlns:atom="http://www.w3.org/2005/Atom"/>
      <atom:link rel="latest-version"
        href="https://webidecp-fiori.dispatcher.int.sap.hana.ondemand.com/destinations/ER9CLNT001/sap/opu/odata/sap/ZGC_MOCK_SRV/$metadata"
        xmlns:atom="http://www.w3.org/2005/Atom"/>
    </Schema>
  </edmx:DataServices>
</edmx:Edmx>


Am I missing something? Any help is appreciated.

Best regards,

Cheng