-
Re: Derived Calendar with Fiscal Year
Thomas Karner Jan 27, 2017 5:37 AM (in response to Thomas Karner )Anybody who can help with this?
-
Re: Derived Calendar with Fiscal Year
Kenneth Morris Feb 27, 2017 10:28 AM (in response to Thomas Karner )Hi,
Did you ever make any headway finding a good solution to this? I've been trying to to do something very similar using declare/derive. While I've gotten parts to work, the date functions don't return the expected values for every row and I've been trying to determine if I have done something wrong, there is a bug or what. I've posted also without much useful response.
Thanks,
Ken Morris
-
-
Re: Derived Calendar with Fiscal Year
Elena Kusterer Mar 23, 2017 9:55 AM (in response to Thomas Karner )If anyone figures this out it would be great! I would much rather be able to use the derived fields rather than copying and pasting a master calendar for each date field.
-
Re: Derived Calendar with Fiscal Year
Kenneth Morris Mar 23, 2017 10:55 AM (in response to Elena Kusterer)Well I did get another proof of concept to work for fiscal year.
I expect that this could be extended to include quarters, months etc and that the the fixed start month could be changed to a DECLARE parameter but I have not gotten to that yet. Loading from Data Load Manager worked but I didn't immediately notice that it had since I expected Fiscal Year to show up in the table view there which it does not. But in the sheet editor, if you open the fields section on the left assets panel, it appears as a subfield of Action Taken Date.
-
Re: Derived Calendar with Fiscal Year
Thomas Karner Mar 31, 2017 11:47 AM (in response to Kenneth Morris )Hi, I did some intensive research on this topic connected also with the time-aware charts.
My findings could be found at
Best,
Thomas
-
-