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: 3241
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
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-2025
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: 3241
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
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-2025
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