how to set a DBRW cell to get data from other cells

[wang_chris]

I an writing an excel form for TM1 application.

There is a cell to read data from TM1 server by DBRW function, which means when operator input data here, the data will be transfer to TM1 server.

But the operator doesn't want to handly input data, he wants to copy data from else to the cell, or let the cell directly equals it's source cell (the relation doesn't keep in TM1 server).

How can I make it? Is there a simple way rather than writing rule in TM1 server, or using excel macro?

Regards,
Chris

[declanr]

Why don't you want to do it by a rule? That would be the most efficient and robust method (that and/or consolidation if possible.)

However if you really do just want it "automated" outside of TM1 itself then you can look at the DBS, DBSS and DBSW formulas. If there is a reason for it to not be done by a rule however (e.g. user sometimes inputting something slightly different) I would be tempted to just tell them to copy and paste or create a rule/consolidation but also including an "adjustment" measure for inclusion in the calculation.

[wang_chris]

cheers, DBS/DBSW is a good alternative.

Thanks very much for your advice.

Regards,
Chris