Post reply

Problems with a DISTINT COUNT e COUNT measure

  • October 4, 2014 at 2:39 pm

    #312032

    Hi to all.

    I have an OLAP CUBE that contains a distinct count measure and a count measure ...

    If i do a report with Excel , all it works fine ..and these measure are correctly calculated and displayed.

    If i create a report connected to this OLAP CUBE , i have problems.

    In my tablix repost i have simply :

    DATE DELIVER TOTALE SALES AMOUNT <measure count distinct invoices> <measure count rows>

    12-09-2014 100 (Excel put correct value SSRS no !!!)

    13-09-2014 200 "" ""

    14-09-2014 300 "" ""

    I notice also that in Query Designer <measure count distinct invoices> <measure count rows> are correctly calculated ...

    In my SSRS report measure <measure count distinct invoices> expression is

    =Fields!Numero_Ordini_Clienti.Value

    Do i have use different aggegate functions and if it is...which is correct expression to use ????

    Can anyone explain to me why ???

    Regards in advance...

  • October 24, 2014 at 2:31 am

    #1754551

    Hi

    Would you try this and see if the result comes back ok?

    =CountDistinct(Fields!Numero_Ordini_Clienti.Value)

    Thanks 🙂

    C

  • October 24, 2014 at 2:37 am

    #1754554

    I guess SSRS uses SUM or COUNT in the tablix?

    Change this to AGGREGATE. This pushes the logic of aggregating to the cube.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 24, 2014 at 3:47 am

    #1754576

    Thanks for your kind reply.

    With your post i solved problem.

    Thanks.

  • October 24, 2014 at 3:48 am

    #1754577

    Thanks for your kind reply.

    I will try also that you wrote me.

    Thanks again.

  • October 24, 2014 at 3:48 am

    #1754578

    maretix (10/24/2014)

    Thanks for your kind reply.

    With your post i solved problem.

    Thanks.

    Which one? The CountDistinct or the Aggregate one?

    For the people who stumble upon this thread that might be good to know.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 24, 2014 at 3:52 am

    #1754579

    Sorry you are right.

    COUNTDISTINCT solution.

    Thanks again.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply