 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.
|
|
|
|
|
|
 Rank: Administration
Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 508
|
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 |
|
|
|
|
|
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
|
|
|
|
|
|
Rank: Administration
Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 508
|
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 |
|
|
|
|
|
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.