CODEWITHSUNDEEP
sqlsql-server-2008-r2ssasolap-cube
ack
ack

Reputation: 31

How to get around SQL Server Analysis Services 2 billion distinct value limitation on a column

What is a best practice to get around SSAS 2 billion distinct value limitation on a column. My data set grows by 2 billions rows every 10 month and one of the measures in the cube is a row count that runs on the PK. Because adding partitions does not help resolve the problem, would creating new cubes with identical info be the right approach?

Upvotes: 0

Views: 1348

Answers (2)

Nikita Roshka
Nikita Roshka

Reputation: 1

after almost 10 years, I also encountered such a mistake. It helped me at the beginning of the query to use TOPN(3000000000, table) and surprisingly it worked!

Upvotes: 0

FrankPl
FrankPl

Reputation: 13315

Do you have to run the count on a column? This should only be necessary if you have duplicates in your table. Could you not just count rows? Then just omit the primary key column.

Upvotes: 1

Related Questions