61 lines
1.6 KiB
Plaintext
61 lines
1.6 KiB
Plaintext
table Fields_Matrix
|
|
lineageTag: dce16cbe-1f12-4f7f-96d5-324b9680b827
|
|
|
|
column Fields_Matrix
|
|
lineageTag: 20a1384a-f7ba-4e21-9116-ec8dbed80d50
|
|
summarizeBy: none
|
|
sourceColumn: [Value1]
|
|
sortByColumn: 'Fields_Matrix 个订单'
|
|
|
|
relatedColumnDetails
|
|
groupByColumn: 'Fields_Matrix 个字段'
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column 'Fields_Matrix 个字段'
|
|
isHidden
|
|
lineageTag: 61c4657b-e769-4e24-968b-c0270ae0077e
|
|
summarizeBy: none
|
|
sourceColumn: [Value2]
|
|
sortByColumn: 'Fields_Matrix 个订单'
|
|
|
|
extendedProperty ParameterMetadata =
|
|
{
|
|
"version": 3,
|
|
"kind": 2
|
|
}
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column 'Fields_Matrix 个订单'
|
|
isHidden
|
|
formatString: 0
|
|
lineageTag: 85fbc789-ef3d-4ddc-a93a-56da2ee0c216
|
|
summarizeBy: sum
|
|
sourceColumn: [Value3]
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
partition Fields_Matrix = calculated
|
|
mode: import
|
|
source = ```
|
|
{
|
|
("Data Source", NAMEOF('Dim_DataSource'[SOURCENAME]), 1),
|
|
("ValueType", NAMEOF('Dim_Unit'[DW]), 2),
|
|
("YEAR", NAMEOF(Dim_Calendar[YEAR]), 3),
|
|
("YYYYHH", NAMEOF(Dim_Calendar[HALF_YEAR]), 4),
|
|
("YYYYQQ", NAMEOF(Dim_Calendar[YEAR_QUATER]), 5),
|
|
("YYYYMM", NAMEOF(Dim_Calendar[YYYYMM]), 6),
|
|
("TA", NAMEOF('Dim_MarketTA'[TA]), 7),
|
|
("Class", NAMEOF(Dim_Class[CLASS]), 9),
|
|
("Molecule CN", NAMEOF('Dim_PackInfo'[CMPS_DES_C]), 10),
|
|
("Brand CN", NAMEOF('Dim_PackInfo'[PROD_DES_C]), 11),
|
|
("Province", NAMEOF('Dim_Geo'[Province_C]), 12)
|
|
}
|
|
```
|
|
|
|
annotation PBI_Id = e0b4127bc7634f06be493e31e8f41fe2
|
|
|
|
annotation TabularEditor_TableGroup = 01_ParameterField
|
|
|