TM1 Forum

Hello,

1 - check that the file exists in the <applix installation dir>/bin
2 - add this directory in the PATH environment variable

Regards,

Renaud.

Eyal, the API documentation indicates that it is not possible :( NOTE: If your server is set up to accept only integrated login (IntegratedSecurityMode=3), you cannot log in to the TM1 server using the API. If your server is set up to use integrated security exclusively, set the IntegratedSecurityMo...

Hello,

Goto this URL: http://www.bihints.com/graphing_tm1_data_flow

Regards,

Renaud.

Hi Steve,

can you tell us the TM1 version involved ?

Regards,

Renaud.

Hello,

you should have some samples located in the '<TM1 installation directory>\API\TM1API\SampleCode\' directory.
In my configuration, I've got code for C++, VB and Java APIs.

Regards,

Renaud.

Hi, the TM1V for which you ask the string value has to be the one that is of type 'TM1ValTypeError'. So, the correct code has to be something like this: if( TM1ValType(hUser, vServerObject) == TM1ValTypeError()){ int nErrCode = TM1ValErrorCode(hUser, vServerObject); char *szErrMsg = TM1ValErrorStrin...

Hello, to retrieve the data you need, you have to do a 'join' query which should look like this one: select DEALS.DEAL_NO, DEALTYPE, THE_KEY from DEALS, PAIRRPT where DEALS.DEAL_NO = PAIRRPT.DEAL_NO (As this is a basic SQL query, I would suggest you to increase your SQL knowledge through some readin...

Hello, the TM1SystemServerConnect() function doesn't return a handle to an objet (ie. a TM1 object), but a handle to the server. Thus, you don't have to check if it's an object. The only test required is (as you do) to check that it is different of TM1ValTypeError(). If it is different, you can retr...

About your question, I've no answer :) But if you're reluctant exposing the control cube, you can create a specific cube in which users would input values for attribute, and create a rule on the }elementattributes_xxx cube to retrieve those values. I've not tested this by myself, but I think it coul...

Hello, For my application, I've resolved this with a Process using the tm1s.cfg file as Datasource. The delimiter type is 'Delimited', with '=' as separator. Therefore, there are two columns defined: V1 and V2. When in the Data tab the value of V1 is 'ServerName', I store the value of V2 into a vara...

Hello,

do you have the same problem if you create a new cube and then open a subset editor ?

Renaud.

Hello, There's no TI instruction to enable or disable a Chore. However, you can simulate this function by: - adding a Numeric Attribute 'disabled' to the '}chores' dimension - creating a process (with a parameter giving the chore name) that checks if the attribute 'disabled' is = 1 for this chore If...

Hello,

shouldn't the target rule be

SKIPCHECK;
['Quantity']=DB('Product Cust Hier', ATTRS('Customer2', !Customer2, 'CustNo') | ' - ' | ATTRS('Product Categories', !Product Categories, 'Prod_Cat'), 'quantity');

without the 'N:' qualifier, so that consolidated value is also transfered ?

Renaud.

IanB, I presume the source element already exist in the dimension. So, you have to insert the destination element into the dimension (if if doesn't exists ...) Furthermore, you should check that the process doesn't halt because of incorrect parameters of invalid 'context'. For example, you'll have (...

Hello,

it looks like the user accessing this view doesn't have 'read' access upon any elements of a dimension (or subset) used for this view.
Thus, the resulting view is empty.

Check the security of elements used by this view.

(BTW, it is not a 'view out of memory' error)

Regards,

Renaud

I think it could be a good thing to share/centralize a list of bugs found in the 9.4 version. Good idea Robert ;) I think it could also be interesting to 'extend' such a buglist to older releases still operating worldwide. We could then have an idea of what happened to old bugs (and the delay of re...

Hello, we've managed to be notified when our TM1 Server is ready by a shell script (It's on an Unix box ...) that searches the string 'TM1 Server is ready' in the tm1smsg.log file, then displays a message. The code looks like: bReady=0 sFile=/usr/local/tm1/logdir/tm1smsg.log while [ "$bReady&qu...

Hello,

does any of you succeeded in using Mosha Pasumansky's 'MDX Studio' to query a TM1 database ?
It's OK with the ODBO sample application, but I can't find any working connection string for MDX Studio.

click >Here< if you want to have a look.

Regards,

Renaud.

Hello,

I suggest you to re-create the process from scratch.
I've seen this behavior 2 or 3 times, and it happened when I changed the order of columns in the source data (file or cube)

BtW, what version of TM1 are you working on ?

Regards,

Renaud.

Hello, I think you don't have to use 'union'. Just add members between {}, separated by a comma. Try the following TM1SORT( TM1FilterByLevel( { TM1FilterByPattern( {TM1SUBSETALL( [taps outlet] )}, "L0*") , TM1FilterByPattern( {TM1SUBSETALL( [taps outlet] )}, "L1*") , TM1FilterByP...