65 lines
2.2 KiB
Plaintext
65 lines
2.2 KiB
Plaintext
table retail自有维度
|
|
lineageTag: c7661179-9154-4572-b662-e329e7903d1d
|
|
|
|
column retail自有维度
|
|
lineageTag: 0b14274f-4fc5-4865-883d-4e1fb365cd68
|
|
summarizeBy: none
|
|
sourceColumn: [Value1]
|
|
sortByColumn: '参数 个订单'
|
|
|
|
relatedColumnDetails
|
|
groupByColumn: '参数 个字段'
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column '参数 个字段'
|
|
isHidden
|
|
lineageTag: 7ffdd7ef-5f87-40fe-a03a-7d612c90e238
|
|
summarizeBy: none
|
|
sourceColumn: [Value2]
|
|
sortByColumn: '参数 个订单'
|
|
|
|
extendedProperty ParameterMetadata =
|
|
{
|
|
"version": 3,
|
|
"kind": 2
|
|
}
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column '参数 个订单'
|
|
isHidden
|
|
formatString: 0
|
|
lineageTag: c9041ee0-d50d-42b6-9af2-348f25b3064e
|
|
summarizeBy: sum
|
|
sourceColumn: [Value3]
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
partition retail自有维度 = calculated
|
|
mode: import
|
|
source =
|
|
{
|
|
("产品ID", NAMEOF('Dim_PackInfo_Retail'[product_id]), 0),
|
|
("OTC/RX", NAMEOF('Dim_PackInfo_Retail'[prescription_nature]), 1),
|
|
("中西药", NAMEOF('Dim_PackInfo_Retail'[medicine_type]), 2),
|
|
("细分1", NAMEOF('Dim_PackInfo_Retail'[zk_medicine_tier1]), 3),
|
|
("细分2", NAMEOF('Dim_PackInfo_Retail'[zk_medicine_tier2]), 4),
|
|
("细分3", NAMEOF('Dim_PackInfo_Retail'[zk_medicine_tier3]), 5),
|
|
("细分4", NAMEOF('Dim_PackInfo_Retail'[zk_medicine_tier4]), 6),
|
|
("通用名", NAMEOF('Dim_PackInfo_Retail'[common_name]), 7),
|
|
("剂型", NAMEOF('Dim_PackInfo_Retail'[dosage_form]), 8),
|
|
("对象", NAMEOF('Dim_PackInfo_Retail'[user_type]), 9),
|
|
("品名", NAMEOF('Dim_PackInfo_Retail'[category_name]), 10),
|
|
("商品名", NAMEOF('Dim_PackInfo_Retail'[product_name]), 11),
|
|
("品牌", NAMEOF('Dim_PackInfo_Retail'[brand_name]), 12),
|
|
("厂家", NAMEOF('Dim_PackInfo_Retail'[zk_manu_des]), 13),
|
|
("集团权益", NAMEOF('Dim_PackInfo_Retail'[zk_corp_des]), 14),
|
|
("规格", NAMEOF('Dim_PackInfo_Retail'[zk_pack_des]), 15)
|
|
}
|
|
|
|
annotation PBI_Id = 313834b04fa2489c948699cc25b62818
|
|
|
|
annotation TabularEditor_TableGroup = 01_ParameterField
|
|
|