TM1 Forum

I need to load approx. 1200 parameter values. Is there anyway to do this systematically versus manual? Thanks, Rick.

I believe you want to do this within TI. Thats a really odd scenario. Can you please tell us why you need more than 1200 parameters?

We had a macro built to run in Excel version but due to licensing constraints need to move application to web, where the macro doesn't work. At times, for this particular application, the user may select to pull data for selected stores, upto to 1200, vs. all stores. When they do this, they cut-n-paste list into a column. We have named each cell, i.e. pStore1, pStore2, etc. and need to define the parameters section of the TI process. Hope that helps. Thanks, Rick.

rfielden wrote:We had a macro built to run in Excel version but due to licensing constraints need to move application to web,

I am not sure I understand the problem, is this a case of automating the selection of stores withing TM1 web?

Also, If this is the case I do not see how moving to TM1 web from the TM1 Excel client helps from a licensing point of view. If you are using concurrent ports, both types of access use a port, if you are on named users, all users require a license whether they access TM1 via Excel, TM1 web or any other way.

Just under 'orders' to move from Excel to Web.

Partial of what I am trying to, and still a novice in this area, is:

IF( DIMIX('LSM_Stores',pStore1) = 0 ) ;
pStore1 = 'NULL';
ENDIF ;

IF( DIMIX('LSM_Stores',pStore2) = 0 ) ;
pStore2 = 'NULL';
ENDIF ;

IF( DIMIX('LSM_Stores',pStore3) = 0 ) ;
pStore3 = 'NULL';
ENDIF ;

IF( DIMIX('LSM_Stores',pStore4) = 0 ) ;
pStore4 = 'NULL';
ENDIF ;

IF( DIMIX('LSM_Stores',pStore5) = 0 ) ;
pStore5 = 'NULL';
ENDIF ;

vSingle = '''';

vSql = 'INSERT INTO AK_RFIEL.LSM_STORES (STORE)VALUES (' | pStore1 | ' );';
ODBCOpen('APPSTST','xxxxxx','xxxx');
ODBCOutput('APPSTST', 'DELETE FROM AK_RFIEL.LSM_STORES;');
ODBCOutput('APPSTST',vSql);
ODBCClose('APPSTST');

vSql = 'INSERT INTO AK_RFIEL.LSM_STORES (STORE)VALUES (' | pStore2 | ' );';
ODBCOpen('APPSTST','xxxxxx','xxxx');
ODBCOutput('APPSTST',vSql);
ODBCClose('APPSTST');

vSql = 'INSERT INTO AK_RFIEL.LSM_STORES (STORE)VALUES (' | pStore3 | ' );';
ODBCOpen('APPSTST','xxxxxx','xxxx');
ODBCOutput('APPSTST',vSql);
ODBCClose('APPSTST');

vSql = 'INSERT INTO AK_RFIEL.LSM_STORES (STORE)VALUES (' | pStore4 | ' );';
ODBCOpen('APPSTST','xxxxxx','xxxx');
ODBCOutput('APPSTST',vSql);
ODBCClose('APPSTST');

vSql = 'INSERT INTO AK_RFIEL.LSM_STORES (STORE)VALUES (' | pStore5 | ' );';
ODBCOpen('APPSTST','xxxxxx','xxxx');
ODBCOutput('APPSTST',vSql);
ODBCClose('APPSTST');