Welcome Guest! To enable all features please Login or Register.
Go to last post Go to first unread
#1 Posted : Monday, February 10, 2014 4:13:22 PM(UTC)
Rank: Member

Groups: extranet\Forum
Joined: 12/18/2013(UTC)
Posts: 9


Is there a way to add the week number to posting date hierarchy? so that i will have year > quarter > month > week > day

Niels Thomsen  
#2 Posted : Tuesday, February 11, 2014 10:01:03 AM(UTC)
Niels Thomsen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/5/2011(UTC)
Posts: 105

Hi Esborn

I assume you are talking about using the TARGIT BI Accelerator - unfortunately current version does not hold the option to add the week attribute.

However it's very possible to add week number manually in the backend.

The hierachy you suggest with year - quarter - month - week - day will be a bit of a headache though.
Since a certain week may belong to two different months, the month - week part of the hierarchy won't be a good idea in practical terms.

Maybe year - week - day in one separate hierarchy will be a better idea.

The actual implementation is a little out of the scope for this forum. If you wish to be able to add such extra attributes yourself to the cube I recommend the TARGIT Datawarehouse Developer training :-)

Hope it makes sense.
Hope it makes sense.

Best Regards
Niels Thomsen


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.