Search found 39 matches

by manu0521
Thu Apr 25, 2019 4:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need VBA Code to tm1 ti
Replies: 1
Views: 48

Need VBA Code to tm1 ti

I have this code in vba macro , need to convert in ti For i = k To n If k > incFreq Then myPmt = myPmt * (1 + incRate) k = 1 End If discnt = discnt * (1 + discntRate) escPV = escPV + myPmt / discnt k = k + 1 Next Having issue where it says i =k to n , they assign K again as 1 when its greater than i...
by manu0521
Thu Apr 18, 2019 3:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Days360 Tm1
Replies: 12
Views: 984

Re: Days360 Tm1

Wim Gielis wrote:
Wed Apr 17, 2019 6:24 pm
An attribute could be a solution and not too bad, but the Dimix function gives you the index number of an element in a dimension.
So if the elements are added in the correct sequence and they remain like that, a simple difference of 2 DIMIX'es is sufficient.
Makes Sense Thanks
by manu0521
Wed Apr 17, 2019 6:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Days360 Tm1
Replies: 12
Views: 984

Re: Days360 Tm1

Should i start the difference between feb 1 2016 and dec 31 2021. Yes. You could make use of a simple dimension containing concatenated years and months as n-level elements. If you make sure that the elements are all in chronological order then a simple "DIMIX( dim, last month ) - DIMIX( dim, first...
by manu0521
Wed Apr 17, 2019 6:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Days360 Tm1
Replies: 12
Views: 984

Re: Days360 Tm1

How do you workout the number of full months between jan 10 2016 to jan 9 2021 . Divide the number of days between jan 10 2016 and jan 9 2021 by 30.4 and truncate the remainder. That integer amount will be the number of full months. This will work as long as the number of years between the two date...
by manu0521
Wed Apr 17, 2019 11:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Days360 Tm1
Replies: 12
Views: 984

Re: Days360 Tm1

HI , Thanks for the input . You work out the number of full months (e.g if you are looking between the 10th Jan and 15th May you would have 3 full months; Feb, Mar and Apr) then you multiply that by 30. How do you workout the number of full months between jan 10 2016 to jan 9 2021 . Should i start t...
by manu0521
Mon Apr 15, 2019 2:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Days360 Tm1
Replies: 12
Views: 984

Re: Days360 Tm1

Jut replied to the old thread. That one was getting EO month in tm1 .

But this one looks little complex l,because the difference can be any no of years.

Thanks,
by manu0521
Mon Apr 15, 2019 2:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: EOMonth Function
Replies: 3
Views: 183

Re: EOMonth Function

Hi thanks,

I was able to get this working using the below approach .
by manu0521
Sun Apr 14, 2019 3:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Days360 Tm1
Replies: 12
Views: 984

Days360 Tm1

Hi, We are building a lease accounting calculation in tm1 . In this calculation we would like to replicate the functionality of excel's days360 function. Days360 in excel would give me the number of days between two dates considering a 30 month period for each month . I can do date differnce in tm1 ...
by manu0521
Sun Apr 07, 2019 3:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: EOMonth Function
Replies: 3
Views: 183

Re: EOMonth Function

Thanks , will give it a try .
by manu0521
Sun Apr 07, 2019 4:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1 form
Replies: 0
Views: 211

tm1 form

Hi, we are trying to create an lease accounting application using tm1 . Initial requirement is to , users having the capability to enter lease related information and then process the lease calculations . To enter this with fields having few validations which tool should i use , they are expecting t...
by manu0521
Sun Apr 07, 2019 4:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: EOMonth Function
Replies: 3
Views: 183

EOMonth Function

Hi,
Is there an EOMonth function available in tm1 ti . If not how do I achieve it to get the end of month date based on a given date .

I would need to get the end of month the current month and next month as well ,
Any suggestions is appreciated .

Thanks,
by manu0521
Wed Apr 03, 2019 7:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Moving to new server
Replies: 2
Views: 157

Moving to new server

Hi Guys,

We are moving to a new server and we didnot use ip name in all our source ti process . So now if we move to a new server we need to change all the ti's with new source name .

IS there a way we can write a ti which will open all ti 's and change the source path name .


Thanks,
by manu0521
Tue Apr 02, 2019 2:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: how to show a description of member in a mdx .
Replies: 1
Views: 107

how to show a description of member in a mdx .

Hi ,

I have the elements with alias defined as Description .

How do i automatically select the descriptions ,

{TM1SORT( TM1FILTERBYLEVEL({TM1SUBSETALL( [Cost Centers] )},0), ASC)}

This gives me all members sorted ascending , i want it to show the description of members sorted ascending .
Thanks,
by manu0521
Thu Mar 07, 2019 1:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Delimiter to be Used
Replies: 2
Views: 317

Re: Delimiter to be Used

what if a column value has quotes in it , will this still work .
by manu0521
Wed Mar 06, 2019 9:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Delimiter to be Used
Replies: 2
Views: 317

Delimiter to be Used

Hi , We have daily load files from SAP BW which the TI uses to load the data . SAP BW send us a file with semicolon delimited and if there are any columns having semicolon in the value itself we have an issue putting it in right place . We plan the file from BW to be '^' delimited to avoid this issu...
by manu0521
Fri Feb 15, 2019 9:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Basic Question - Tm1 service
Replies: 3
Views: 308

Re: Basic Question - Tm1 service

What is the purpose of the service namedd IBM Cognos TM1 service.

What products affect if I stop that service or what application is dependent on this service ,

Can i stil lrun paw or tm1 web with this service being stopped.
by manu0521
Fri Feb 15, 2019 8:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Basic Question - Tm1 service
Replies: 3
Views: 308

Basic Question - Tm1 service

Hi ,

Any one can tell me what this

IBM Cognos TM1 service in windows service does . I stopped this service and I was still able to login to one of the tm1 servers thrrough architect .

Thanks,
by manu0521
Wed Feb 06, 2019 4:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Write a calculated value to all elements in a dimension
Replies: 2
Views: 135

Re: Write a calculated value to all elements in a dimension

Thanks !! Will store it in an Attribute value and then use it . Thanks!!
by manu0521
Wed Feb 06, 2019 2:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Write a calculated value to all elements in a dimension
Replies: 2
Views: 135

Write a calculated value to all elements in a dimension

Hi ,

I wanted to write a calulated value to all values in time dimnension in a TI ,
is there a simpler way to do it or it has to be cellputn for all elements .

I cannot use a rule for performance issue and bringing in as a ti .

Thanks,
by manu0521
Mon Feb 04, 2019 9:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ascii output ,blank row at end
Replies: 3
Views: 125

Re: Ascii output ,blank row at end

Yes a different system needs it without a blank line . Any workarounds.