I am trying to create Canonical Date Almost all i have completed successfully but when I am trying to create the master calendar for Canonical Date column I am getting this error
Can you guys please check the qvw and help me out from this, Why i am getting this error and what is my mistake
Thank you in advance
Try this one
LOAD Date('2016-01-01' + IterNo() - 1) as [Date] AutoGenerate 1 While Date('2016-01-01' + IterNo() - 1) <= Date('2020-01-01');
Replace this on all Tabs:
$(vMinDate) + IterNo() - 1 as DateNum
While $(vMinDate) + IterNo() - 1 <= $(vMaxDate);
'$(vMinDate)' + IterNo() - 1 as DateNum
While '$(vMinDate)' + IterNo() - 1 <= '$(vMaxDate)';
hope this helps
The field CanonicalDate is empty, therefore mindate and maxdate for mastercaledar are null. Check creating [DateBridge] table and applymap() statement.
I have replaced with this in my qvw but when i am trying to create master calendar year i am getting empty like this
I am attaching qvw also please check it and let me know what was the mistake
Yeah, I have verified that also. But i am not getting any clue why my Canonical Date Field is empty.
Can you guys please help me out from this