Get data into the cube in Excel

[ylr]

Hi,
Is it possible to get data from regular Excel table into TM1 cube in Excel worksheet? When I create formula then it disappears after calculating.

ylr

[David Usherwood]

DBSW is your friend. You can either create a block of formulae to link to your data area, or include DBSW calls in a macro. The latter is neater but slower, as DBSW in a worksheet is optimised for volume.

[Wim Gielis]

DBSW is your friend. You can either create a block of formulae to link to your data area, or include DBSW calls in a macro. The latter is neater but slower, as DBSW in a worksheet is optimised for volume.

Hello David

But VBA-code should be written to put all DBSW cells in one go (as with all formulas), and then refresh. Not one by one/loops, since loops are relatively slow in Excel VBA.

In that case, it does not matter which of the 2 methods you use.

Wim