HI,
I have developed a hierarchy in excel sheet to create a new cube through TI, after saving the excel it has saved in .xls form but i have excel 2007 in my configuration, the issue is when i want to extract it into TI the file did not open. In fact i can not able see the file in TI.
My doubt is in excel 2007 it show be in .xlsx format where as it is in .xls form.So, i was unable to extract it.
I have closed file(excel sheet), while in process.
Example.
I have done an Cashflow statement format in excel 2007 and saved it.When i went to process, i was unable see it when opted for Text in TI.
Please can help me in this.
thanks and regards.
.xls form in Excel 2007
- Alan Kirk
- Site Admin
- Posts: 6606
- 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: .xls form in Excel 2007
If you're using a data source of text it shouldn't be either an .xls or an .xlsx; you should be saving it as a comma delimited text file.viswaraju wrote:HI,
I have developed a hierarchy in excel sheet to create a new cube through TI, after saving the excel it has saved in .xls form but i have excel 2007 in my configuration, the issue is when i want to extract it into TI the file did not open. In fact i can not able see the file in TI.
My doubt is in excel 2007 it show be in .xlsx format where as it is in .xls form.So, i was unable to extract it.
I have closed file(excel sheet), while in process.
Example.
I have done an Cashflow statement format in excel 2007 and saved it.When i went to process, i was unable see it when opted for Text in TI.
Please can help me in this.
thanks and regards.
"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.
-
- Regular Participant
- Posts: 177
- Joined: Thu Nov 05, 2009 8:45 am
- OLAP Product: IBM COGNOS TM1
- Version: 9.5
- Excel Version: 2007
Re: .xls form in Excel 2007
woo,
thank you, thank you very much Allan, lost he basics at the moment.
thank you, thank you very much Allan, lost he basics at the moment.