Master Calendar "Field not found" Error

[bvssudhakar]

Hi Experts,

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

[andrey_krylov]

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');

[bvssudhakar]

Sorry I attached wrong qvw. This is the updated one.

Please finf it and help me out from this

[bvssudhakar]

Hi Andrey,

Now i attached one qvw please check that and based on that please give the suggestion

Thank you in advance

[Frank_Hartmann]

Replace this on all Tabs:

Load
  $(vMinDate) + IterNo() - 1 as DateNum
AutoGenerate 1
While $(vMinDate) + IterNo() - 1 <= $(vMaxDate);

with this

Load
  '$(vMinDate)' + IterNo() - 1 as DateNum
AutoGenerate 1
While '$(vMinDate)' + IterNo() - 1 <= '$(vMaxDate)';

hope this helps

[andrey_krylov]

The field CanonicalDate  is empty, therefore mindate  and maxdate for mastercaledar are null. Check creating [DateBridge] table and applymap() statement.

[bvssudhakar]

Hi Frank,

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

[Frank_Hartmann]

Check Andreys answer.

Indeed your CanonicalDate  Field is empty!

[bvssudhakar]

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

[bvssudhakar]

Yeah, I have verified But i am not getting any clue why my Canonical Date Field is empty.

Can you guys please help me out from this