Welcome Guest! To enable all features please Login or Register.
Go to last post Go to first unread
#1 Posted : Tuesday, February 12, 2013 6:41:34 PM(UTC)
Rank: Advanced Member

Groups: extranet\Forum
Joined: 11/29/2012(UTC)
Posts: 18


I have found out an awkward behaviour when using Dynamic Periods. The following case has been generated using standard data within default demo TARGIT cubes:

I want to generate a table showing SALES INVOICE AMOUNT by month, FROM January current year TO the latest closed month (i.e. if today is June, 13th 2011, the table will show only 5 months. from January to May). See image 1


When changing the Date Origin to different months it always works fine showing correct results until I set a date in January.
For instance, if I change the Date Origin to January, 5th 2012, the result returned by TARGIT is not the expected. See image below:


In this latest case I would be expecting TARGIT showing results from January 2011 to December 2011. How should I do that?
Once the Date Origin is changed to February 2012, it starts again then showing correct data again.


Any ideas on how to accomplish or fix this issue?


Edited by user Tuesday, February 12, 2013 6:44:17 PM(UTC)  | Reason: Not specified

#2 Posted : Wednesday, February 13, 2013 8:38:12 AM(UTC)
Rank: Administration

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

This is the (unfortunate) behaviour you would see from the Dynamic Year-to-previous-month criteria in the TARGIT BI Suite prior to 2K11 SR3. With 2K11 SR3 we introduced a new and improved way of handling Dynamic Criteria - introducing the concept of "offsets". The predefined Year-to-previous-month in 2K11 SR3 will produce the expected result (all 12 months of previous year) when in January.
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.