Forum Discussion
Question about column size in Vertipaq Analyzer
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 |
No RepliesBe the first to reply