5 Replies Latest reply on Apr 28, 2011 4:53 PM by dane.slutzky

ERD model for analytics database

hrshah Apr 28, 2011 12:33 PM

I have looked in this community and Jive documentation for ERD model that shows relationship among various database objects in Jive Analytics database. Can Jive provide that to this community? It will be of enormous value for people who are not using BO.

Re: ERD model for analytics database

RyanRaynis Apr 28, 2011 2:36 PM (in response to hrshah)

Himanshu,

You should find what you're looking for here: Analytics Data Model
Like (0)

Actions
- Re: ERD model for analytics database
  
  hrshah Apr 28, 2011 2:40 PM (in response to RyanRaynis)
  
  Hi Ryan,
  What I'm looking for is a document or diagram that tells me how to join various tables in analytics database. For example...
  
  To get blogpost views...one has to connect Fact table with JIVEDW_OBEJCT and JIVEDW_BLOGPOST tables.
  
  JIVEDW_OBJECT.OBJECT_ID = JIVEDW_BLOGPOST.BLOGPOST_ID is join condition for above 2 tables.
  
  Is there a document that shows above relation visually?
  
  Like (0)
  
  Actions
  - Re: ERD model for analytics database
    
    dane.slutzky Apr 28, 2011 2:43 PM (in response to hrshah)
    
    Hi Himanshu,
    
    I don't know of a visual representation, but here is the full schema with the primary keys noted: http://docs.jivesoftware.com/jive_sbs/4.5/index.jsp?topic=/com.jivesoftware.help.sbs.online_4.5/developer/AnalyticsDatabaseSchema.html
    
    Thanks,
    Dane
    
    Like (0)
    
    Actions
    - Re: ERD model for analytics database
      
      hrshah Apr 28, 2011 4:22 PM (in response to dane.slutzky)
      
      Thanks Dane, How do I joint JIVEDW_OBJECT and JIVEDW_MESSAGE tables to get number of views for discussion message and discussion thread object types by registered and guest users?
      
      Should I use message_id or thread_id from JIVEDW_MESSAGE?
      What is the discussion is defined as a "Question".
      
      Like (0)
      
      Actions
      - Re: ERD model for analytics database
        
        dane.slutzky Apr 28, 2011 4:53 PM (in response to hrshah)
        
        Hi Himanshu,
        
        Our support team will be able to help you out with more in depth answers to your questions if you open a case in your support community.
        
        To get the views on each individual post in a thread, you should join on message_id, but it depends what you are really looking for here. We can go more into depth on it in a support case.
        
        Thanks,
        Dane
        
        Like (0)
        
        Actions

Go to original post