4 Replies Latest reply: Mar 7, 2018 10:03 AM by Ramzi Manoubi RSS

    Set analysis ignored, when table empty

    Ramzi Manoubi



      Any help understanding this is very welcome.


      I try to count the number of persons which have at least 1 book.

      count(   {< Book_Id = {*} >} distinct Person_Id    )


      Because of a mistake (by me), the table with books is empty.

      In the data model the table "books" appears, with all it's columns, but no rows.

      What I had expected is that the above function would return 0 books, for every person.


      In stead, the functions operates similar this function:

      count(  distinct Person_Id    )

      The set analysis is ignored, because the table "books" is empty.


      Why? This is not what I expected.


      Thank you for your interest.