ODBO connection for TM1 and variable in CellPuts

[EP_explorer]

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?

[David Usherwood]

As I said in response to an earlier post ODBO support in TM1 is not good. I found that issue in May 2005 and reported it then. Somehow it's not been addressed - amazing