using count without dimantion -
03-08-2006
, 02:14 AM
Hello there
I'm new in sql analysis server.
I have do get the amount of all data i have on the table i use, to calculate
the precent of each dimantion in the table.
for that i had to use id field, which is the primary key of the table, as
dimantion, in order to get the count of all records in the table.
It worked fine, until the amount of records has passed the 64000 limitation
of the data. Now the count doens't work anymore.
Is there a way to get count of all records in this case on any measure? |