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: 514

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.
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.



We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.