605 lines
16 KiB
Plaintext
605 lines
16 KiB
Plaintext
table Dim_RC
|
|
lineageTag: 1631f019-12d8-4ce8-9ec5-d19584019a1c
|
|
|
|
column AUDIT_COD
|
|
dataType: string
|
|
lineageTag: 81757219-efcb-4aed-8d1e-467b9d6cb8ea
|
|
summarizeBy: none
|
|
sourceColumn: AUDIT_COD
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column MARKET
|
|
dataType: string
|
|
lineageTag: 52adb170-ce52-41f9-939e-1a0623de84b9
|
|
summarizeBy: none
|
|
sourceColumn: MARKET
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column sub_bu_code_auth
|
|
dataType: string
|
|
lineageTag: a32a5889-f5fd-420a-9664-98552a7445c3
|
|
summarizeBy: none
|
|
sourceColumn: sub_bu_code_auth
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column bu_code_auth
|
|
dataType: string
|
|
lineageTag: 5983779e-253b-44ff-8821-8cf8988eb883
|
|
summarizeBy: none
|
|
sourceColumn: bu_code_auth
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column DATA_SOURCE
|
|
dataType: string
|
|
lineageTag: 67a8d0c3-89b8-41b4-b599-e3bcb49ea7c2
|
|
summarizeBy: none
|
|
sourceColumn: DATA_SOURCE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column REGION_RATIO
|
|
dataType: double
|
|
lineageTag: aa78454a-8ca5-43e8-a7ce-766e0e8cbf11
|
|
summarizeBy: sum
|
|
sourceColumn: REGION_RATIO
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
annotation PBI_FormatHint = {"isGeneralNumber":true}
|
|
|
|
column mr_trty_code
|
|
dataType: string
|
|
lineageTag: ba35f7ca-6057-495f-b7c4-07f96205cfb5
|
|
summarizeBy: none
|
|
sourceColumn: mr_trty_code
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column IS_TARGET_HP
|
|
dataType: string
|
|
lineageTag: b6cf7ae2-aac0-4fd4-ad84-9627010aed2f
|
|
summarizeBy: none
|
|
sourceColumn: IS_TARGET_HP
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column SUB_CHANNEL
|
|
dataType: string
|
|
lineageTag: 007e5d6e-edcb-42d6-87c6-18dcfa713368
|
|
summarizeBy: none
|
|
sourceColumn: SUB_CHANNEL
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column DRAGON_FLAG
|
|
dataType: string
|
|
lineageTag: 44e65af1-9763-4e53-9f3a-d22d98152d0d
|
|
summarizeBy: none
|
|
sourceColumn: DRAGON_FLAG
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column KA_FLAG
|
|
dataType: string
|
|
lineageTag: 487ffbbf-c28a-4170-890a-f5ffe5c67351
|
|
summarizeBy: none
|
|
sourceColumn: KA_FLAG
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column SUB_CHANNEL_ORDER
|
|
dataType: int64
|
|
formatString: 0
|
|
lineageTag: e546c2cc-7d17-4434-a5cf-ee615d732148
|
|
summarizeBy: sum
|
|
sourceColumn: SUB_CHANNEL_ORDER
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column AUDIT_SOURCE = [AUDIT_COD] & [DATA_SOURCE]
|
|
lineageTag: a192af7e-e937-4681-ae25-b182b75880cd
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ISTARGET_SOURCE = [IS_TARGET_HP] & [DATA_SOURCE]
|
|
lineageTag: da23e96b-509e-48b1-8d94-7869ff3aab9c
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column INS_MKT_SOURCE = IF([DATA_SOURCE] = "AIA(Monthly)", [AUDIT_COD] & [MARKET] & [DATA_SOURCE], [DATA_SOURCE])
|
|
lineageTag: 1388a47e-f87f-424e-a757-3a2b6459f751
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column MKT_SOURCE = [MARKET] & [DATA_SOURCE]
|
|
lineageTag: 11476559-b491-4a7e-877c-b982ea203ee7
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column ORG_SOURCE = [AUDIT_COD] & [MARKET] & [region_code] & [DATA_SOURCE]
|
|
lineageTag: 49ad814f-6284-4735-b152-28fbb0db8c0b
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column TRTY_SOURCE = ```
|
|
[mr_trty_code] & [DATA_SOURCE]
|
|
```
|
|
lineageTag: e8bb1de3-eade-46e6-8b22-7265e3086b99
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column REGION_CODE
|
|
dataType: string
|
|
lineageTag: d3850675-3767-490d-a741-4705c031fe70
|
|
summarizeBy: none
|
|
sourceColumn: REGION_CODE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column rc_key
|
|
dataType: string
|
|
lineageTag: b1d21ad0-52f9-4b1b-9458-d313a51a0b79
|
|
summarizeBy: none
|
|
sourceColumn: rc_key
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column aia_remove
|
|
dataType: int64
|
|
formatString: 0
|
|
lineageTag: 5c935592-d33b-48ec-bd92-28b3830e14e8
|
|
summarizeBy: sum
|
|
sourceColumn: aia_remove
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
partition Dim_RC = m
|
|
mode: import
|
|
queryGroup: Dim
|
|
source = ```
|
|
let
|
|
Source =
|
|
Value.NativeQuery(
|
|
Databricks.Catalogs(
|
|
ServerAddress, HttpPath, [
|
|
Catalog = CatalogName,
|
|
Database = null,
|
|
EnableAutomaticProxyDiscovery = null,EnableQueryResultDownload="0"
|
|
]
|
|
){
|
|
[Name = CatalogName, Kind = "Database"]
|
|
}[Data],
|
|
"
|
|
WITH
|
|
dm_td_org_temp AS (
|
|
SELECT
|
|
org_key,
|
|
mr_trty_tag,
|
|
district_code,
|
|
rsm_name,
|
|
rc_name,
|
|
p2.region_name,
|
|
p2.rsd_kcode,
|
|
p2.rsd_name,
|
|
CASE
|
|
WHEN p2.yyyymm >= '202601'
|
|
AND p2.bu_code = 'PC12' THEN 'PC09'
|
|
ELSE p2.bu_code
|
|
END bu_code,
|
|
CASE
|
|
WHEN p2.yyyymm >= '202601'
|
|
AND p2.bu_report = 'EC' THEN 'Retail'
|
|
ELSE p2.bu_report
|
|
END bu_report,
|
|
CASE
|
|
WHEN p2.yyyymm >= '202601'
|
|
AND p2.sub_bu_code = 'NA27' THEN 'NA06'
|
|
ELSE p2.sub_bu_code
|
|
END sub_bu_code,
|
|
CASE
|
|
WHEN p2.yyyymm >= '202601'
|
|
AND p2.sub_bu_name = 'EC' THEN 'Retail'
|
|
ELSE p2.sub_bu_name
|
|
END sub_bu_name,
|
|
CASE
|
|
WHEN p2.yyyymm >= '202601'
|
|
AND p2.sub_bu_name_en = 'EC' THEN 'Retail'
|
|
ELSE p2.sub_bu_name_en
|
|
END sub_bu_name_en,
|
|
CASE
|
|
WHEN p2.yyyymm >= '202601'
|
|
AND p2.bu_name = 'EC' THEN 'Retail'
|
|
ELSE p2.bu_name
|
|
END bu_name,
|
|
CASE
|
|
WHEN p2.yyyymm >= '202601'
|
|
AND p2.bu_name_en = 'EC' THEN 'Retail'
|
|
ELSE p2.bu_name_en
|
|
END bu_name_en,
|
|
CASE
|
|
WHEN p2.yyyymm >= '202601'
|
|
AND p2.nsd_kcode = 'ND_EC0001_V' THEN 'KSGX559'
|
|
ELSE p2.nsd_kcode
|
|
END nsd_kcode,
|
|
CASE
|
|
WHEN p2.yyyymm >= '202601'
|
|
AND p2.bu_name = 'EC'
|
|
AND p2.nsd_name = 'Vacant' THEN '李白杨'
|
|
ELSE p2.nsd_name
|
|
END nsd_name,
|
|
CASE
|
|
WHEN p2.yyyymm >= '202601'
|
|
AND p2.nsd_trty_code = 'ND_EC0001' THEN 'ND_RT0001'
|
|
ELSE p2.nsd_trty_code
|
|
END nsd_trty_code,
|
|
CASE
|
|
WHEN p2.yyyymm >= '202601'
|
|
AND p2.bsd_kcode = 'VP_EC0001_V' THEN 'VP_RT0001_V'
|
|
ELSE p2.bsd_kcode
|
|
END bsd_kcode,
|
|
CASE
|
|
WHEN p2.yyyymm >= '202601'
|
|
AND p2.bsd_trty_code = 'VP_EC0001' THEN 'VP_RT0001'
|
|
ELSE p2.bsd_trty_code
|
|
END bsd_trty_code,
|
|
p2.rsm_kcode,
|
|
p2.rc_code,
|
|
p2.rc_name_en,
|
|
p2.region_code,
|
|
p2.region_name_en,
|
|
BU_CATEGORY,
|
|
yyyymm,
|
|
mr_trty_code,
|
|
mr_kcode,
|
|
dsm_trty_code,
|
|
rsm_trty_code,
|
|
dsm_kcode,
|
|
rsd_trty_code,
|
|
district_name,
|
|
dsm_name,
|
|
mr_name
|
|
FROM
|
|
DM.dm_td_org P2
|
|
WHERE
|
|
yyyymm IN (
|
|
SELECT
|
|
key_value
|
|
FROM
|
|
dm.dm_td_date_config
|
|
WHERE
|
|
key_code = 'pfmc_cvh'
|
|
)
|
|
AND mr_trty_code <> ''
|
|
),
|
|
t1 AS (
|
|
SELECT DISTINCT
|
|
concat ('ROC_', nsd_trty_code) AS mr_trty_code,
|
|
'ROC' AS bu_category,
|
|
'ROC' AS bu_name_en,
|
|
'ROC' AS sub_bu_name,
|
|
'ROC' AS rc_code,
|
|
'ROC' AS rc_name_en,
|
|
'ROC' AS rc_name_en_n,
|
|
'ROC' AS RC_NAME,
|
|
'ROC' AS region_code,
|
|
'ROC' AS region_name_en,
|
|
'ROC' AS region_name_en_n,
|
|
'ROC' AS team,
|
|
nsd_kcode,
|
|
nsd_name,
|
|
'Vacant' AS rsd_kcode,
|
|
'Vacant' AS rsd_name,
|
|
'Vacant' AS rsm_kcode,
|
|
'Vacant' AS rsm_name,
|
|
'Vacant' AS dsm_kcode,
|
|
'Vacant' AS dsm_name,
|
|
'Vacant' AS mr_kcode,
|
|
'Vacant' AS mr_name
|
|
FROM
|
|
dm_td_org_temp
|
|
),
|
|
t2 AS (
|
|
SELECT DISTINCT
|
|
mr_trty_code,
|
|
bu_category,
|
|
bu_name_en,
|
|
sub_bu_name,
|
|
rc_code,
|
|
rc_name AS rc_name_en,
|
|
CASE
|
|
WHEN rsd_name = 'Vacant' THEN rsd_kcode
|
|
ELSE rsd_name
|
|
END AS RC_NAME,
|
|
region_code,
|
|
region_name AS region_name_en,
|
|
district_name AS team,
|
|
nsd_kcode,
|
|
CASE
|
|
WHEN nsd_name = 'Vacant' THEN nsd_kcode
|
|
ELSE nsd_name
|
|
END AS nsd_name,
|
|
rsd_kcode,
|
|
CASE
|
|
WHEN rsd_name = 'Vacant' THEN rsd_kcode
|
|
ELSE rsd_name
|
|
END AS rsd_name,
|
|
rsm_kcode,
|
|
CASE
|
|
WHEN rsm_name = 'Vacant' THEN rsm_kcode
|
|
ELSE rsm_name
|
|
END AS rsm_name,
|
|
dsm_kcode,
|
|
CASE
|
|
WHEN dsm_name = 'Vacant' THEN dsm_kcode
|
|
ELSE dsm_name
|
|
END AS dsm_name,
|
|
mr_kcode,
|
|
CASE
|
|
WHEN mr_name = 'Vacant' THEN mr_kcode
|
|
ELSE mr_name
|
|
END AS mr_name
|
|
FROM
|
|
dm_td_org_temp
|
|
UNION
|
|
SELECT DISTINCT
|
|
rsm_trty_code AS mr_trty_code,
|
|
bu_category,
|
|
bu_name_en,
|
|
sub_bu_name,
|
|
rc_code,
|
|
rc_name AS rc_name_en,
|
|
CASE
|
|
WHEN rsd_name = 'Vacant' THEN rsd_kcode
|
|
ELSE rsd_name
|
|
END AS RC_NAME,
|
|
region_code,
|
|
region_name AS region_name_en,
|
|
'' AS team,
|
|
nsd_kcode,
|
|
CASE
|
|
WHEN nsd_name = 'Vacant' THEN nsd_kcode
|
|
ELSE nsd_name
|
|
END AS nsd_name,
|
|
rsd_kcode,
|
|
CASE
|
|
WHEN rsd_name = 'Vacant' THEN rsd_kcode
|
|
ELSE rsd_name
|
|
END AS rsd_name,
|
|
rsm_kcode,
|
|
CASE
|
|
WHEN rsm_name = 'Vacant' THEN rsm_kcode
|
|
ELSE rsm_name
|
|
END AS rsm_name,
|
|
'' AS dsm_kcode,
|
|
'' AS dsm_name,
|
|
'' AS mr_kcode,
|
|
'' AS mr_name
|
|
FROM
|
|
dm_td_org_temp
|
|
UNION
|
|
SELECT
|
|
'Vacant' AS mr_trty_code,
|
|
'ROC' AS bu_category,
|
|
'ROC' AS bu_name_en,
|
|
'ROC' AS sub_bu_name,
|
|
'ROC' AS rc_code,
|
|
'ROC' AS rc_name_en,
|
|
'ROC' AS RC_NAME,
|
|
'ROC' AS region_code,
|
|
'ROC' AS region_name_en,
|
|
'ROC' AS team,
|
|
'Vacant' AS nsd_kcode,
|
|
'Vacant' AS nsd_name,
|
|
'Vacant' AS rsd_kcode,
|
|
'Vacant' AS rsd_name,
|
|
'Vacant' AS rsm_kcode,
|
|
'Vacant' AS rsm_name,
|
|
'Vacant' AS dsm_kcode,
|
|
'Vacant' AS dsm_name,
|
|
'Vacant' AS mr_kcode,
|
|
'Vacant' AS mr_name
|
|
),
|
|
t3 AS (
|
|
SELECT DISTINCT
|
|
A.REGION_CODE,
|
|
A.region_name_en,
|
|
A.rc_code,
|
|
A.rc_name_en,
|
|
A.RegionCenter,
|
|
A.AUDIT_COD,
|
|
A.MARKET,
|
|
CASE
|
|
WHEN bu_category IN ('All Channel', 'EC')
|
|
AND A.DATA_SOURCE = 'IQVIA-CHPA(Monthly)' THEN 'ROC'
|
|
WHEN A.region_name_en = 'ROC' THEN 'ROC'
|
|
WHEN A.rc_name_en = 'ROC' THEN 'ROC'
|
|
ELSE bu_category
|
|
END bu_category,
|
|
CASE
|
|
WHEN bu_category IN ('All Channel', 'EC')
|
|
AND A.DATA_SOURCE = 'IQVIA-CHPA(Monthly)' THEN 'ROC'
|
|
WHEN A.region_name_en = 'ROC' THEN 'ROC'
|
|
WHEN A.rc_name_en = 'ROC' THEN 'ROC'
|
|
ELSE bu_name_en
|
|
END bu_name_en,
|
|
CASE
|
|
WHEN bu_category IN ('All Channel', 'EC')
|
|
AND A.DATA_SOURCE = 'IQVIA-CHPA(Monthly)' THEN 'ROC'
|
|
WHEN A.region_name_en = 'ROC' THEN 'ROC'
|
|
WHEN A.rc_name_en = 'ROC' THEN 'ROC'
|
|
ELSE sub_bu_name
|
|
END sub_bu_name,
|
|
sub_bu_code_auth,
|
|
bu_code_auth,
|
|
A.DATA_SOURCE,
|
|
REGION_RATIO,
|
|
CASE
|
|
WHEN bu_category IN ('All Channel', 'EC')
|
|
AND A.DATA_SOURCE = 'IQVIA-CHPA(Monthly)' THEN 'ROC'
|
|
WHEN A.region_name_en = 'ROC' THEN 'ROC'
|
|
ELSE RSM_Name
|
|
END RSM_Name,
|
|
CASE
|
|
WHEN bu_category IN ('All Channel', 'EC')
|
|
AND A.DATA_SOURCE = 'IQVIA-CHPA(Monthly)' THEN 'ROC'
|
|
WHEN A.rc_name_en = 'ROC' THEN 'ROC'
|
|
ELSE A.RC_Name
|
|
END RC_Name,
|
|
CASE
|
|
WHEN A.region_name_en = 'ROC' THEN 2
|
|
ELSE 1
|
|
END REGION_RN,
|
|
CASE
|
|
WHEN A.rc_name_en = 'ROC' THEN 2
|
|
ELSE 1
|
|
END RC_RN,
|
|
team,
|
|
dsm_kcode,
|
|
dsm_name,
|
|
CASE
|
|
WHEN A.mr_trty_code = '' THEN nvl (t1.mr_trty_code, 'Vacant')
|
|
ELSE A.mr_trty_code
|
|
END AS mr_trty_code,
|
|
mr_kcode,
|
|
mr_name,
|
|
-- B.INST_CODE,NVL(B.inst_name,'') INST_NAME,B.INST_TYPE, B.INST_SUB_TYPE, B.org_level_desc INS_LEVEL,
|
|
CASE
|
|
WHEN (
|
|
A.REGION_CODE = 'ROC'
|
|
OR A.REGION_CODE = ''
|
|
OR A.REGION_CODE IS NULL
|
|
)
|
|
AND A.DATA_SOURCE = 'AIA(Monthly)' THEN 'N'
|
|
ELSE 'Y'
|
|
END AS IS_TARGET_HP,
|
|
--C.IS_TARGET_HP,
|
|
C.SUB_CHANNEL,
|
|
C.DRAGON_FLAG,
|
|
C.KA_FLAG,
|
|
C.SUB_CHANNEL_ORDER
|
|
FROM
|
|
dm.dm_td_external_org A
|
|
LEFT JOIN (
|
|
SELECT
|
|
region_code,
|
|
rc_code,
|
|
mr_trty_code
|
|
FROM
|
|
t2
|
|
WHERE
|
|
team = ''
|
|
) t1 ON A.region_code = t1.region_code
|
|
AND A.RC_CODE = t1.rc_code -- left join dm.dm_td_institution B on A.AUDIT_COD = NVL(B.INST_CODE, 'ROC')
|
|
LEFT JOIN dm.dm_aia_targethp_flag C ON A.AUDIT_COD = NVL (C.INST_CODE, 'ROC')
|
|
AND A.DATA_SOURCE = C.DATA_SOURCE
|
|
AND A.MARKET = C.MARKET
|
|
),
|
|
t4 (
|
|
SELECT DISTINCT
|
|
t3.REGION_CODE,
|
|
t3.region_name_en,
|
|
t3.rc_code,
|
|
t3.rc_name_en,
|
|
t3.RegionCenter,
|
|
t3.AUDIT_COD,
|
|
t3.MARKET,
|
|
t3.bu_category,
|
|
t3.bu_name_en,
|
|
t3.sub_bu_name,
|
|
t3.sub_bu_code_auth,
|
|
t3.bu_code_auth,
|
|
t3.DATA_SOURCE,
|
|
t3.REGION_RATIO,
|
|
t3.RSM_Name,
|
|
t3.RC_Name,
|
|
t3.REGION_RN,
|
|
t3.RC_RN,
|
|
t3.team,
|
|
t3.dsm_kcode,
|
|
t3.dsm_name,
|
|
t1.mr_trty_code AS mr_trty_code,
|
|
t3.mr_kcode,
|
|
t3.mr_name,
|
|
t3.IS_TARGET_HP,
|
|
t3.SUB_CHANNEL,
|
|
t3.DRAGON_FLAG,
|
|
t3.KA_FLAG,
|
|
t3.SUB_CHANNEL_ORDER
|
|
FROM
|
|
t3
|
|
CROSS JOIN t1
|
|
WHERE
|
|
audit_cod = 'ROC'
|
|
UNION ALL
|
|
SELECT DISTINCT
|
|
t3.REGION_CODE,
|
|
t3.region_name_en,
|
|
t3.rc_code,
|
|
t3.rc_name_en,
|
|
t3.RegionCenter,
|
|
t3.AUDIT_COD,
|
|
t3.MARKET,
|
|
t3.bu_category,
|
|
t3.bu_name_en,
|
|
t3.sub_bu_name,
|
|
t3.sub_bu_code_auth,
|
|
t3.bu_code_auth,
|
|
t3.DATA_SOURCE,
|
|
t3.REGION_RATIO,
|
|
t3.RSM_Name,
|
|
t3.RC_Name,
|
|
t3.REGION_RN,
|
|
t3.RC_RN,
|
|
t3.team,
|
|
t3.dsm_kcode,
|
|
t3.dsm_name,
|
|
t3.mr_trty_code,
|
|
t3.mr_kcode,
|
|
t3.mr_name,
|
|
t3.IS_TARGET_HP,
|
|
t3.SUB_CHANNEL,
|
|
t3.DRAGON_FLAG,
|
|
t3.KA_FLAG,
|
|
t3.SUB_CHANNEL_ORDER
|
|
FROM
|
|
t3
|
|
WHERE
|
|
audit_cod <> 'ROC'
|
|
)
|
|
SELECT
|
|
t4.*,
|
|
if (t5.ins_code IS NULL, 1, 0) AS aia_remove
|
|
FROM
|
|
t4
|
|
LEFT JOIN dm.dm_ext_aia_data_remove_flag t5 ON t4.market = t5.market
|
|
AND t4.audit_cod = t5.ins_code
|
|
"
|
|
& UsingLimit,
|
|
null,
|
|
[
|
|
EnableFolding = true
|
|
]
|
|
),
|
|
#"Removed Other Columns" = Table.SelectColumns(Source,{"REGION_CODE", "AUDIT_COD", "MARKET", "sub_bu_code_auth", "bu_code_auth", "DATA_SOURCE", "REGION_RATIO", "mr_trty_code", "IS_TARGET_HP", "SUB_CHANNEL", "DRAGON_FLAG", "KA_FLAG", "SUB_CHANNEL_ORDER", "aia_remove"}),
|
|
#"Added Custom" = Table.AddColumn(#"Removed Other Columns", "rc_key", each [AUDIT_COD]&[DATA_SOURCE]&[MARKET])
|
|
in
|
|
#"Added Custom"
|
|
```
|
|
|
|
annotation PBI_NavigationStepName = Navigation
|
|
|
|
annotation PBI_ResultType = Exception
|
|
|
|
annotation TabularEditor_TableGroup = 04_DimTable
|
|
|