12 Replies Latest reply on Jun 12, 2014 8:26 AM by yanhong

    Communities Project - Data mapping for MEMBER in JIVE_ANALYTICS schema (Jive7)

    georgianateler

      Hi Jive Team,

       

      I am part of MyOracleSupport (MOS) Analytics team, working on data mapping for Communities project.

      We are mapping our business requirements to JIVE_ANALYTICS schema in Jive7 (http://docs.jivesoftware.com/schemas/7_0/analytics/).

       

      Can you please help us confirm/find the following mappings?

       

      1) MEMBER

       

      1.1) Current Rank Level

      This is the current number of points earned on a particular space (points granted for creating content etc).

      In what tables/columns is this stored in Jive Analytics schema?

       

      1.2) Current Rank Name

      This is the current rank name : depending on the number of points earned, the user has a rank : "Expert" ,"Explorer", "Guru", "Pro", "Journeyer", "Newbie", "Oracle ACE" etc

      In what tables/columns is this stored in Jive Analytics schema?

       

      1.3) Role

      We understood that users can have different roles on different spaces.

       

      How can we find all the roles that a member has and on what space? 

      In what tables/columns is this stored in Jive Analytics ?

      Example : User has :  role1 on space1, role2 on space2 etc

       

      Please let me know if I can provide you more information regarding my questions!

       

      Thank you,

      Georgiana