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.
Using 2 datasources in TI process
Re: Using 2 datasources in TI process
Hello,
you need only a Viewcreate Cost-Cube if you can use CellgetN from your Rates-Cube.
you need only a Viewcreate Cost-Cube if you can use CellgetN from your Rates-Cube.
Re: Using 2 datasources in TI process
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.
-
- Site Admin
- Posts: 1458
- Joined: Wed May 28, 2008 9:09 am
Re: Using 2 datasources in TI process
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.
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.