en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Jeppe  
#1 Posted : Friday, July 1, 2011 2:39:03 PM(UTC)
Jeppe
Rank: Newbie

Groups: extranet\Forum
Joined: 7/1/2011(UTC)
Posts: 5

I'm trying to enable dynamic periods in a SSAS 2008 time dimension. The problem is that I cant change the periods dimension to fit Targit and I'm forced to use reference the attribute names in the description syntax - i think.

I have a period hierarchy with Year-Quarter-Month-Date.

Example:

Year
Key (date): 2010-01-01
Name: 2010

Quarter
Key(date): 2010-04-01
Name: 2010Q2

Month
Key(date): 2010-04-01
Name: April, 2010

Date
Key (date): 2010-04-01
Name: 1. April 2010

What syntax should I write in the description field on the period hierarchy?

My biggest problem is the Quarter where I have to use the name (because the quarter number isnt in the key) - but there is a "Q" in the middle of the name ex. 2010Q2.

I have tried the following with no luck.

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

Is it possible?

Best regards
Jeppe Salmonsen
d60
Jeppe  
#2 Posted : Monday, July 4, 2011 3:21:33 PM(UTC)
Jeppe
Rank: Newbie

Groups: extranet\Forum
Joined: 7/1/2011(UTC)
Posts: 5

Hi again,

I solved it using TableLookup.

I would still like to know if it is possible to reference an attribute key or name with a character ex. 2010Q2?

Best regards
Jeppe Salmonsen
d60
Ole  
#3 Posted : Tuesday, July 12, 2011 3:57:30 PM(UTC)
Ole
Rank: Administration

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

To reference something like 2011Q2 you should use this syntax on the quarter level:

[<YYYY"Q"Q>]
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