Adding date in TM1 webapp adds one year

Post Reply
jviegas@bi4all.pt
Posts: 67
Joined: Fri Oct 14, 2011 3:15 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 13
Location: Portugal

Adding date in TM1 webapp adds one year

Post by jviegas@bi4all.pt »

Hi all and happy new year,

I'm facing a strange issue in a very simple tm1 app.

In a cube with no rules (it's only an input cube), I have some elements that are configured as date format (dd/mm/yyyy).

In architect I'm able to input 31/12/2013 and 30/12/2013 and the element stays with that value.

Yet, in the web app it adds one more year.

In 2013 it happens with 30/12/2013 (displaying 30/12/2014) and 31/12/2013 has the same behavior.

In 2014 I've tested and this behavior starts to happen with 29/12/2014 (after that it hads one more year).

Does anyone knows what's the issue ?

Thanks in advance,

Jorge Viegas

Admin Note: Moved to correct forum (from General).
JDLove
Posts: 49
Joined: Thu May 21, 2009 1:16 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2007

Re: Adding date in TM1 webapp adds one year

Post by JDLove »

While developing a simple date driven application we found this last week.
It looks like a bug and I was informed a PMR was raised with IBM.
jviegas@bi4all.pt
Posts: 67
Joined: Fri Oct 14, 2011 3:15 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 13
Location: Portugal

Re: Adding date in TM1 webapp adds one year

Post by jviegas@bi4all.pt »

Hi,

After investigating a bit this issue I notice that its a display error on the tm1web because the correct value is kept in architect.

In this case the situation occurs only with this dates :
30-12-2013
31-12-2013
29-12-2014
30-12-2014
31-12-2014

Thanks for the feedback (do you still have the link to the PMR created in IBM ? )

Best Regards,

Jorge Viegas
Wim Gielis
MVP
Posts: 3117
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Adding date in TM1 webapp adds one year

Post by Wim Gielis »

Jorge

Does this occur in TM1 9.5.2? I read in your profile that you use this version.
Please always state the TM1 version that you are using.

Wim
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
jviegas@bi4all.pt
Posts: 67
Joined: Fri Oct 14, 2011 3:15 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 13
Location: Portugal

Re: Adding date in TM1 webapp adds one year

Post by jviegas@bi4all.pt »

Win,

This is happening with Cognos Express 10.2 (in the Planner/Tm1 component).

Thanks,

PS: Got to update my profile (thanks for the input)
Wim Gielis
MVP
Posts: 3117
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Adding date in TM1 webapp adds one year

Post by Wim Gielis »

10.2 in TM1 Web... I put money on the fact that this is not the only bug in that version :-)
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply