Welcome Guest! To enable all features please Login or Register.
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: 12


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 :

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,
#2 Posted : Monday, April 29, 2019 12:08:26 PM(UTC)
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 514

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
Ole Dyring
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.



We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.