onsdag den 13. juli 2016

Dealing with long text in ssas cube

How to place nvarchar data with max size in SSAS Cube 2012 version

In 2012 visual studio if we drag varchar (max ) attribute it automatically takes with data size zero.  And doesn't set any data size property for that attribute. So we have to add it manually in XMLA code . Right click on dimension->go to code mode  add data size property like belowone

<DataType>WChar</DataType>
<Data size>163315555</Data Size>

Ingen kommentarer:

Send en kommentar