Page 1 of 1
Using 2 datasources in TI process
Posted: Tue Nov 16, 2010 7:03 am
by telula
Hello,
Is there an easier way to create a 2nd datasource within the same TI with using a cubename and an existing view and not use ViewCreate?
I need to get the costs stored in 1 cube and multiple with the rates from the 2nd cube and store the results in the 1st cube.Thanks in advance.
Re: Using 2 datasources in TI process
Posted: Tue Nov 16, 2010 8:15 am
by bskalli
Hello,
you need only a Viewcreate Cost-Cube if you can use CellgetN from your Rates-Cube.
Re: Using 2 datasources in TI process
Posted: Tue Nov 16, 2010 8:42 am
by telula
I do not want to use view create because it will create an empty view and i would have to have lines of codes to add the dimensions.I am trying to avoid building a view from scratch when I already have and want to use a pre-created view.
Re: Using 2 datasources in TI process
Posted: Tue Nov 16, 2010 2:11 pm
by David Usherwood
If you need to do this via TI, just set a view of cube1 as your datasource, pick up the percentages using cellgetn('cube2'....), and update cube1 using cellputn('cube1',....) .
I think you are working in a relational mindset. TM1 is not a relational database, You don't need to have a view to get data from other cubes.
I also think that what you are trying do do would probably work much better using rules.