SSAS distinct count wrong results - by Chenn Ronen - SolidBI

Status : 

  Not Reproducible<br /><br />
		The product team could not reproduce this item with the description and steps provided.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 790216 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 6/14/2013 12:55:37 PM
Access Restriction Public

Description

SSAS distinct count results wrong number.
While querying the table as follow:  
SELECT  count (distinct USER_ID ) FROM   Table  
I get this results -- 1033612

While querying SSAS I get 257.

Sample data for USER_ID:
42348-3648-1368306010878-D41D8CD98F00B204E9800998ECF8427E
42348-3648-1368074987484-B26463A0EE1A5F27718A14533D020E60
42348-3648-1368011144064-65DD703A82FFA13A98305295317C86AD
42348-3648-1368049679418-D41D8CD98F00B204E9800998ECF8427E

I have also tried to convert this Varchar(100) into checksum()
sample data :
-235875173
535581043
287814888
-1894147417

still getting same results.

the measure is located in stand alone measure group. and configured with default settings.
Sign in to post a comment.
Posted by Vitaliy [MSFT] on 9/9/2013 at 7:33 PM
Hi Chenn,

Unfortunately, we are no able to reproduce the issue, therefore I am closing the case.

SSAS Engine Development Team
Posted by Vitaliy [MSFT] on 8/21/2013 at 2:48 PM
Hi,

Have you had a chance to attach a sample database where you can reproduce the issue?

Thank you,
Vitaliy
Posted by Vitaliy [MSFT] on 7/31/2013 at 7:11 PM
Hi Chenn,

Thank you for reporting the issue.
Could you please attach the AS database you can reproduce the issue with?

Thank you,
Vitaliy