 Rank: Advanced Member
Groups: extranet\Forum
Joined: 8/8/2018(UTC)
Posts: 12
|
Hello, i'm trying to set up dynamic periods for a fiscal calendar date dimension. My date hierarchy is Fiscal year - fiscal quarter - month - day fiscal year starts 1st of april, so first fiscal quarter is april - june (for example) my attributes in the date dimension have type property set to 'fiscalyears' and 'fiscalquarters'. I don't manage to get this working with dynamic period. I use syntax : #|TimeDef:[<>].[<FQ1|FQ2|FQ3|FQ4>].[<april|mei|juni|juli|augustus|september|oktober|november|december|januari|februari|maart>].[<DD/MM/YYYY>]|# but it doesn't work does anyone know why? is there any documentation somewhere about this syntax and what the necessary setup is? I can't seem to find anything about this thanks in advance, Sylvie
|
|
|
|
|
|
 Rank: Administration
Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 483
|
Hi Joke,
I am pretty sure TARGIT will only accept 'Years', 'Quarters', 'Months', 'Days', 'Weeks' as attribute types - so that would be the first thing I would look into.
BR / Ole |
I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S.  Ole Dyring |
|
|
|
|
|
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.