TM1 Forum

@ Failurehappening.

Your code worked perfectly.

Thanks everyone for your time and efforts.

Cheers

There are total 10 files in the import folder, i have to pick all the files and load them using one TI process.

I don't want to create multiple TI's for this job and i am planning to create one TI which will loop through all files and perform data load.

Cheers

Hi Evgeny,

The problem is i have to loop through all the files in the path and then Archive them after the load ( file names will change ).
If i create this as a batch file, then i can't pass the parameters?

Cheers

Hi Alan, Thanks for your prompt response on this. I have taken asciioutput of the SCommand and execute this in the server through command prompt. it works fine. But when i execute the script from the Epilog tab of the process, it's throwing error saying "System can't find the file specified&quo...

Dear members, i am trying to move the import files into archive location after the successful data load in TI process. Below is the script i am using to archive the file, but unable to do that, when i run the same script through command prompt, i can do that. sScript = 'move /y ' ; sImportdir = 'D:\...

Blackhawk,

You Spot on..

Thanks for your time and efforts.

Cheers

But there is a work around, Instead of running a loop, when I try to create each and every dimension and subset manually, it works fine.
I am wondering it's the same code working fine in cognos express but not in TM1 10.2.2.

Cheers

Hi Declanr,

I can't see the MDX expression in subset window.

Hi Declanr, thanks for your suggestion, I have tried that, but I can see the empty subset. I have modified my code as below, but still the same result. cCubeName = 'Sales' ; cViewName = ' View ' | NumberToString( ROUND( RAND() * 100000 ) ) ; cSubName = 'Subset ' | NumberToString( ROUND( RAND() * 100...

Looks like it's looping and creating subsets in the dim's but not loading values in the two subsets using MDX.

Sorry guys my fault, it's typo error. Below is the code. cCubeName = 'Sales' ; cViewName = ' View ' | NumberToString( ROUND( RAND() * 100000 ) ) ; cSubName = 'Subset ' | NumberToString( ROUND( RAND() * 100000 ) ) ; iContinue = 1 ; iDimCount = 1 ; WHILE ( iContinue = 1 ) ; sDimName = TABDIM ( cCubeNa...

I am not getting any error message, Process successfully executed but it's not doing data export. When I check the view it has generated, the two subsets for Dim's ( ABCD , XYZ) I am creating using MDX doesn't have any values in it. whereas I can see other subsets of dim's are populating with values...

when I check in the random view, The subsets for ABCD and XYZ are not created.

Hi Guys, I have created a TI process to export the data from cube to csv file in Cognos express. After we deploy the TI from cognos express to TM1 10.2.2, my code doesn't work. Can you please let me know your thoughts on this. The below mentioned code is not working. cCubeName = 'Sales' ; cViewName ...

May be I need to put my hands on programming as well look like..
Any way thanks for your solutions.

Cheers

Dear Members, We are basically trying to automate the Currency exchange data in TM1. we don't have any source for loading FX values in TM1, thus we need to rely on websites to feed the data into TM1. But every day gathering information from website and manually create the excel files is a pain, so d...

Hi Many thanks, It's working with this syntax.

Hi Michel, Thanks for your help. But when i try to include the strings, i am getting syntax error, it's not allowing me to put the quotes to numeric values. the below code is throwing me the syntax errors at V4 position. sql = 'INSERT INTO TM1_cube_Test (products, months, measures, Values) values ('...

Hi Thanks a lot for your suggestion. I have gone through the guide lines. I am writing this code in Data tab of the TI for loading cube data into Database table. sql = 'INSERT INTO TM1_cube_Test (products, months, measures) values ('''|V1|''', '''|V2|''', '''|V3|''', |V4|)'; ODBCoutput ('TestODBC', ...

I have tried this as well;

sql = 'INSERT INTO TM1_cube_Test (products, months, measures, Values) values ('''|V1|''', '''|V2|''', '''|V3|''',|V4|)';

ODBCoutput ('TestODBC', sql);

but no luck, it's the same error.

Cheers