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
Search found 127 matches
- 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: 1847
- 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: 3290
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...
- 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: 3290
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......
- Tue Dec 29, 2015 5:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeders is not working
- Replies: 4
- Views: 3354
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...
- Fri Jul 24, 2015 11:04 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Different Hierarchy in Same Dimension
- Replies: 13
- Views: 7247
Re: Different Hierarchy in Same Dimension
Thanks wim for your reply...I will test this and will come back to you...
- Fri Jul 24, 2015 11:03 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Invalid key dimension error
- Replies: 5
- Views: 6616
Re: Invalid key dimension error
Thanks sachin and declanr..for this post...
- Fri Jul 24, 2015 10:58 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Size and RAM of TM1
- Replies: 3
- Views: 3645
Re: Size and RAM of TM1
Thanks Kamal or qml...for your reply...
- 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: 8255
Re: Element type as String Vs Simple difference
Thanks everyone....I appreciate your answers...Now My confusion is gone.
- Thu Jul 23, 2015 8:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Drilldown in TM1
- Replies: 4
- Views: 4106
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..?
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..?
- Thu Jul 23, 2015 8:48 pm
- Forum: Cognos Planning and BI
- Topic: Macros and Links In Planning
- Replies: 4
- Views: 50878
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.?
- Thu Jul 23, 2015 8:46 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Invalid key dimension error
- Replies: 5
- Views: 6616
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 ...
- 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: 8255
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?
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?
- 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: 8255
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?
- Thu Jul 23, 2015 8:31 pm
- Forum: Cognos Planning and BI
- Topic: Macros and Links In Planning
- Replies: 4
- Views: 50878
Re: Macros and Links In Planning
Thanks you very much Amol for such a nice explanation...Appreciate it.
- Thu Jul 23, 2015 7:07 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: In preview in DatasourceFile is not showing columnwise
- Replies: 8
- Views: 5548
Re: In preview in DatasourceFile is not showing columnwise
Okay Thanks Tom I got it...
- 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: 5548
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 ...
- Thu Jul 23, 2015 5:43 pm
- Forum: Cognos Planning and BI
- Topic: Macros and Links In Planning
- Replies: 4
- Views: 50878
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?
- 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: 5548
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...
- 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: 5548
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.
- 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: 5548
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...
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...