dbTalk Databases Forums  

using count without dimantion

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss using count without dimantion in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Roy Goldhammer
 
Posts: n/a

Default 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?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.