Welcome Guest! To enable all features please Login or Register.
Go to last post Go to first unread
#1 Posted : Wednesday, February 6, 2013 4:01:01 PM(UTC)
Rank: Guest

Groups: extranet\Forum
Joined: 3/9/2011(UTC)
Posts: 1

I have a simple analysis that is looking to summarize data by month. The data has all transactions for December 2012 coded with a transaction date of '12/01/2012'. In the Anlysis I have a global criteria set up for This Year = 0, This month = 0 Use Dynamic Periods. If in the Dynamics Date Origin I enter 12/30/2012, or any date between 12/01/2012 and 12/30/2012, I get the correct results, if I enter 12/31/2012 I get nothing.

The period table has 12/31/2012 as Year 2012, Month 12, Quarter 4, Week 52

Any ideas?

Thank you!
#2 Posted : Friday, February 8, 2013 9:19:43 AM(UTC)
Rank: Administration

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

I think it has something to do with having a Week level in your hierarchy. 12/31/2012 may not be week 52, but may actually be week 1 of 2013. Still, it should be able to get the correct result. Will it be possible for you to insert a screenshot in this post of how you have set up your dynamic critera? A screenshot of the criteria editor, please.
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
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.