Search found 43 matches

by manu0521
Fri Jun 14, 2019 2:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel Form Uploaded in PAX
Replies: 2
Views: 251

Re: Excel Form Uploaded in PAX

Yes this is helpful . Thanks !! I will give it a try and let you know how it goes.
by manu0521
Thu Jun 13, 2019 8:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel Form Uploaded in PAX
Replies: 2
Views: 251

Excel Form Uploaded in PAX

Hi Guys, I have like an excel form created in excel with some basic validations on the sheet and loaded it to paw as a book . Users will be able to enter the details in the form and I plan to have a submit button which write the value in a TI Process from the sheet in to a attribute cube . I wanted ...
by manu0521
Sun Jun 02, 2019 12:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Rules with Date and month
Replies: 3
Views: 549

Re: Tm1 Rules with Date and month

so you are asking me store an attribute at day level .

so for 2018-01-01 i store an attribute value of 201807 right?

That should work ,let me try that.

Thanks,
by manu0521
Sun Jun 02, 2019 12:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Rules with Date and month
Replies: 3
Views: 549

Tm1 Rules with Date and month

Hi Guys, I wanted to know how to perform the below task . I have a cube with months dimension like Year - 2018 Month - 201801 Date - 2018-01-01 Now this is calendar year and values are stored in day level. Now there is a rule in the cube which goes to exchange rate cube which has a different month d...
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: 145

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: 1204

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: 1204

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: 1204

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: 1204

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: 1204

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: 276

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: 1204

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: 276

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: 272

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: 276

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: 220

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: 147

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: 356

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: 356

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: 374

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.