en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Jeremy Kimmons  
#1 Posted : Friday, June 7, 2013 11:37:41 AM(UTC)
Jeremy Kimmons
Rank: Member

Groups: extranet\Forum
Joined: 2/28/2013(UTC)
Posts: 9

Hi all - I am attempting to configure and implement dynamic time functions in Targit 2k11 build 5418.

Here's where I have got to - I have created in my cube a dimension of type Time, and within that a Fiscal Hierarchy.
This has 5 levels:

Fiscal Year (set as type FiscalYears)
Fiscal Year and Quarter (set as type FiscalQuarterOfYear)
Fiscal Year and Month (set as type FiscalMonthOfYear)
Fiscal Year and Week (set as type FiscalWeekOfYear)
Full Date (set as type Date)

Here's an example of the structure of each level:

2013
Qtr 1 2013
P01 - APR 2013
Week 1 2013
2013-03-31 00:00:00.000


So, my primary question is - what should the syntax of the TimeDef be?

I've got as far as <YYYY>.<"Qtr "Q YYYY> for the first two elements (although confirmation that those are correct would be handy), but after that i'm stumped!

Note that these fiscal elements are being fed from a database table with the correct fiscal values in it, so I think i'm right in saying that there doesn't need to be any offsetting done, as there is in the example given for a fiscal calendar.


Many thanks in advance for any help, this is driving me nuts!

Cheers

Jeremy
Peter  
#2 Posted : Friday, June 7, 2013 1:53:27 PM(UTC)
Peter
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/1/2011(UTC)
Posts: 39

Hi Robert

Take a look in the "Installation and configuration guide" there are some good examples there (You can find it in the download center on the TARGIT portal as a part of the download for your version of TARGIT).

Right off the bat I can tell you that you have to change the types, even though they're "fiscal" to you the only types supported by TARGIT is:

Years
Quarters
Months
Weeks
Days

Expecially note that it's days and NOT date ;-)

I would recommend you using keys instead of addressing the "Name" column of the attributes.

An example of keys I would see relevant below:
2013 : 2013
20131 : Qtr 1 2013
201301 : P01 - APR 2013, 201302 : P02 - MAY 2013
201301 : Week 1 2013, 201352 : Week 52 2013
20130331 : 2013-03-31 00:00:00.000

You can use the SQL datepart or similar functions to extract information for each of the levels.
One of my classical is the period (yearmm) that I lots of times create like this: year(datecolumn)*100+periodcolumn 2013*100 = 201300 + 12 (Period 12) = 201312.

An example for a timedef for a hierarchy with Year, Quarter, Month, Day could then be: #|TimeDef:&[YYYY].&[YYYYQ].&[YYYYMM].&[YYYYMMDD]#|

To sum it up; try reading the installation guide, follow my tips and if you don't get it up and running then don't get frustrated. Contact support and set up a session with a consultant. It's usually very well worth it and ensures you get a great start on building your own cube.

Best Regards,

TARGIT

Peter Orum
Product Manager
Jeremy Kimmons  
#3 Posted : Friday, June 7, 2013 5:49:13 PM(UTC)
Jeremy Kimmons
Rank: Member

Groups: extranet\Forum
Joined: 2/28/2013(UTC)
Posts: 9

Hi Peter - thanks for the info, the guide re: not using Fiscal types is certainly something I wouldn't have realised otherwise.

I've added key fields as per your suggestions to the underlying database that Time is built from, and added those to the attributes, and changed the attribute types. I've rebuilt my Year/Quarter/Month/Week/Day hierarchy with them, and set the TimeDef on the hierarchy as:

#|TimeDef:&[YYYY].&[YYYYQ].&[YYYYMM].&[YYYYWW].&[YYYYMMDD]|#

However, i'm still not getting dynamic functionality once this has built.

A couple of other quick questions:

Which attribute should be the key attribute for the dimension?
My attribute relationships go date->year/week->year/month->year/quarter->year - is that correct?
Is there fundamentally an option somewhere in the targit server that needs to be set to enabled dynamics?


Many thanks for the help.


Edited by user Friday, June 7, 2013 5:58:14 PM(UTC)  | Reason: Not specified

Jeremy Kimmons  
#4 Posted : Friday, June 7, 2013 6:25:55 PM(UTC)
Jeremy Kimmons
Rank: Member

Groups: extranet\Forum
Joined: 2/28/2013(UTC)
Posts: 9

Peter - ignore that previous post, i'd done something dumb - it's now working!


Many thanks for the help!

Peter  
#5 Posted : Friday, June 7, 2013 6:37:02 PM(UTC)
Peter
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/1/2011(UTC)
Posts: 39

Glad that I could help you out ;-)

Have a great weekend.

Peter
Peter  
#6 Posted : Sunday, June 9, 2013 4:08:17 PM(UTC)
Peter
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/1/2011(UTC)
Posts: 39

I suddenly noticed that there are things missing from our post, the greater than and less than sign before the level-details. This is how it should be.

#|TimeDef:&[<YYYY>].&[<YYYYQ>].&[<YYYYMM>].&[<YYYYWW>].&[<YYYYMMDD>]|#

However you will get yourself in trouble with having a hierarchy like

Year
Quarter
Month
Week
Day

Since months and weeks don't go together by default; a week can span several months, e.g. Week 1 can e.g. be Dec, 31st, Jan 1st, ..., Jan 6th.

You can resolve this if you use a lookup table (see the documentation ;-))

My recommendation for your scenario is to create two hierarchies: Year, Quarter, Month, Day and another with Year, Week, Day.

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