-
Re: Clarifications on different date stamp fields
david.sullivan Aug 26, 2011 2:10 PM (in response to Mari_SGS)Hi Mari,
All date references to activity are at the day level (Activity Date within the Time class in example).
This information is from the activity_agg_day fact table. We do not capture the times associated.
Best regards,
Dave
-
Re: Clarifications on different date stamp fields
Mari_SGS Aug 26, 2011 2:22 PM (in response to david.sullivan)Hi Dave,
Thanks for your reply, i understand that it is impossible to display the timestamps as it is not being captured.but my question on the other side is, please let me know whether modified date is available for each and every activity of the thread. for example: if there is a thread, will it have modified dates of all the activities of the thread (Create, reply and views).
Thanks
Mari V
-
Re: Clarifications on different date stamp fields
david.sullivan Aug 26, 2011 2:36 PM (in response to Mari_SGS)Hi Mari,
There is a date (Activity Date) associated with each Activity (Activity Type) against a given Object.
If numerous activities occur within a given day for the object the activity count will represent that.
Best regards,
Dave
Message was edited by: Dave Sullivan Changed Object Type to Object.
-
Re: Clarifications on different date stamp fields
Mari_SGS Aug 29, 2011 1:47 PM (in response to david.sullivan)Hi Dave,
Thanks for your response.please help us on our scenario. Please consider the thread :https://community.mcafee.com/thread/37663?tstart=0
According to the thread - 1)Creation date :July 26th 2011
2)Initial Response date(first reply) :July 27th 2011
There are 6 replies to the thread. the 3)last reply date to the thread :Aug 12th, 2011
My Question is will i be able to get 1), 2) and 3) dates from BI on Demand for a thread using the Activity date.
Thanks
Mari V
-
Re: Clarifications on different date stamp fields
david.sullivan Aug 29, 2011 4:45 PM (in response to Mari_SGS)Hi Mari,
Think of the First Activity and Last Activity measure objects (if within the Time class) as Min and Max values for the Activity Date.
They will also always match the Activity Date when used with Activity Type (for instance).
From your question it looks as if you are trying to emulate the view of the thread history as shown within Jive.
The problem I see with using BIOD to achieve what you are trying to do is that there is no reference to the indirect object.
Which in this case would be the reply.
These are object type 2’s (messages) and each will have a unique object ID which differs from the object type 1 (thread) object id.
This can be done querying the Analytics DB directly as the but not via BIOD.
We have the same issue when trying to count replies for a given thread.
Best Regards,
Dave
-
Re: Clarifications on different date stamp fields
April Jacobs Aug 31, 2011 8:59 AM (in response to david.sullivan)Hi David, long time no see.
Can you just clarify this in plain English for me. (LOL!)
I'm trying to give a stakeholder a historical report for his social group which shows the last post date on each thread that is listed (not the last viewed date). Is this possible? Thanks!
-
Re: Clarifications on different date stamp fields
david.sullivan Aug 31, 2011 11:20 AM (in response to April Jacobs)Hi April,
I will try ☺.
There are two components (object types) within the Discussion:
1. Thread – which is the initial post and topic.
2. Message – which is the response post or reply.
By themselves each of these are Direct Objects.
In a hierarchical sense the thread is a direct object and the associated message is the indirect object.
Yet when we wish to report against the message related to the thread there needs to be a link or some way of associating the two.
We do not have indirect objects in the BIOD data so the link between the two is not available.
In speaking with our Support Engineering team I have found that this data is available within the Analytics Data Base but is not within the BIOD (BusObj data).
Best regards,
Dave
-
Re: Clarifications on different date stamp fields
April Jacobs Sep 1, 2011 1:27 PM (in response to david.sullivan)Thanks Dave! So does that mean we should utilize postgres to get at this data? (last "create" activity for a thread)?
-
Re: Clarifications on different date stamp fields
david.sullivan Sep 1, 2011 1:31 PM (in response to April Jacobs)If it was last create activity for a given thread we could accomplish it with BIOD.
It is actually last create date for a message related to the/a given thread.
-
Re: Clarifications on different date stamp fields
April Jacobs Sep 2, 2011 7:53 AM (in response to david.sullivan)Hi Dave, I'm just curious if we could use Postgres, to get the last reply date to a thread. (last create activity associated with thread object. (I understand this isn't available in BIOD.)
-
Re: Clarifications on different date stamp fields
david.sullivan Sep 2, 2011 10:42 AM (in response to April Jacobs)Hi April,
Yes I would think so.
For specifics on reporting directly against the Analytics DB, support would be your best resource.
Best regards,
Dave
-
-
-
-
-
-
-
-
-
-