TM1 Forum

Hi all,

In TM1 Perspective user can input data on each cell and the DBRW function will send the value back to TM1 server. We would like to know if it is possible to copy data of a large area, for example, A1:D10 in one sheet and paste the data to another sheet with DBRW formula on the cells. However, when we pasted data, the DBRW formula is replaced by the values. Does anyone know how to avoid this problem? Or is this a product limitation?

Thanks in advance for your help!

David Lee wrote: In TM1 Perspective user can input data on each cell and the DBRW function will send the value back to TM1 server. We would like to know if it is possible to copy data of a large area, for example, A1:D10 in one sheet and paste the data to another sheet with DBRW formula on the cells. However, when we pasted data, the DBRW formula is replaced by the values. Does anyone know how to avoid this problem? Or is this a product limitation?

It's a product limitation which some of us got sick of waiting for Iboglix to address.

You'll therefore find it in TM1 Tools, which can be downloaded from here.

There are some other workarounds:
1) use DBS to send the data back to the TM1 server
2) copy value into CubeViewer
3) publish your Excel to TM1web where the user can copy paste more than one cell into TM1 (as far as I remember)