Skip to Content

Webi Report with Deminsion

When I put a single dimension on a report and a count all over that dimension, I get a number that is much less the actual number of values in the database.

Its almost like its only displaying a Distinct list as when I put a distinct on the SQL query, the results from there almost match the results in the webi report.

Is there something I need to change so that the report will show all the dimension values and not narrow the list on its own?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Nov 08, 2016 at 02:21 AM

    count([dimension];all)

    Add comment
    10|10000 characters needed characters exceeded

    • So the query from the Database is returning 2751 rows.

      The count on the report (=Count([Name (Last, First)];All)) is returning 2477.

      I have verified in my Query Properties that "Retrieve duplicate rows" is checked, but its like the report to combining like names. For example, the Name "Smith, John" appears once in my report, but I know it should show at least 4 times as I have 4 different people with the name "Smith, John."

  • Nov 08, 2016 at 04:48 PM

    try with number of rows function in webi.

    =NumberOfRows([Your DP name])

    Add comment
    10|10000 characters needed characters exceeded

    • DING DING DING!!!!

      That did what I was wanting to do. I see all the names and the Count All now matches my database total.

      Thank you so much for finding that! Would you want to re-submit your previous comment as an answer so I can mark this as answered?

      THANKS!

  • Nov 08, 2016 at 08:35 PM

    Glad your issue is resolved..I am not here for marks :) leave it.

    I am here because it's improved my knowledge.

    Add comment
    10|10000 characters needed characters exceeded