Search found 423 matches

by BariAbdul
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...
by BariAbdul
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
by BariAbdul
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
by BariAbdul
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
by BariAbdul
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.
by BariAbdul
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...
by BariAbdul
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...
by BariAbdul
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.
by BariAbdul
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...
by BariAbdul
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
by BariAbdul
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
by BariAbdul
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
by BariAbdul
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...
by BariAbdul
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...
by BariAbdul
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

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
This might help.
http://www.tm1forum.com/viewtopic.php?f=3&t=1109&p=6155 Thanks