en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Shun Lu  
#1 Posted : Friday, August 23, 2013 2:27:46 AM(UTC)
Shun Lu
Rank: Member

Groups: extranet\Customer
Joined: 5/28/2013(UTC)
Posts: 9

My database have year, quarter,month, day, This one applied the Dynamic period successfully.

Also got Fiscal Year number, Fiscal Quarter number, Fiscal Month number, day

i tried to use the offset:-6 as: and used the Attribute Type: Year, Quarter, Month, Day. ----#|TimeDef:[<>].&[<>].&[<>].&[<>],offset:-6|# But this one does not return the correct number.

Shall I apply the offset:-6 to the Calendar hierarchy instead of fiscal year hierarchy?

Any one know how to create the Fiscal Dynamic Period with this?


Niels Thomsen  
#2 Posted : Friday, August 23, 2013 10:47:15 AM(UTC)
Niels Thomsen
Rank: Advanced Member

Groups: extranet\Customer
Joined: 4/5/2011(UTC)
Posts: 105

Hi Shun

Your full Timedef syntax seems fine (depending on your period hierarchy) and the offset is placed excactly where it belongs - on the Fiscal Hierarchy description property.

I also assume that you have remembered to set the property type to the appropriate value, in short:

Fiscal Year - Type=Years
Fiscal Quarter - Type=Quarters
Fiscal Month - Type=Months
Fiscal Day - Type=Days

and off course the Period Dimension should be Type=time

Finally you need the equivalent columns in your time table - Fiscal Year, Fiscal Quarter, Fiscal Month, Fiscal Day - all set up with the offset of -6 months.

If you need further explanation I can refer you to Knowledge Base articles in the TARGIT Portal. There are multiple if you use the search term dynamic time or fiscal date.

Hope it makes sense.
Hope it makes sense.

Best Regards
Niels Thomsen

https://dk.linkedin.com/in/ncthomsen


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