Clarity

  • 1.  Data missed in "RPT_CALENDAR" table

    Posted Oct 03, 2016 09:19 AM

    Hi All,

    In "RPT_CALENDAR" table ,we are not getting all months of 2013 records.
    Please suggest me , how to restore all the months for the 2013 in the table .

    we ran the below Jobs, But no luck.

    1.Update Report Tables
    2.Data mart Extraction
    3.Data mart Rollup- Time Facts and Time Summary

    Clarity version -- 14.3 

     


    regards,
    Ram



  • 2.  Re: Data missed in "RPT_CALENDAR" table

    Posted Oct 03, 2016 09:33 AM

    Please run this job:

    Update Business Objects Table

     

    NJ

     

     



  • 3.  Re: Data missed in "RPT_CALENDAR" table



  • 4.  Re: Data missed in "RPT_CALENDAR" table

    Posted Oct 05, 2016 06:48 AM

    In new  versions "Update Business Objects Table" job name has been renamed to "Update Report Tables" .

    Have populated all 2013  records(period type = Monthly) in RPT_CALENDAR table following the below steps.

    1.In "Time slices" modified  the "From date" of one of Monthly Slice Period " to "01-01-2013" .

    2. Ran the "time slice"  and  "Update report Tables" jobs one after the another.

     

     

    Regards,

    Ram