en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Martin O'Loughlin  
#1 Posted : Wednesday, February 20, 2019 11:54:58 AM(UTC)
Martin O'Loughlin
Rank: Member

Groups: extranet\Forum
Joined: 5/14/2018(UTC)
Posts: 7

i have created a decoration using the following, to create a dynamic financial year calendar. I have done the same without a lookup to create a calendar year table and this is functioning.


definition; [<YYYY>].[<>].[<DD/MM/YYYY>]

The lookup table; DimLookupPeriod

level; years, months, Days.



The lookup table is 4 columns

TheDate Year Month Day

Thedate is a datetime starting 2008-07-11 00:00:00.000
Year is an int, 2007, 2008, 2009 etc
Month is a char(7) contents 1, 2, 3, 4, 5, 6, etc
Day is varchar(12) and in format DD/MM/YYYY


A this is to form a financial calendar the first day is about the 31/7/YYYY hence the the lookup table.

In Targit it recognises a dynamic calendar but only at the year level.

Can someone suggest where i may have gone wrong please.



Ole  
#2 Posted : Wednesday, February 20, 2019 12:28:42 PM(UTC)
Ole
Rank: Administration

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

Could be many things. The good news is that it is working on the Year level.

With regard to the month level, you may try these:

[<M>]
&[<M>]
[<MM>]
If you have a special key column for the Month attribute, e.g. a combined key with Year and Month, like '201807', then you should try something like:
&[<YYYYMM>]

BR / Ole

Edited by user Wednesday, February 20, 2019 12:29:31 PM(UTC)  | Reason: Not specified

Ole Dyring
Martin O'Loughlin  
#3 Posted : Wednesday, February 20, 2019 2:59:22 PM(UTC)
Martin O'Loughlin
Rank: Member

Groups: extranet\Forum
Joined: 5/14/2018(UTC)
Posts: 7

Thank you, that has solved that level. however i am now having an issue on the day level.

As an observation if i use the dynamic date origin the current period is updating. I am just unable to select the day in the criteria bar or elsewhere.

So i am assuming a format issue?

Would you be able to advise where the issue might be.

The day in the lookup table is in format dd/mm/yyyy the format in the date table within targit is also dd/mm/yyyy
Ole  
#4 Posted : Friday, February 22, 2019 12:08:47 PM(UTC)
Ole
Rank: Administration

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

Again, I will rely on guessing.

Could be a simple thing: That you don't have data for 'today'. Try setting 'Dynamic date origin' to a date where you are sure you have data - see if that enables the day level in your dynamic criteria.

You may also consider looking into the key column of your day level, i.e. &[<something>].

Otherwise I will need screenshots of your namecolumn/keycolumn setup; of a table with all three levels visible in TARGIT; of the columns in your source table...

BR / Ole
Ole Dyring
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

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.

ok