TM1 Forum

Ashleigh W

This is helpful. thank you for your help.

Ashleigh W

Hi, I have set up data source in pro-log which is working as expected, now when it comes to data tab I want to be able to go through this data twice, this is because I want to process this condition for all true first and all false item in second time. I know we can create another ti process to proc...

Ashleigh W

it seems to export in comma Delimiter in csv but betweeb every field there is |. Say again please ? What is it, a comma or a pipe symbol ? there is a pipe '|' between each field. so in csv when opened in excel it looks like this all these words in different cells -- >> blank | Ashleigh | Final | 20...

Ashleigh W

lotsaram, your example works for me. I also tried to place DatasourceASCIIQuoteCharacter=','; at the bottom of Prolog and it seems to export in comma Delimiter in csv but betweeb every field there is |.

thanks for your help. this should keep me going.

Ashleigh W

That's correct Wim. Is there a way to change the delimiter for export?

Ashleigh W

Hi everyone, I am trying to use below code to export some data into csv file. When working with the TM1 cube things are fine but when working with external .txt file it is not working ok. It show results as for example like this Ashleigh|Final|201709 but i want it in different column in csv and not ...

Ashleigh W

Works perfect. Thank you gtonkin

Ashleigh W

thank you for quick answer. I'll try and get back.

Ashleigh W

Hi everyone,

As soon as excel File Loads Active Form starts refreshing all the sheets with ActiveForm which takes time.
is there a way to prevent it from refreshing on load? I have already set the calculation mode to manual still it calculates on load.
thank you.

Ashleigh W

Ok thanks Alan. Will give it a try and come back if I need more help. Thanks again.

Ashleigh W

Hi everyone!

How to get the record count to be processed in TM1 Data tab?
I want to run additional steps once all the records are processed in data tab so the data are updated in cube prior processing this extra step.

thank you.

Ashleigh W

thanks Guys for helping out. this is huge help.

Ashleigh

Ashleigh W

Hi all, I'm trying to find which CostCenter and Location dimension combination hold maximum Expense. Sample data and my expected result provide below. Please advice best way to complete this task. thanks in advance. costCenter locNo Expense 49999 LOC1 13048 49999 LOC2 77904 <<- 49999 LOC3 2466 49998...

Ashleigh W

Hi Edward, not sure but I do have admin access I am a developer. Is there a way to check this? I log on to the environment using my windows credentials.

Ashleigh W

Hi TM1 Experts, Need help again it's been a while. I 'm trying to use ExecuteCommand function to run movefile.vbs file to move some files in server dir to windows drive. It runs without error but I do not see the output in windows directory. I have manually executed this movefile.vbs file and it wor...

Ashleigh W

Hi everyone, How to trim out extra space from text. Below code 'm expecting to return X4 but it returns "X 4.000" and error log show variable not found.
Please help.

Code: Select all

X4 = '15';
Tnum = ROUND(Tnum);
S0 = EXPAND('%X' | EXPAND('%Tnum%') | '%');

Ashleigh W

thank you Pandinus. That saved me sometime.

Ashleigh W

Hi everyone, please help with Expand Function. I'm trying to build dynamic/indirect varible and assign a value to it. Got some example from tm1forum.com itself but wont work for me. It says syntax error simicolon missing.. please advice. thanks! ixDim=1; While ( ixDim<=100); Expand ('%sElName' | num...

Ashleigh W

Thanks guys!

Ashleigh W

Hi, how to exit LOOP if certain condition is met in TM1 TI? Is below the correct way?

Code: Select all

nNum = 1;
While( nNum <= 7 );
sNum = NumberToString( nNum );
IF( EXPAND( '%v' | EXPAND( '%sNum%' ) | '%' ) @= 'Test' );
 END;
ENDIF;

nNum = nNum + 1;
END;

TM1 Forum

Search found 88 matches

Re: How to re-use the data from source twice?

How to re-use the data from source twice?

Re: ASCIIOUTPUT to csv to show data in different columns

Re: ASCIIOUTPUT to csv to show data in different columns

Re: ASCIIOUTPUT to csv to show data in different columns

ASCIIOUTPUT to csv to show data in different columns

Re: How to prevent Active Form File Load Refresh

Re: How to prevent Active Form File Load Refresh

How to prevent Active Form File Load Refresh

Re: How to get the record count to be processed ni TM1 Data tab

How to get the record count to be processed ni TM1 Data tab

Re: How to Identity the maximum balance for combination from two combination. TM1 TI Process.

How to Identity the maximum balance for combination from two combination. TM1 TI Process.

Re: Need help with ExecuteCommand. Not working for me

Need help with ExecuteCommand. Not working for me

TM1 TI How to trim out extra space from text

Re: Please help with Expand Function

Please help with Expand Function

Re: How to exit LOOP in TM1 TI?

How to exit LOOP in TM1 TI?