Search found 127 matches

by dilip
Wed Jul 20, 2016 12:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: single quote in source path while copying data
Replies: 1
Views: 1822

single quote in source path while copying data

I want to copy files from one path to another

say from csourcepath='\\abc\k\user's data' to ctargetpath='\\def\gggg\mn data'


how we can remove single quote in source path as TM1 is throwing syntax error because of single quote between r's
by dilip
Mon Jul 04, 2016 6:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to add html code or any idea in TI process while sending email
Replies: 3
Views: 3226

Re: How to add html code or any idea in TI process while sending email

Currently I am using TI code no vbs....no other scripting i have used except TM1 code of sending email which i got from google. similar to like as shown below...need to format body of an email like as shown below....means i need "enter" after 2 line..... sFrom = 'tm1@yourcompany'; sTo = 'r...
by dilip
Mon Jul 04, 2016 6:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to add html code or any idea in TI process while sending email
Replies: 3
Views: 3226

How to add html code or any idea in TI process while sending email

Hi, Iam facing 1 issue..i.e I want to send email using TI process...but new line is not coming..in Body part of email..I tried Char(10),Char(13),\n,\r\n,%20...but no progress....Can anyone of you help me in getting a body to be separate...or any idea which best suits...all the article which i got......
by dilip
Tue Dec 29, 2015 5:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders is not working
Replies: 4
Views: 3297

Feeders is not working

Hi, I have written rule and written feeders also but feeders is not feeding correct values,Can you please help what error Iam making. SKIPCHECK; # Like Port = SYD(Sydney),so CityPair(Combination of OriginDestination of AirCraft) which Is related to SYD Port. Exa. - Port - SYD,CityPair - 'SYDMEL' ['N...
by dilip
Fri Jul 24, 2015 11:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Different Hierarchy in Same Dimension
Replies: 13
Views: 7194

Re: Different Hierarchy in Same Dimension

Thanks wim for your reply...I will test this and will come back to you...
by dilip
Fri Jul 24, 2015 11:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Invalid key dimension error
Replies: 5
Views: 6521

Re: Invalid key dimension error

Thanks sachin and declanr..for this post...
by dilip
Fri Jul 24, 2015 10:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Size and RAM of TM1
Replies: 3
Views: 3597

Re: Size and RAM of TM1

Thanks Kamal or qml...for your reply...
by dilip
Fri Jul 24, 2015 10:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Element type as String Vs Simple difference
Replies: 9
Views: 8144

Re: Element type as String Vs Simple difference

Thanks everyone....I appreciate your answers...Now My confusion is gone.
by dilip
Thu Jul 23, 2015 8:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drilldown in TM1
Replies: 4
Views: 4063

Re: Drilldown in TM1

Hi Jim,

Thanks for your post.

So you mean that we can insert a graph using active forms and then go to insert tab and insert graphs...correct..?But that graph will be static,is it Jim..?
by dilip
Thu Jul 23, 2015 8:48 pm
Forum: Cognos Planning and BI
Topic: Macros and Links In Planning
Replies: 4
Views: 48777

Re: Macros and Links In Planning

So If we wan t migrate from Cognos EP to Cognos TM1 ..what should be the approach..Please can you specify in steps...Nowdays Many industries are going for migration from Cognos Planning to Cognos TM1.?
by dilip
Thu Jul 23, 2015 8:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Invalid key dimension error
Replies: 5
Views: 6521

Invalid key dimension error

In the message error log file after I ran the TI process..I got the very common error..which I have seen many times...The error description is like this..."Invalid key dimension:month......or any other dimension name..... What is the cause of this type of errror...? What will be the resolution ...
by dilip
Thu Jul 23, 2015 8:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Element type as String Vs Simple difference
Replies: 9
Views: 8144

Re: Element type as String Vs Simple difference

I got 1 thread but it is not very clear to me

http://www.cognoise.com/index.php?topic=18325.0

Here in this link he is saying that last Dimension's in a cube element type should be string if the cube cell data is string otherwise simple...Is it corrcet that it depends on last dimension?
by dilip
Thu Jul 23, 2015 8:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Element type as String Vs Simple difference
Replies: 9
Views: 8144

Element type as String Vs Simple difference

When do we select element type as simple and when we do select element type as string...Simple can be either string or numeric...I ahve a confuson in this..Please clarify to me anyone?
by dilip
Thu Jul 23, 2015 8:31 pm
Forum: Cognos Planning and BI
Topic: Macros and Links In Planning
Replies: 4
Views: 48777

Re: Macros and Links In Planning

Thanks you very much Amol for such a nice explanation...Appreciate it.
by dilip
Thu Jul 23, 2015 5:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: In preview in DatasourceFile is not showing columnwise
Replies: 8
Views: 5500

Re: In preview in DatasourceFile is not showing columnwise

The Data coming from Remedy tool and we have only option to select fields and we get the output like this.....and from this excel I want to make report in our customized way..to shorten the time but since the data in excel is is not in sync due to which In TM1 preview its not coming correct....okay ...
by dilip
Thu Jul 23, 2015 5:43 pm
Forum: Cognos Planning and BI
Topic: Macros and Links In Planning
Replies: 4
Views: 48777

Macros and Links In Planning

What is the use of Macros in Planning and Links,How we can compare this Macros and Links in TM1's rules etc?
by dilip
Thu Jul 23, 2015 5:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: In preview in DatasourceFile is not showing columnwise
Replies: 8
Views: 5500

Re: In preview in DatasourceFile is not showing columnwise

Okay...Got it. ..Is there any option available to import such that each column distingguished seperately so that only i need some coulumns out of many columns ...But this data is coming from different tool in unstructerd format...Only possibility is that we need to structure that data then only we c...
by dilip
Thu Jul 23, 2015 2:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: In preview in DatasourceFile is not showing columnwise
Replies: 8
Views: 5500

Re: In preview in DatasourceFile is not showing columnwise

Same I did I saved the excel file as csv but since the data is awkward in column so in Preview the data is not showing columnwise.
by dilip
Thu Jul 23, 2015 11:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: In preview in DatasourceFile is not showing columnwise
Replies: 8
Views: 5500

In preview in DatasourceFile is not showing columnwise

Iam not able to see the preview correct of the file sample I have attached...

I have selected as delimited and comma.......Please correct me where Iam going wrong..


How we can upload this file sample as attached...There are so many records...In preview its mixing up...