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
Many thanks in advance.
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.