Ascii Output - Getting Repetative Data

Post Reply
dharav
Regular Participant
Posts: 193
Joined: Wed Apr 02, 2014 6:43 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

Ascii Output - Getting Repetative Data

Post by dharav »

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 ?
Asciioutput TI.txt
(2.22 KiB) Downloaded 413 times
Thanks

Dharav
User avatar
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

Post by qml »

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
Duncan P
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

Post by Duncan P »

Read through this post and everything linked from it. This is a common problem discussed in this forum frequently.
dharav
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

Post by dharav »

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):
AsciiOutput TI Solutions.txt
(5.63 KiB) Downloaded 408 times
Wim Gielis
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

Post by Wim Gielis »

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
Post Reply