Using 2 datasources in TI process

Post Reply
telula
Posts: 99
Joined: Tue Nov 18, 2008 5:40 am

Using 2 datasources in TI process

Post 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.
bskalli
Posts: 21
Joined: Wed May 14, 2008 7:53 am

Re: Using 2 datasources in TI process

Post by bskalli »

Hello,
you need only a Viewcreate Cost-Cube if you can use CellgetN from your Rates-Cube.
telula
Posts: 99
Joined: Tue Nov 18, 2008 5:40 am

Re: Using 2 datasources in TI process

Post 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.
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: Using 2 datasources in TI process

Post 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.
Post Reply