pt
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Joke Laukens  
#1 Posted : Thursday, April 18, 2019 2:12:02 PM(UTC)
Joke Laukens
Rank: Advanced Member

Groups: extranet\Forum
Joined: 8/8/2018(UTC)
Posts: 11

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
Users browsing this topic
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.

Notification

Icon
Error