62 lines
1.8 KiB
Plaintext
62 lines
1.8 KiB
Plaintext
table 'Fields.CrossKPI'
|
|
lineageTag: aa234743-a392-4a12-9eb3-5c07a70aea8f
|
|
|
|
column 'Fields.CrossKPI'
|
|
lineageTag: c00ffcbf-25bf-4297-8d08-ca6567b61f1d
|
|
summarizeBy: none
|
|
sourceColumn: [Value1]
|
|
sortByColumn: 'Fields.CrossKPI 个订单'
|
|
|
|
relatedColumnDetails
|
|
groupByColumn: 'Fields.CrossKPI 个字段'
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column 'Fields.CrossKPI 个字段'
|
|
isHidden
|
|
lineageTag: 805f760c-b4e8-487b-acbc-7658e383e27e
|
|
summarizeBy: none
|
|
sourceColumn: [Value2]
|
|
sortByColumn: 'Fields.CrossKPI 个订单'
|
|
|
|
extendedProperty ParameterMetadata =
|
|
{
|
|
"version": 3,
|
|
"kind": 2
|
|
}
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column 'Fields.CrossKPI 个订单'
|
|
isHidden
|
|
formatString: 0
|
|
lineageTag: b9b36be2-836c-4a77-807d-26654b3a8e2b
|
|
summarizeBy: sum
|
|
sourceColumn: [Value3]
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
partition 'Fields.CrossKPI' = calculated
|
|
mode: import
|
|
source =
|
|
{
|
|
("Sales", NAMEOF([External.Sales.KPI.Cross]), 1),
|
|
("SalesLY", NAMEOF([External.Sales.LY.KPI.Cross]), 2),
|
|
("GR%", NAMEOF([External.Gr%.KPI.Trend]), 3),
|
|
("RQ GR%", NAMEOF([External.RQGR%.KPI.Trend]),4),
|
|
("MS%", NAMEOF([External.MS%.KPI.Trend]), 6),
|
|
("ΔMS%", NAMEOF([External.△MS%.KPI.Trend]), 7),
|
|
|
|
("Incr. Sales", NAMEOF([External.GRSales.KPI.Trend]), 9),
|
|
("Incr. Contr%", NAMEOF([External.GRSalesContr%.KPI.Trend]), 10),
|
|
("MolSales", NAMEOF([External.Sales.KPI.Mol.Trend]), 11),
|
|
("MolGR%", NAMEOF([External.Gr%.KPI.Mol.Trend]), 12),
|
|
("ΔMolShare%", NAMEOF([External.△MS%.KPI.Mol.Trend]), 14),
|
|
("Share in Class", NAMEOF([External.MS%.KPI.Class.Trend]), 19)
|
|
}
|
|
|
|
annotation PBI_Id = 870b6a0e77044d65a6edcf43c3986338
|
|
|
|
annotation TabularEditor_TableGroup = 01_ParameterField
|
|
|