Question about time dimension

Post Reply
lynnsong986
Posts: 83
Joined: Wed Feb 28, 2018 2:20 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016

Question about time dimension

Post by lynnsong986 »

Hello,

this is a dumb question...can someone please tell me if there is a difference between the two time dimensions? the second on is an existing one and I manually created the first one. they are both sorted by hierarchy but look very differently (the YTD part), trying to understand why here...

thanks so much!
Attachments
Capture2.PNG
Capture2.PNG (15.6 KiB) Viewed 4781 times
Capture.PNG
Capture.PNG (22.7 KiB) Viewed 4781 times
ascheevel
Community Contributor
Posts: 312
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.9.1
Excel Version: 365
Location: Minneapolis, USA

Re: Question about time dimension

Post by ascheevel »

The component sort sense is probably different between the two. Provided the element weights within the consolidations are the same, you'd get the same results.


https://www.ibm.com/support/knowledgece ... order.html
lynnsong986
Posts: 83
Joined: Wed Feb 28, 2018 2:20 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016

Re: Question about time dimension

Post by lynnsong986 »

Ok got it thanks so much again!
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Question about time dimension

Post by tomok »

Is this supposed to be a trick question? The first dimension has 14 periods while the second one has only 12. Also, following the YTD logic the second dimension is missing 13-YTD.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
lynnsong986
Posts: 83
Joined: Wed Feb 28, 2018 2:20 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016

Re: Question about time dimension

Post by lynnsong986 »

No it’s not...sorry I was just trying to understand why the YTD part looks so different.
Post Reply