0 Replies Latest reply: May 24, 2012 9:57 AM by milikofa RSS

    Document unique view count bigger tha create count

    milikofa

      Hello ,

       

      I am using the analytics database for reporting and am trying to get the amount of documents viewed and the amount of document created. For a reason that remains unknown when i run my query I find documents that have been viewed but never created?

       

      The queries am using are

       

      SELECT DISTINCT  DIRECT_DW_OBJECT_ID

      FROM JIVEDW_DBO.JIVEDW_ACTIVITY_FACT

      WHERE DIRECT_OBJECT_TYPE = 102

      AND ACTIVITY_TYPE IN (10)

       

      for the documents viewed

      and

       

      SELECT DISTINCT DIRECT_DW_OBJECT_ID

      FROM JIVEDW_DBO.JIVEDW_ACTIVITY_FACT

      WHERE DIRECT_OBJECT_TYPE = 102

      AND ACTIVITY_TYPE IN (20);

       

      for the document created. The first query gives me higher count than the second one. Am i missing anything here?