Forum Discussion
Vertipaq Engine: VALUE vs HASH
I'm facing the same problem with the HASH encoding leading to a much larger column size than an equivalent column with VALUE encoding (between 3 and 4 times larger).
I'm testing if we can force the encoding to be VALUE using encoding hints, as suggested in this article:
I will update my answer if I get a solution.
Hi Anonymous,
you can't force it, but you can give a hint to the Vertipaq Analyzer, that it should use Value instead of Hash. It can be set by using Tabular Editor in a PBIT file. You can also write a simple C# code which does the transformation for all columns, which supports Value encoding and so on. I will write a blog post about that, the topic is waiting in a queue ;)
You can use for example following snippet in the Tabular Editor:
// for all Int64 columns set EncodingHint
foreach(var column in Model.Tables.SelectMany(t => t.Columns))
{
if(column.DataType == DataType.Int64)
column.EncodingHint = EncodingHintType.Value;
}Cool, look forward to that article and I will take a look at hinting using Tabular Editor