TM1 Forum

nhavis wrote:A few questions:
--------------------

Within a TI process - how can you find out the names of all cubes?
- Possible solution to look in the Data folder for all files named *.cub ?

Within a TI process - how can you find out the names of all dimensions?
Within a TI process - how can you find out which dimensions a cube is using?
Within a TI process - how can you find out which cubes use a particular dimension?

nhavis wrote:Thanks - how can I get the number of dimensions in a cube?

SC_CUBE = 'YourCubeName';

l_Counter = 1;

While ( l_Counter <=256 );

    s_DimName = TabDim ( SC_CUBE, l_Counter); 

    If ( s_DimName @= '');

        l_NumberOfDims = l_Counter - 1;

        l_Counter = 257;

    Else;

        l_Counter = l_Counter + 1;

    EndIf;

End; 

nhavis wrote:Thanks for the quick and concise replies -

How can I add in a a newline character to a string?

Eg.

string = 'Hello';
string = string|'\n';
string = string|'more';

ASCIIOUTPUT('output.txt', string);

How can I add in other special characters?

nhavis wrote:Thanks -

In regards to inserting new line characters: I tried the following and in notepad it seems not to work:

string = '123';

string = string | Char(10);
string = string | Char(13);

string = string | '456';

ASCIIOUTPUT('output.txt', string);
ExecuteCommand('notepad output.txt', 0);

output.txt contained (when viewed in notepad):
"123456"

however the newline characters were present when viewed in vim/wordpad etc.

string = string | Char(13);
string = string | Char(10);

string = string | Char(10);
string = string | Char(13);