Hi All,
Dealing with strange scenarios in Incremental Load for our Project.
We have following kind of Data.
ProcessID ProcessDate Metrics Dimensions
1 2016-01-01
2 2016-02-01
3 2016-03-01
4 2016-04-01
5 2016-05-01
6 2016-06-01
7 2016-0701
and so on till December and continued till 2017 Feb
Here, 3,6,9 and 12 means Quarter as in Q1,Q2,Q3,Q4.
1. Scenario 1 ---- I need to show only Months data i.e. 1,2,4,5,7,8,10,11
2. Scenario 2 --- need to show only last Quarter means Q4 of any available Year in QVD it could be 2015, 2016 (history QVD already created) and 2017 data is in database.
Kindly help.
Looking forward for valuable inputs.