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?
2 data sources in 1 TI Process
-
pooja_11284
- Posts: 14
- Joined: Wed Jul 01, 2015 1:10 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
-
Wim Gielis
- MVP
- Posts: 3230
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: 2 data sources in 1 TI Process
You will need 2 processes.
Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
Alan Kirk
- Site Admin
- Posts: 6647
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: 2 data sources in 1 TI Process
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.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?
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
pooja_11284
- Posts: 14
- Joined: Wed Jul 01, 2015 1:10 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: 2 data sources in 1 TI Process
Yes You are right Alan. Thanks I got it.