Page 1 of 1
Get data into the cube in Excel
Posted: Wed Jul 07, 2010 1:44 pm
by 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
Re: Get data into the cube in Excel
Posted: Wed Jul 07, 2010 2:50 pm
by 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.
Re: Get data into the cube in Excel
Posted: Wed Jul 07, 2010 8:46 pm
by Wim Gielis
David Usherwood wrote: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