This might also help:
http://www.tm1forum.com/viewtopic.php?f=3&t=1109&p=6155 Thanks
Search found 423 matches
- Thu Feb 23, 2017 11:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Loading a csv with numeric and string value
- Replies: 3
- Views: 3319
- Wed Feb 22, 2017 3:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Combine multiple cubes and re-number
- Replies: 5
- Views: 4224
Re: Combine multiple cubes and re-number
You explanation of situation need bit more effort in describing as TM1 guru Alan Kirk said in below link: http://www.tm1forum.com/viewtopic.php?t=11374 I think that you would need to be a lot more specific than that. You haven't indicated whether you want to do this through Ti or through rules, or w...
- Fri Feb 17, 2017 11:28 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Sorting element value
- Replies: 3
- Views: 3097
Re: Sorting element value
One more perspective on sorting elements:
https://everanalytics.wordpress.com/201 ... grator-ti/ Thanks
https://everanalytics.wordpress.com/201 ... grator-ti/ Thanks
- Fri Feb 10, 2017 5:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cube Rule
- Replies: 8
- Views: 5345
Re: Cube Rule
Bit more on nested DB could be found in below post:
http://www.tm1forum.com/viewtopic.php?f ... +DB#p61807 Thanks
http://www.tm1forum.com/viewtopic.php?f ... +DB#p61807 Thanks
- Tue Feb 07, 2017 1:43 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic subset based on other dimension selection
- Replies: 1
- Views: 2002
Re: Dynamic subset based on other dimension selection
I don't know whether it is exactly what you are looking for,but worth having look at it:
http://www.tm1forum.com/viewtopic.php?t=5933
http://www.tm1forum.com/viewtopic.php?t=10416
http://www.tm1forum.com/viewtopic.php?t=12391 Thanks
http://www.tm1forum.com/viewtopic.php?t=5933
http://www.tm1forum.com/viewtopic.php?t=10416
http://www.tm1forum.com/viewtopic.php?t=12391 Thanks
- Tue Jan 17, 2017 11:37 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Fastest way to Load data from excel to cube
- Replies: 4
- Views: 3173
Re: Fastest way to Load data from excel to cube
why can't you simply save it as CSV and load the data in to the cube? is Excel is must? Thanks
- Mon Dec 26, 2016 4:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Impact on TM1 from changing Astronomical time (UT1) to Coordinated Universal Time (UTC)
- Replies: 2
- Views: 1980
Re: Impact on TM1 from changing Astronomical time (UT1) to Coordinated Universal Time (UTC)
Thanks a lot Alan for your help.Happy holidays!
- Thu Dec 22, 2016 12:07 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 10.2: Get Filesize via TI
- Replies: 4
- Views: 3447
Re: TM1 10.2: Get Filesize via TI
Thanks , gtonkin.Quite useful.
- Wed Dec 21, 2016 1:38 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Impact on TM1 from changing Astronomical time (UT1) to Coordinated Universal Time (UTC)
- Replies: 2
- Views: 1980
Impact on TM1 from changing Astronomical time (UT1) to Coordinated Universal Time (UTC)
Hi Gurus,coming Leap Second change introduced by International Earth Rotation and Reference Systems Service (IERS) on 31st December.Our organization going to do Leap second addition on 31st December 2016.I would appreciate,if gurus could help in figuring out what impact this Coordinated Universal Ti...
- Thu Dec 08, 2016 12:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Unable to load all the records into Target Cube
- Replies: 6
- Views: 4106
Re: Unable to load all the records into Target Cube
Please read Alan's advice carefully again. eah. No it isn't. First, TI generally ignores white space. Second, the log file is telling you clearly and unambiguously what the error is. It's that in the List Item dimension, the element ( 618) DASNFAM - CHP SES ASN FAM - 8 Pk DISPLAY does not exist. You...
- Tue Dec 06, 2016 10:11 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Admin service not starting
- Replies: 4
- Views: 2686
Re: Admin service not starting
Please go through below posts:
http://www.tm1forum.com/viewtopic.php?f=3&t=12728
https://www.ibm.com/developerworks/comm ... 6e8c&ps=25
Thanks
http://www.tm1forum.com/viewtopic.php?f=3&t=12728
https://www.ibm.com/developerworks/comm ... 6e8c&ps=25
Thanks
- Sat Nov 05, 2016 4:13 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Post SSL certificate update TM1 admin server doesn't stop
- Replies: 3
- Views: 4273
Re: Post SSL certificate update TM1 admin server doesn't stop
Thanks for tip, gtonkin. I did overwrite SSL folder when it moved in.Restarting the box bought the things to normal.Thanks again.
- Thu Nov 03, 2016 10:49 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Post SSL certificate update TM1 admin server doesn't stop
- Replies: 3
- Views: 4273
Post SSL certificate update TM1 admin server doesn't stop
HI Gurus, W have successfully updated the SSL certificates in our UAT environment. Post upgrade when I try to stop TM1 admin server it is giving me an error (Please see the attachment).It showing always in start mode.I have also try to shut down by going to services to no avail. It is pre FP4 enviro...
- Sun Oct 30, 2016 12:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: 10.2.2 Backward Compatibility
- Replies: 8
- Views: 5560
Re: 10.2.2 Backward Compatibility
I am afraid you have no option other than upgrading to 10.2.2.It works vice versa but not this way around.Thanks
- Fri Oct 28, 2016 1:33 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI Process
- Replies: 1
- Views: 1776
Re: TI Process
It might be not exactly what you been looking for ,But you will get the gist of it.
http://www.tm1forum.com/viewtopic.php?t=1785
http://www.tm1forum.com/viewtopic.php?t=8194 Thanks
http://www.tm1forum.com/viewtopic.php?t=1785
http://www.tm1forum.com/viewtopic.php?t=8194 Thanks
- Mon Oct 17, 2016 8:56 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SSL breaks on Nov 24 (TM1 SSL Certificates Expire on 24 November)
- Replies: 164
- Views: 124120
Re: SSL breaks on Nov 24
Sorry if it has already been posted here,Could be useful
https://www.ibm.com/developerworks/comm ... c94f&ps=25 Thanks
https://www.ibm.com/developerworks/comm ... c94f&ps=25 Thanks
- Fri Oct 14, 2016 11:57 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Top 10 Projects in a TM! Perspectives report
- Replies: 2
- Views: 2277
Re: Top 10 Projects in a TM! Perspectives report
This is according to MDX premier TopCount and BottomCount A classic Top 10 command: { TOPCOUNT( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [Product] )}, 0)}, 10, [Test].([Posting Measures].[Amount]) )} By omitting a sort order it sorts in the default order (which has the values descending in value and breaks...
- Wed Oct 12, 2016 4:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Element rename
- Replies: 2
- Views: 3593
Re: Element rename
Please have look :
http://www.tm1forum.com/viewtopic.php?t=3832
http://www.tm1forum.com/viewtopic.php?t=569 Thanks
http://www.tm1forum.com/viewtopic.php?t=3832
http://www.tm1forum.com/viewtopic.php?t=569 Thanks
- Sat Oct 01, 2016 4:40 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Numeric values not copying from source to target elaments
- Replies: 44
- Views: 16158
Re: Numeric values not copying from source to target elaments
I have to load data from my source customer to multiple target customers, similarly from source version to multiple target versions.I have a maximum of 50 target customers and 10 target versions. I am loading the data with customer and version combination. I have built lookup cube with pick list in...
- Fri Sep 30, 2016 12:46 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Numeric values not copying from source to target elaments
- Replies: 44
- Views: 16158
Re: Numeric values not copying from source to target elaments
This might help.I have both string and numeric data in my cube. I have attached my TI code. Please suggest me like where i am going wrong
http://www.tm1forum.com/viewtopic.php?f=3&t=1109&p=6155 Thanks