Clarity

  • Private Community

  • 1.  allocation details are not available when we access month wise

    Posted Oct 18, 2015 12:12 PM

    Hi All,

     

    I have created a timescaled field to see allocation details monthly wise ( It is accepting the values & saved in planned allocation ) but values are not showing in the grid  .

    User having the some allocation from Aug to Dec (screen shot 2 ) but nothing is showing in the grid (allocation by Month-screen shot 1 )

    This query is returning the null value

    SELECT 'Allocation' Slice_Object, Count(*),SLICE_STATUS

    FROM prteam WHERE SLICE_STATUS in (1,2)  GROUP BY SLICE_STATUS.

     

    Not sure where I am wrong , can you please advise me to setup timeslices accordingly .

    Screen shot : 1

    allocation in team.PNG

    staff properties.JPG

    Many thanks in advance.

     

    Regards,

    Raj



  • 2.  Re: allocation details are not available when we access month wise

    Posted Oct 21, 2015 07:04 AM

    It was the issue with datamart job , these jobs were not running .

    Clarity Tuesday Tip - How Datamart Extraction Job Affects TSV , it is having the detailed explanation.