Page 1 of 1
Copying data?
Posted: Thu May 21, 2009 6:57 am
by rcoppa
Hi there,
Is there a way to copy data within the cube browser? For example if a user wanted to populate a forecast or budget version with the prior year actuals?
At the moment I do this via TI, but it would be great if the users could do it themselves.
TIA.
Re: Copying data?
Posted: Thu May 21, 2009 8:01 am
by Gregor Koch
Hi,
Yes there is. You can use Spreading ('Relative Proportional Spread') in the cubeviewer. Given you have consolidations for all elements in each dimension (or at least the ones you want to copy) it is one 'spread'.
Cheers
Re: Copying data?
Posted: Thu May 21, 2009 9:25 am
by lotsaram
You can also use copy/paste from the clipboard into cube viewer or TM1 Web.
(To do the same in Excel over a range of DBRW formulas you would need to use a 3rd party tool but it is possible.)
Re: Copying data?
Posted: Tue Jun 02, 2009 11:11 pm
by rcoppa
Gregor Koch wrote:Hi,
Yes there is. You can use Spreading ('Relative Proportional Spread') in the cubeviewer. Given you have consolidations for all elements in each dimension (or at least the ones you want to copy) it is one 'spread'.
Cheers
Perfect thats exactly what I was after, Cheers.
Re: Copying data?
Posted: Wed Jun 03, 2009 12:30 am
by jonathan.d
Yet another way is to slice it out to excel and DBSEND it back where you want.