Hello All
I have attached text file expressing my TI process, out put which i am getting it, and output should be. I am missing something. Can anyone help me out ?
Thanks
Dharav
Ascii Output - Getting Repetative Data
- qml
- MVP
- Posts: 1098
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Ascii Output - Getting Repetative Data
If you want to use CellGetS to get the data you should put that code in Prolog or Epilog. Another option is to do AsciiOutput on the Data tab, using cube view as your data source. Right now you're mixing the two approaches and that's why you are getting duplicates. You need to remember that the Data tab is executed as many times as there are rows in the data source.
Kamil Arendt
-
- MVP
- Posts: 600
- Joined: Wed Aug 17, 2011 1:19 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2
- Excel Version: 2003 2007
- Location: York, UK
Re: Ascii Output - Getting Repetative Data
Read through this post and everything linked from it. This is a common problem discussed in this forum frequently.
-
- Regular Participant
- Posts: 193
- Joined: Wed Apr 02, 2014 6:43 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2010
Re: Ascii Output - Getting Repetative Data
Thank You so much for you guidance @qml and @duncan p.
@qml: I write a TI process without cube view as a source. I have attached file with my solutions for someone's reference.
I still like to build the same through cube view in near future.
@duncan p: Thanks for sharing it. It helped me to debug my process.
Solution (With out cube view as source):
@qml: I write a TI process without cube view as a source. I have attached file with my solutions for someone's reference.
I still like to build the same through cube view in near future.
@duncan p: Thanks for sharing it. It helped me to debug my process.
Solution (With out cube view as source):
-
- MVP
- Posts: 3240
- 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: Ascii Output - Getting Repetative Data
Thank you for sharing the solution.
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