在分析列表页面的可视过滤器中对数据进行分组

2020-08-22 03:06发布

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


嗨,

我想对特定列的数据进行分组并将其显示在可视过滤器上。

1。 Mockadata,

CUSTOMER_COUNT = MEASURE

RISK_CATEGORY =维度


我要显示具有这三个类别的可视过滤器(条形图)。

2。 Metadata.xml-

 
 <键>
 
 
 
 <属性名称=" IP_FILTER"类型=" Edm.String" Nullable =" false" sap:parameter =" optional" sap:label =" IP_FILTER"/>
 <属性名称=" ANNUAL_LIABILITY"类型=" Edm.String" MaxLength =" 30" sap:filterable =" true" sap:aggregation-role =" measure" sap:label =" ANNUAL LIABILITY"/>
 <属性名称=" ACTUAL_DTR"类型=" Edm.Int32" sap:filterable =" true" sap:label =" ACTUAL_DTR"/>
 <属性名称=" INFLUENCE"类型=" Edm.Int32" sap:aggregation-role =" measure" sap:filterable =" true" sap:label =" INFLUENCE"/>
 <属性名称=" IMPACT"类型=" Edm.Int32" sap:aggregation-role =" measure" sap:filterable =" true" sap:label ="风险"/>
 <属性名称=" DAYS_TO_REACT"类型=" Edm.Int32" sap:filterable =" true" sap:label =" DAYS_TO_REACT"/>
 <属性名称=" PREDICTED_REACTION_DATE"类型=" Edm.DateTime" sap:display-format =" Date" sap:label =" PREDICTED_REACTION_DATE"/>
 <属性名称=" EXT_ID"类型=" Edm.String" MaxLength =" 30" sap:filterable =" true" sap:aggregation-role =" dimension" sap:label ="客户ID"/>
 <属性名称=" NAME"类型=" Edm.String" MaxLength =" 30" sap:aggregation-role =" dimension" sap:filterable =" true" sap:label ="客户名称"/>
 <属性名称=" CUST_ID"类型=" Edm.Int64" sap:filterable =" true" sap:label ="客户ID"/>
 <属性名称=" CURRENCY_DESC"类型=" Edm.String" MaxLength =" 100" sap:label =" DESCRIPTION"/>
 <属性名称=" CURRENCY"类型=" Edm.String" MaxLength =" 100" sap:filterable =" true" sap:label =" STR_VALUE"/>
 
 <属性名称=" IS_SHOW_DETAILS" Type =" Edm.Int32" sap:filterable =" true" sap:label ="在客户详细信息标志中显示数据"/>

 <属性名称=" CUSTOMER_COUNT"类型=" Edm.Int32" sap:aggregation-role =" measure" sap:filterable =" true" sap:label =" CUSTOMER COUNT"/>
 <属性名称=" RISK_CATEGORY" Type =" Edm.String" MaxLength =" 30" sap:filterable =" true" sap:aggregation-role =" dimension" sap:label =" RISK CATEGORY"/>
 

  

2。 Annotation.xml

图表

 
 
 
 
 <收藏>
  CUSTOMER_COUNT 
 
 
 
 <收藏>
 
 
 
 
 
 
 
 <收藏>
  RISK_CATEGORY 
 
 
 
 <收藏>
 
 
 
 
 
 
 
  

演示变量

 
 
 
 <收藏>
  @ UI.Chart#RISKCHART 
 
 
 
 
 <收藏>
  RISK_CATEGORY 
 
 
 
  

VALUELIST

 
 
 
 
 
 
 
  

结果图表-

如您所见,图表似乎只是从RISK_CATEGORY中选择了前3个值,而不是对它们进行了分组。 我也在Presentation变体中指定了GroupBy子句。

4。 Manifest.json-

