en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Ole  
#1 Posted : Friday, March 1, 2013 2:53:18 PM(UTC)
Ole
Rank: Administration

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

Notice: While the information below is still valid and valuable, you should start by watching this video, created October 2015: How to set up Dynamic Criteria through Decorations


The general requirements for a Period dimension to become dynamic are these:

- The dimension itself must be of type "Time".
- The attributes being used in the hierarchy must be of proper types: Years, Months, Days etc.
- The Description property of the hierarchy must contain the TARGIT specific syntax: #|TimeDef:[<>]...[<>]|#

The general syntax for the description of the Period dimension is this:

#|TimeDef:[<>]|#

Note that a set of brackets [<>] must be included for each level in the dimension, e.g. a twolevel
hierarchical dimension with a Year and Quarter levels must have this description syntax:

#|TimeDef:[<>].[<>]|#

If the dimension values on a certain level include alphanumeric characters together with
integer numbers, these characters must be included in the description syntax. E.g. if the
Quarter level of the Time dimension has been prefixed by a ‘Q’, giving the values Q1, Q2, Q3
and Q4, the syntax must be:

#|TimeDef:[<>].[Q<>]|#

If the dimension values do not contain any integer values, or if the prefix or postfix characters
re not unique, then the syntax must contain the full list of names. E.g. if the Month level of the
Period dimension only contains Month names (jan through dec), the syntax must be:

#|TimeDef:[<>].[Q<>].[jan|feb|mar|apr|may|jun|jul|aug|sep|oct|nov|dec]|#

Alternatively, if the KeyColumns property of a certain level of the Period dimension is different
from the NameColumn property, then the syntax may be changed to refer to the KeyColumns
instead of the default NameColumn. As an example, the Month level of the Period dimension
has often been designed with Month names (January through December) as the NameColumn
and Month numbers (1 through 12) as the KeyColumn. To refer to the integers in the
KeyColumn, the syntax must be:

#|TimeDef:[<>].[Q<>].&[<>]|#


Example 1: Year-Month-Date hierarchy.

Year level: Simple four digit years, 2012-2013-2014 etc.
Month level: KeyColumn with month numbers 1-12 and NameColumn with month names January-December.
Date level: Full dates, e.g. 2014-08-24.

Syntax: #|TimeDef:[<>].&[<>].[<YYYY-MM-DD>]|#

In this case, with a complex date level, we will need to help the system to understand the date format by providing the correct date pattern: YYYY-MM-DD.

Notice: The third level, the Date level, even though it contains dates in this example, it must still be defined as a "Days" type.


Example 2: Year-Month-Date hierarchy, where month level is based on combined key.

Year level: Simple four digit years, 2012-2013-2014 etc.
Month level: KeyColumn is a combined key with year and month numbers, e.g. 201311, 201312, 201401, 201402 etc., and NameColumn with month names January-December.
Date level: Full dates, e.g. 2014-08-24.

Syntax: #|TimeDef:[<>].&[<YYYY]&[MM>].[<YYYY-MM-DD>]|#

In this case, with a combined key, we will need to help the system to understand the YearMonth format by providing the correct key pattern: &[<YYYY]&[MM>].

Notice: The second level, the Month level, even though its key contains years and months in this example, it must still be defined as a "Months" type.

Edited by user Monday, October 19, 2015 6:55:34 AM(UTC)  | Reason: Not specified

I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S.

UserPostedImage 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