点击此处---> 群内免费提供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)
您好Boudhayan ..您有解决此问题的方法吗?
客户数量需要默认汇总#SUM
一周热门 更多>