Question about column size in Vertipaq Analyzer

[Orion_Phihon_Hu]

Hello All:

        I have three tables related by column oid. Table A is Puchasing detail table with only available purchasing orders. Table B is Purchasing Table with few columns but have all purchasing orders. Table C is Receipting Table. Table A related to Table B with OID, Table C related to Table B with OID. Through DAX Studio View Metrics, I have detail report listed below. 1.Why Data and Dictionary can have such different results? 2.Can I change the way of Encoding to Value? Because Table C has better size

Table A

Column	Cardinality	Total Size	Data	Dictionary	Hier Size	Encoding	Data Type
OID	5,006,918	207,698,248	13,397,184	154,245,704	40,055,360	HASH	Int64

Table B

Column	Cardinality	Total Size	Data	Dictionary	Hier Size	Encoding	Data Type
OID	5,412,483	213,601,924	14,434,088	155,867,964	43,299,872	HASH	Int64

Table C

Column	Cardinality	Total Size	Data	Dictionary	Hier Size	Encoding	Data Type
OID	1,302,003	13,142,880	7,934,827	136	5,208,016	VALUE	Int64