-
-
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?
-
Re: ERD model for analytics database
dane.slutzkyApr 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
-
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".
-
Re: ERD model for analytics database
dane.slutzkyApr 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
-
-
-
-