" AnalyticalListPage | AtRiskCustomers":{
 " entitySet":" AtRiskCustomers",
 "零件": {
 " name":" sap.suite.ui.generic.template.AnalyticalListPage",
 "列表":是的,
 "设置":{
 " multiSelect":是,
 " autoHide":是的,
 " tableType":" ResponsiveTable",
 " defaultContentView":"表格",
 " smartVariantManagement":是的,
 " qualifier":"默认",
 " showGoButtonOnFilterBar":是的,
 " condensedTableLayout":否,
 "关键绩效指标": {}
 }
 },
 "页面":{
 " ObjectPage | AtRiskCustomers":{
 " entitySet":" AtRiskCustomers",
 "零件": {
 "名称":" sap.suite.ui.generic.template.ObjectPage"
 }
 }
 } 

此致

开发

(43.4 kB)

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


嗨,

我想对特定列的数据进行分组并将其显示在可视过滤器上。

1。 Mockadata,

CUSTOMER_COUNT = MEASURE

RISK_CATEGORY =维度


我要显示具有这三个类别的可视过滤器(条形图)。

2。 Metadata.xml-

 
 <键>
 
 
 
 <属性名称=" IP_FILTER"类型=" Edm.String" Nullable =" false" sap:parameter =" optional" sap:label =" IP_FILTER"/>
 <属性名称=" ANNUAL_LIABILITY"类型=" Edm.String" MaxLength =" 30" sap:filterable =" true" sap:aggregation-role =" measure" sap:label =" ANNUAL LIABILITY"/>
 <属性名称=" ACTUAL_DTR"类型=" Edm.Int32" sap:filterable =" true" sap:label =" ACTUAL_DTR"/>
 <属性名称=" INFLUENCE"类型=" Edm.Int32" sap:aggregation-role =" measure" sap:filterable =" true" sap:label =" INFLUENCE"/>
 <属性名称=" IMPACT"类型=" Edm.Int32" sap:aggregation-role =" measure" sap:filterable =" true" sap:label ="风险"/>
 <属性名称=" DAYS_TO_REACT"类型=" Edm.Int32" sap:filterable =" true" sap:label =" DAYS_TO_REACT"/>
 <属性名称=" PREDICTED_REACTION_DATE"类型=" Edm.DateTime" sap:display-format =" Date" sap:label =" PREDICTED_REACTION_DATE"/>
 <属性名称=" EXT_ID"类型=" Edm.String" MaxLength =" 30" sap:filterable =" true" sap:aggregation-role =" dimension" sap:label ="客户ID"/>
 <属性名称=" NAME"类型=" Edm.String" MaxLength =" 30" sap:aggregation-role =" dimension" sap:filterable =" true" sap:label ="客户名称"/>
 <属性名称=" CUST_ID"类型=" Edm.Int64" sap:filterable =" true" sap:label ="客户ID"/>
 <属性名称=" CURRENCY_DESC"类型=" Edm.String" MaxLength =" 100" sap:label =" DESCRIPTION"/>
 <属性名称=" CURRENCY"类型=" Edm.String" MaxLength =" 100" sap:filterable =" true" sap:label =" STR_VALUE"/>
 
 <属性名称=" IS_SHOW_DETAILS" Type =" Edm.Int32" sap:filterable =" true" sap:label ="在客户详细信息标志中显示数据"/>

 <属性名称=" CUSTOMER_COUNT"类型=" Edm.Int32" sap:aggregation-role =" measure" sap:filterable =" true" sap:label =" CUSTOMER COUNT"/>
 <属性名称=" RISK_CATEGORY" Type =" Edm.String" MaxLength =" 30" sap:filterable =" true" sap:aggregation-role =" dimension" sap:label =" RISK CATEGORY"/>
 

  

2。 Annotation.xml

图表

 
 
 
 
 <收藏>
  CUSTOMER_COUNT 
 
 
 
 <收藏>
 
 
 
 
 
 
 
 <收藏>
  RISK_CATEGORY 
 
 
 
 <收藏>
 
 
 
 
 
 
 
  

演示变量

 
 
 
 <收藏>
  @ UI.Chart#RISKCHART 
 
 
 
 
 <收藏>
  RISK_CATEGORY 
 
 
 
  

VALUELIST

 
 
 
 
 
 
 
  

结果图表-

如您所见,图表似乎只是从RISK_CATEGORY中选择了前3个值,而不是对它们进行了分组。 我也在Presentation变体中指定了GroupBy子句。

4。 Manifest.json-

" AnalyticalListPage | AtRiskCustomers":{
 " entitySet":" AtRiskCustomers",
 "零件": {
 " name":" sap.suite.ui.generic.template.AnalyticalListPage",
 "列表":是的,
 "设置":{
 " multiSelect":是,
 " autoHide":是的,
 " tableType":" ResponsiveTable",
 " defaultContentView":"表格",
 " smartVariantManagement":是的,
 " qualifier":"默认",
 " showGoButtonOnFilterBar":是的,
 " condensedTableLayout":否,
 "关键绩效指标": {}
 }
 },
 "页面":{
 " ObjectPage | AtRiskCustomers":{
 " entitySet":" AtRiskCustomers",
 "零件": {
 "名称":" sap.suite.ui.generic.template.ObjectPage"
 }
 }
 } 

此致

开发

(43.4 kB)
付费偷看设置
发送
2条回答
DafaDDDa
1楼-- · 2020-08-22 03:38

您好Boudhayan ..您有解决此问题的方法吗?

樱桃小丸子0093
2楼-- · 2020-08-22 03:58

客户数量需要默认汇总#SUM

一周热门 更多>