Hi Everyone,
We are reading records from an Oracle DataMart and have come across a situation where TM1 seems to be interpreting a control character differently in the metadata and data tabs. An asciioutput in the metadata tab shows the field value as "EDL ¿ WKPP" whereas in the Data tab it shows as "EDL ? WKPP". In SQLDeveloper it shows as EDL ¿ WKPP.
Even more interesting is that on some of our TM1 Instances the asciioutput from both tabs is "EDL ¿ WKPP".
All Instances are using TM1 Build 10.2.20100.123.
Anyone seen this before or have any ideas as to why it might be?
thanks,
Gregory
Metadata & Data Tabs process records differently?
-
- MVP
- Posts: 3120
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Metadata & Data Tabs process records differently?
Hello,
I have seen situations before that sound similar.
I would advise to have a look at settings in the TM1s.cfg file:
http://www-01.ibm.com/support/knowledge ... ded_1.html
Parameter type: optional, dynamic
UseSQLFetch=T
UseSQLFetchScroll=T
UseSQLExtendedFetch=T
I have seen situations before that sound similar.
I would advise to have a look at settings in the TM1s.cfg file:
http://www-01.ibm.com/support/knowledge ... ded_1.html
Parameter type: optional, dynamic
UseSQLFetch=T
UseSQLFetchScroll=T
UseSQLExtendedFetch=T
Best regards,
Wim Gielis
IBM Champion 2024
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
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
-
- MVP
- Posts: 264
- Joined: Mon Nov 03, 2014 8:23 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2 PA2
- Excel Version: 2016
Re: Metadata & Data Tabs process records differently?
Do you have the "use unicode" checkbox enabled for this datasource?
-
- Posts: 51
- Joined: Thu Aug 06, 2009 11:09 pm
- OLAP Product: TM1
- Version: 10.2.20100.123
- Excel Version: 365
- Location: Sydney
Re: Metadata & Data Tabs process records differently?
Thanks Wim & Brian for your pointers.
Turning off the "Use Unicode" option caused the field to appear as "EDL ? WKPP" in both Metadata and Data tabs.
So that at least gives a consistent result between the 2 tabs.
Here are the results;
Original Instances - Use Unicode ON or OFF
Metadata Tab - "EDL ¿ WKPP"
Data Tab - "EDL ¿ WKPP"
New Instances - Use Unicode ON
Metadata Tab - "EDL ¿ WKPP"
Data Tab - "EDL ? WKPP"
New Instances - Use Unicode OFF
Metadata Tab - "EDL ? WKPP"
Data Tab - "EDL ? WKPP"
So there are 2 mysteries;
1. Why some instances treat the character differently to others and
2. Why the Unicode setting causes the field to appear differently in the 2 tabs (but only on the new instances).
Go figure...
Turning off the "Use Unicode" option caused the field to appear as "EDL ? WKPP" in both Metadata and Data tabs.
So that at least gives a consistent result between the 2 tabs.
Here are the results;
Original Instances - Use Unicode ON or OFF
Metadata Tab - "EDL ¿ WKPP"
Data Tab - "EDL ¿ WKPP"
New Instances - Use Unicode ON
Metadata Tab - "EDL ¿ WKPP"
Data Tab - "EDL ? WKPP"
New Instances - Use Unicode OFF
Metadata Tab - "EDL ? WKPP"
Data Tab - "EDL ? WKPP"
So there are 2 mysteries;
1. Why some instances treat the character differently to others and
2. Why the Unicode setting causes the field to appear differently in the 2 tabs (but only on the new instances).
Go figure...