ODBO connection for TM1 and variable in CellPuts
Posted: Mon Apr 11, 2011 6:49 pm
When I create ODBO connection in TI I found a problem:
During creation was generated script in Data
IF (VALUE_IS_STRING=1, CELLPUTS(SVALUE,'Products',Products,Types_of_products), CELLPUTN(NVALUE, '003_Products', Products,Types_of_products));
The problem is that variables Products and Types_of_Products are generated as:
[Products].[Product1] and
[Types_of_products].[Product_schemas]
but CELLPUTS(SVALUE,'Products',Products,Types_of_products) generate error apparenty TI doesn't like such view as [Products].[Product1]
I changed string [Products].[Product1] using string functions to Product1 and it works in CellPuts.
But is it possible to do something that TM1 generates Product1 at first automatically?
During creation was generated script in Data
IF (VALUE_IS_STRING=1, CELLPUTS(SVALUE,'Products',Products,Types_of_products), CELLPUTN(NVALUE, '003_Products', Products,Types_of_products));
The problem is that variables Products and Types_of_Products are generated as:
[Products].[Product1] and
[Types_of_products].[Product_schemas]
but CELLPUTS(SVALUE,'Products',Products,Types_of_products) generate error apparenty TI doesn't like such view as [Products].[Product1]
I changed string [Products].[Product1] using string functions to Product1 and it works in CellPuts.
But is it possible to do something that TM1 generates Product1 at first automatically?
