Page 1 of 1
2 data sources in 1 TI Process
Posted: Thu Mar 09, 2017 4:47 pm
by pooja_11284
Hi,
I need to have 2 data sources in a TI Process. One data source I am having as a cube view, I also need some information from Excel file into this TI Process as well. In the data source I have defined the cube view. How shall I get the csv file read now?
Re: 2 data sources in 1 TI Process
Posted: Thu Mar 09, 2017 5:29 pm
by Wim Gielis
You will need 2 processes.
Re: 2 data sources in 1 TI Process
Posted: Thu Mar 09, 2017 6:35 pm
by Alan Kirk
pooja_11284 wrote:Hi,
I need to have 2 data sources in a TI Process. One data source I am having as a cube view, I also need some information from Excel file into this TI Process as well. In the data source I have defined the cube view. How shall I get the csv file read now?
Just to elaborate on what Wim said, if you need data from the text file
while you are doing the cube view-based process (which you may be implying, though your question isn't completely clear), the workaround would be to load the text file into a temporary cube first. When you run the cube view-based process you could then read whatever you need from the temporary cube via CellGetN / CellGetS functions.
Re: 2 data sources in 1 TI Process
Posted: Fri Mar 10, 2017 6:12 am
by pooja_11284
Yes You are right Alan. Thanks I got it.