Home Dashboard Directory Help
Search

SSAS distinct count wrong results by Chenn Ronen - SolidBI


Status: 

Closed
 as Not Reproducible Help for as Not Reproducible


1
0
Sign in
to vote
Type: Bug
ID: 790216
Opened: 6/14/2013 12:55:37 PM
Access Restriction: Public
0
Workaround(s)
view
1
User(s) can reproduce this bug

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.
Details
Sign in to post a comment.
Posted by Microsoft 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 Microsoft 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 Microsoft 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
Sign in to post a workaround.