TM1 Forum

Hi guys....not sure if this has already been posted before. Is there any way to copy and paste a range of cells into a DBRW range of cells? Thanks in advance.

You need to write a little bit of VBA code that

* captures the copy value
* loops through the target range
* retrieves the element co-ordinates on a cell by cell basis using the parameters of the DBRW formula
* does a DBS of the copy value using those co-ordinates
* replaces the DBRW formula
* moves to the next cell

It's fairly trivial. ISTR that something has been posted here before that did this.

Edit - perhaps less trivial range to range than cell to range but still quite doable

Rashed

You can write your own as John suggested. Cubewise do a tool that will do this. The Beachware tool did it a long time ago, but I am not sure if it is still around. Applix bought Beachware a long time ago so I am not sure why this feature never made it in to the product.

Other alternatives are to use the Cube Viewer, TM1 Web or the In-Spreadsheet Browser, neither of which use DBRW. However, the ISB is being dropped after version 9.4.

Regards

Paul

Rashed wrote:Hi guys....not sure if this has already been posted before. Is there any way to copy and paste a range of cells into a DBRW range of cells? Thanks in advance.

As per John's comment, VBA will do it for you. It's also part of one of the packages put out by SPF (http://www.spfplus.com/), which may be worth looking at if you have the need.

Thanks Guys...this forum is awsome!!!!

PaulSimon wrote:You can write your own as John suggested. Cubewise do a tool that will do this. The Beachware tool did it a long time ago, but I am not sure if it is still around. Applix bought Beachware a long time ago

I wouldn't say that in front of Johann Potgieter if I were you... not unless you're wearing gridiron padding.

Beachware is what became SPF.

Yes if memory serves me well didn't someone buy the name but forgot to buy the product or something or was it the other way round.

It's a long time ago but there was a funny story there somewhere...

SPF was/is quite a neat tool. (Neat at that UI level that Applix never ever managed to get right or copy properly.)

You can also consider using DBS(W) for sending the data in. SInce the source is ordinary excel you can copy and paste to your hearts content then.
Cheers,