4 Replies Latest reply on Aug 14, 2014 5:20 AM by mitchelm

    JIVEDW_ACTIVITY_FACT stores activities on all objects expect IDEAS. Where are idea actions?

    mitchelm

      We are building sql queries to return the number of activities on various objects.  I have had a study of the database schema and from the table JIVEDW_ACTIVITY_FACT we are able to pull activities on 'Document','Thread' ,'Poll','Video','Message','Question','Blog','Question','Comment','Project','Photos' object types, but not 'IDEAS'

      Why are IDEAS activities not in the activity_fact table? Where can I find them?

       

      Any help would be appreciated.

      Thanks

      Marcell