11 Replies Latest reply on Sep 2, 2011 10:42 AM by david.sullivan

Clarifications on different date stamp fields

Mari_SGS Aug 25, 2011 12:02 PM

Hi Team,

In BI on Demand reporting, I could see four different timestamps, they are First Activity, last activity, Creation date and Modified date. For a discussion thread,when i try to create an report to show the Original post date, Initial response time to the post and last post date, i am able to get the Original post date using either First Activity or Creation date field but when i try to get the initial response time, it is not showing all the modified date stamps. the last activity and Modified date is showing only last activity (either may be reply or view). if the last activity is View activity, it shows activity date of the same and i am unable to get the previous activities. Please Clarify Whether i can able to get Date/time stamps of all activity of a thread.

Thanks

Mari V

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
Like (0)

Actions
- 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
  
  Like (0)
  
  Actions
  - 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.
    
    Like (0)
    
    Actions
    - 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
      
      Like (0)
      
      Actions
      - 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
        
        Like (0)
        
        Actions
        
        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!
        
        Like (0)
        
        Actions
        
        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
        
        Like (1)
        
        Actions
        
        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)?
        
        Like (0)
        
        Actions
        
        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.
        
        Like (0)
        
        Actions
        
        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.)
        
        Like (0)
        
        Actions
        
        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
        
        Like (0)
        
        Actions

Go to original post