May 5, 2015 at 10:04 am
I'm trying to process and/or deploy a SSAS tabular model using Visual Studio 2010. One dimension is giving me grief; it hangs at 100,000 rows almost every time when I try to process it locally. Occasionally, about 1 time in 10 if I have killed and restarted VS, and if I Process All, I am able to get all of the 127,000 rows into the model, but then it hangs at 100,000 rows when I try to deploy it to the server. Is there a setting that I'm missing?
Thanks,
Jill
May 5, 2015 at 2:13 pm
May be on Server, there might be a limitation on records that you need to increase the Dimension records count.
OLAP\Query\DefaultDrillThroughMaxRows
and also the RAM memory size also you may need to check out.
Memory\VertipaqMemoryLimit
Thank You
May 6, 2015 at 2:09 am
VRT (5/5/2015)
May be on Server, there might be a limitation on records that you need to increase the Dimension records count.OLAP\Query\DefaultDrillThroughMaxRows
and also the RAM memory size also you may need to check out.
Memory\VertipaqMemoryLimit
That setting is just for drillthrough. There is not row limit for tabular dimensions provided that no single column has more than 1,999,999,997 distinct values.
https://msdn.microsoft.com/en-us/library/ms365363.aspx#bkmk_vertipaq
It most probably is a RAM-related issue as VRT said. Have a look at the memory allocation of the AS instance (https://msdn.microsoft.com/en-us/ms174514.aspx) and up it if needed.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply