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!
Question about time dimension
-
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
- Attachments
-
- Capture2.PNG (15.6 KiB) Viewed 4782 times
-
- Capture.PNG (22.7 KiB) Viewed 4782 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
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
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
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
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.
-
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
No it’s not...sorry I was just trying to understand why the YTD part looks so different.