Missing title elements in a view, TM1 9.5 and up
-
- 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:
Missing title elements in a view, TM1 9.5 and up
Hello,
It seems that in TM1 9.5 and TM1 9.5.1, a number of views are incorrect as they do not show the title elements. They all work well in TM1 9.4 and below.
Unfortunately, it is not the case on all cubes, nor on all views of the same cube. Nothing special happens in the dimensions, just normal dimensions with simple structures. No security whatsoever. I am logged in as Admin.
Anyone seen this before? Thanks.
Tested environment: 4 GB RAM laptop, Win 7, TM1 9.5, TM1 9.5.1
Wim
It seems that in TM1 9.5 and TM1 9.5.1, a number of views are incorrect as they do not show the title elements. They all work well in TM1 9.4 and below.
Unfortunately, it is not the case on all cubes, nor on all views of the same cube. Nothing special happens in the dimensions, just normal dimensions with simple structures. No security whatsoever. I am logged in as Admin.
Anyone seen this before? Thanks.
Tested environment: 4 GB RAM laptop, Win 7, TM1 9.5, TM1 9.5.1
Wim
- Attachments
-
- Ontbrekende titel elementen.doc
- (47 KiB) Downloaded 2412 times
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
-
- Posts: 70
- Joined: Thu May 22, 2008 3:38 pm
Re: Missing title elements in a view, TM1 9.5 and up
Wim,
I have noticed that before with a client running Windows 7. The client installed the client on another machine and it worked(non windows 7). I had thought afterwards they could have deleted the tm1p.ini file and this could have cured the problem.
Herman
I have noticed that before with a client running Windows 7. The client installed the client on another machine and it worked(non windows 7). I had thought afterwards they could have deleted the tm1p.ini file and this could have cured the problem.
Herman
-
- 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: Missing title elements in a view, TM1 9.5 and up
Thank you Herman, I will play around.
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
Re: Missing title elements in a view, TM1 9.5 and up
Hi
I have also come across this issue and as suggested on this thread, have deleted and reinstated the tm1p.ini file but to no avail. Does anyone have any other idea of how to solve this issue?
Interestingly, earlier this year I was using TM1 9.5 on a different Windows 7 machine and had no issue at all. Now I am using TM19.5.1 on a new HP notebook and I have the issue.
cheers
Quail
I have also come across this issue and as suggested on this thread, have deleted and reinstated the tm1p.ini file but to no avail. Does anyone have any other idea of how to solve this issue?
Interestingly, earlier this year I was using TM1 9.5 on a different Windows 7 machine and had no issue at all. Now I am using TM19.5.1 on a new HP notebook and I have the issue.
cheers
Quail
-
- Posts: 47
- Joined: Tue Mar 09, 2010 6:40 pm
- OLAP Product: TM1
- Version: 9.5
- Excel Version: 2003
Re: Missing title elements in a view, TM1 9.5 and up
Does this happen for every view or just some?
Have you checked your available memory when this occurs?
If you reboot the machine does it go away?
Have you checked your available memory when this occurs?
If you reboot the machine does it go away?
Re: Missing title elements in a view, TM1 9.5 and up
Hi Ianen
Its not a memory issue - I am working in a dev environment - very little data, no rules and only one cube! It happens with all views and rebooting has no effect at all!
Would it be anything to do with the fact that we are working with Windows 7 in a 64 bit environment?
cheers
Quail
Its not a memory issue - I am working in a dev environment - very little data, no rules and only one cube! It happens with all views and rebooting has no effect at all!
Would it be anything to do with the fact that we are working with Windows 7 in a 64 bit environment?
cheers
Quail
-
- 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: Missing title elements in a view, TM1 9.5 and up
Me too, I'm on TM1 9.5 and 9.5.1.
No memory issue as far as I know.
I have WIN 7 in a 64 bits environment.
Strange thing is, it is not with all views and / or all cubes. Also, if you shift some of the title dimensions (that has missing elements) to the columns for instance, there the elements show up. Moving back to the title elements, it's stuck again.
But keeping the dimension in the columns, it could be that the other title dimensions are okay again!!!
I don't understand this at all.
Thanks,
Wim
No memory issue as far as I know.
I have WIN 7 in a 64 bits environment.
Strange thing is, it is not with all views and / or all cubes. Also, if you shift some of the title dimensions (that has missing elements) to the columns for instance, there the elements show up. Moving back to the title elements, it's stuck again.
But keeping the dimension in the columns, it could be that the other title dimensions are okay again!!!
I don't understand this at all.
Thanks,
Wim
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
-
- Posts: 47
- Joined: Tue Mar 09, 2010 6:40 pm
- OLAP Product: TM1
- Version: 9.5
- Excel Version: 2003
Re: Missing title elements in a view, TM1 9.5 and up
I have seen it in 9.4.1 FP3 so far it has only been customers with x64 bit installations. I am not aware of anyone that has had this problem with x86.
Have either of you run Dependency Walker to see if there is a dll issue?
Have either of you run Dependency Walker to see if there is a dll issue?
-
- Posts: 47
- Joined: Tue Mar 09, 2010 6:40 pm
- OLAP Product: TM1
- Version: 9.5
- Excel Version: 2003
Re: Missing title elements in a view, TM1 9.5 and up
This issue seems to be caused by .exd files in the user profiles. I have been able to resolve it after removing these files
Re: Missing title elements in a view, TM1 9.5 and up
What are the *.exd files and where can I find them?
Same problem on Windows 2003 server when using TM1 architect or TM1 perspectives
Same problem on Windows 2003 server when using TM1 architect or TM1 perspectives
Gabi Cohen
Biconix International
Biconix International
- Olivier
- Community Contributor
- Posts: 159
- Joined: Thu Jun 26, 2008 5:46 am
- OLAP Product: TM1
- Version: Tm1 10.2.2fp4 -> 2.09
- Excel Version: Excel 2013 - 2019
- Location: Sydney
Re: Missing title elements in a view, TM1 9.5 and up
Hi All,
I posted a similar bug in the main forum as i forgot about this specific bug section.
I guess i will start the quest of the ".exd" files and post the outcome.
I posted a similar bug in the main forum as i forgot about this specific bug section.
I guess i will start the quest of the ".exd" files and post the outcome.
Few monthes ago, i tryed a base 9.4 version install and migrated our production model hosted in 9.1sp3 ( just a copy ).
The installation was done without any issue.
The server started just fine and so far everything looked good.
When started exploring the cubes/views in this new 9.4 environment , i quickly noticed 2 major issues :
1 - some of the title selections were changed compaired to the original view settings
(i. a high level ebit monitor view suddently display total cost as account selection while the view was saved with EBIT selected)
2 - In certain views ( not all of them and not for the same dimensions), some title dimensions were not showing the active selection giving the impression that nothing is selected.
Note : if the view is sliced, then the title field would be showing correctly in the excel spreadsheet.
I have attached a screenshot of what the view looks like with 3 of the title fields impacted. (the last 3 title fields.)
I believed at the time that it was one of the reason that MR1 was made
and stopped the testing phase to plan another one using MR1 and the 3 Fix Packs.
We have started to test 9.4mr1 including FP1, 2 and 3 and unfortunatly it reproduces these inconsistent views bugs.
This is definetly a no go for using this in production.
My assumption is that it can be a side effect of a "conversion" from a Datafolder from 9.1sp3 to 9.4mr1...
Which would mean upgrading mean recreating all the cubes and the rest from scratch in the new environment ? (the risquiest upgrade ever).
Did anybody encounter a similar type of bug when upgrading an old TM1 database from 9.1sp3 or older to 9.4, 9.4mr1 or 9.5version ?
Our server OS is Window server 2003 and Perspective is run through Excel 2003.
Thanks for your inputs,
Kind Regards,
Olivier
- Attachments
-
- View Bug - 9.4mr1 SP3.jpg (69.37 KiB) Viewed 145564 times
HTH
Olivier
Olivier
- Olivier
- Community Contributor
- Posts: 159
- Joined: Thu Jun 26, 2008 5:46 am
- OLAP Product: TM1
- Version: Tm1 10.2.2fp4 -> 2.09
- Excel Version: Excel 2013 - 2019
- Location: Sydney
Re: Missing title elements in a view, TM1 9.5 and up
Ho ho ho,
I cannot locate the .exd files that are mentioned in earlier posts...
Does anyone have an idea where to find these ?
Otherwise it sounds like it s time to send a letter to IBM support Santa![Smile :)](./images/smilies/icon_e_smile.gif)
Kind Regards,
Olivier
I cannot locate the .exd files that are mentioned in earlier posts...
Does anyone have an idea where to find these ?
Otherwise it sounds like it s time to send a letter to IBM support Santa
![Smile :)](./images/smilies/icon_e_smile.gif)
Kind Regards,
Olivier
HTH
Olivier
Olivier
- Olivier
- Community Contributor
- Posts: 159
- Joined: Thu Jun 26, 2008 5:46 am
- OLAP Product: TM1
- Version: Tm1 10.2.2fp4 -> 2.09
- Excel Version: Excel 2013 - 2019
- Location: Sydney
Re: Missing title elements in a view, TM1 9.5 and up
ho ho ho,
I have send a support request to IBM and it is already actionned.
I will post the resolution if any as soon as it comes back to me.
Kind Regards,
Olivier
I have send a support request to IBM and it is already actionned.
I will post the resolution if any as soon as it comes back to me.
Kind Regards,
Olivier
HTH
Olivier
Olivier
- Olivier
- Community Contributor
- Posts: 159
- Joined: Thu Jun 26, 2008 5:46 am
- OLAP Product: TM1
- Version: Tm1 10.2.2fp4 -> 2.09
- Excel Version: Excel 2013 - 2019
- Location: Sydney
Re: Missing title elements in a view, TM1 9.5 and up
Quick update,
I noticed that the bug does not reproduce when exploring the cubes/views from a perspective client installed on another machine then the tm1 server itself.
So the bug might not be a show stopper as we barely use the server explorer from the server box itself.
I had some feedback that the issue itself might be related to non tm1 component installed of the server such as anti virus as it was observed and resolve by IT department of another company by installing server component one by one untill isolating the bug source item.
I am a bit challenge to test that as my tm1 test server is also production server for other applications.
If anybody as a clue of which server software is likely to produce the issue please let me know.
The support process from IBM consists in attempting to apply hot fixes 4, 7 and 12.
HF 4 and 7 do not solve the issue.
HF 12 prevents my server from starting so we will stay with HF7 for now.
IBM is not able to reproduce the bug from their end.
I will now focus my testing on the client PC with perspective to check if this bug or any other impact us.
Kind Regards,
Olivier
I noticed that the bug does not reproduce when exploring the cubes/views from a perspective client installed on another machine then the tm1 server itself.
So the bug might not be a show stopper as we barely use the server explorer from the server box itself.
I had some feedback that the issue itself might be related to non tm1 component installed of the server such as anti virus as it was observed and resolve by IT department of another company by installing server component one by one untill isolating the bug source item.
I am a bit challenge to test that as my tm1 test server is also production server for other applications.
If anybody as a clue of which server software is likely to produce the issue please let me know.
![Question :?:](./images/smilies/icon_question.gif)
The support process from IBM consists in attempting to apply hot fixes 4, 7 and 12.
HF 4 and 7 do not solve the issue.
HF 12 prevents my server from starting so we will stay with HF7 for now.
IBM is not able to reproduce the bug from their end.
I will now focus my testing on the client PC with perspective to check if this bug or any other impact us.
Kind Regards,
Olivier
HTH
Olivier
Olivier
-
- 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: Missing title elements in a view, TM1 9.5 and up
Hi
I just tried TM1 9.5.2 on Windows 7, 64 bits, to no avail. Oftentimes, subsets in the title dimensions of the Cube viewer appear empty and hence very narrow.
Wim
I just tried TM1 9.5.2 on Windows 7, 64 bits, to no avail. Oftentimes, subsets in the title dimensions of the Cube viewer appear empty and hence very narrow.
Wim
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
Re: Missing title elements in a view, TM1 9.5 and up
Some new updates on this one as it is effecting a lot of users running win7 x64. At first I thought it had to do with laptops only and specifically Dell ones as the IBM thinkpads in house did not display this problem. However in one of the earlier threads this was reported on an HP so there goes that theory.
While working with Partner Revelwood yesterday we had them run a series of test where they had a Tm1 (x64 bit) server running on their Dell laptop which was running Win7 x64.
1. Connected to my server from another box (W7 x64) – No cube viewer issues
2. Connected to my server from another box (W7 x86) – No cube viewer issues
3. Connected to my server from another box (XP) – No cube viewer issues
4. Ran server on another box (W7 x64) – Connected to that server from my laptop – Same cube viewer header issues
5. Ran server on another box (W7 x86) – Connected to that server from my laptop – Same cube viewer header issues
6. Ran server on another box (XP) – Connected to that server from my laptop – Same cube viewer header issues
Now what Revelwood found was if they run in safe mode and re-ran steps 4, 5 and 6 as well as running both client and server on their same laptop - the problem went away.
After further investigation there seems to be some "bloatware" installed on the laptops called DigitalPersona Pro.
From Revelwood:
"This is some type of fingerprint software that came pre-installed in all of our Dells.
To troubleshoot, in case anyone else has the issue caused by other conflicting software, I booted in Safe Mode, then noticed problem went away.
Then I went to msconfig, turned off all startups, and narrowed it down to the conflicting software
"
Hope this information helps and big thanks to Revelwood for debugging this one.
While working with Partner Revelwood yesterday we had them run a series of test where they had a Tm1 (x64 bit) server running on their Dell laptop which was running Win7 x64.
1. Connected to my server from another box (W7 x64) – No cube viewer issues
2. Connected to my server from another box (W7 x86) – No cube viewer issues
3. Connected to my server from another box (XP) – No cube viewer issues
4. Ran server on another box (W7 x64) – Connected to that server from my laptop – Same cube viewer header issues
5. Ran server on another box (W7 x86) – Connected to that server from my laptop – Same cube viewer header issues
6. Ran server on another box (XP) – Connected to that server from my laptop – Same cube viewer header issues
Now what Revelwood found was if they run in safe mode and re-ran steps 4, 5 and 6 as well as running both client and server on their same laptop - the problem went away.
After further investigation there seems to be some "bloatware" installed on the laptops called DigitalPersona Pro.
From Revelwood:
"This is some type of fingerprint software that came pre-installed in all of our Dells.
To troubleshoot, in case anyone else has the issue caused by other conflicting software, I booted in Safe Mode, then noticed problem went away.
Then I went to msconfig, turned off all startups, and narrowed it down to the conflicting software
"
Hope this information helps and big thanks to Revelwood for debugging this one.
-
- 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: Missing title elements in a view, TM1 9.5 and up
Hi there
I followed the useful information above, and pinpointed the problem with a startup item called "nwiz" (nwiz.exe).
I disabled it in msconfig and now the title elements show up nicely.
Thanks for the guidance, much appreciated.
Wim
I followed the useful information above, and pinpointed the problem with a startup item called "nwiz" (nwiz.exe).
I disabled it in msconfig and now the title elements show up nicely.
Thanks for the guidance, much appreciated.
Wim
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
-
- Posts: 8
- Joined: Mon Apr 26, 2010 2:38 am
- OLAP Product: TM1 / Planning Analytics Local
- Version: PA2 Local 2.0910, PAW 2.074
- Excel Version: 2016 and 365
- Location: Sydney, Australia
Re: Missing title elements in a view, TM1 9.5 and up
Wim,
I came across a similar experience when using HP laptops. It appears that some of the pre-installed HP utilities casused a similar issue. Problem was the HP Protectection tools (HP Protect and HP manager) that were causing the loss of title elements. Remove them and TM1 is happy.
Cheers
Thomas
I came across a similar experience when using HP laptops. It appears that some of the pre-installed HP utilities casused a similar issue. Problem was the HP Protectection tools (HP Protect and HP manager) that were causing the loss of title elements. Remove them and TM1 is happy.
![Confused :?](./images/smilies/icon_e_confused.gif)
Cheers
Thomas
- BigDSter
- Posts: 55
- Joined: Thu May 15, 2008 8:02 am
- OLAP Product: TM1
- Version: 9.4.1
- Excel Version: 2007
- Location: Preston
Re: Missing title elements in a view, TM1 9.5 and up
Just had the same problem on a Windows 7 64bit laptop
Tried
Office 2010 32bit with 9.5.1 - Missing title dimensions
Office 2010 32bit with 9.4.1 - Still some missing
Office 2007 32bit with 9.5.1 - Missing
Office 2007 32bit with 9.4.1 - Still missing
So in a bit of inspiration our ops guys disabled running apps one at a time until it worked, seemed it was down to some single sign in software we use called imprivata.
Close that and it worked fine, thankfully, as this was our test user for a new Win 7 64bit Office 2010 rollout.
Tried
Office 2010 32bit with 9.5.1 - Missing title dimensions
Office 2010 32bit with 9.4.1 - Still some missing
Office 2007 32bit with 9.5.1 - Missing
Office 2007 32bit with 9.4.1 - Still missing
So in a bit of inspiration our ops guys disabled running apps one at a time until it worked, seemed it was down to some single sign in software we use called imprivata.
Close that and it worked fine, thankfully, as this was our test user for a new Win 7 64bit Office 2010 rollout.
David Newton
Burtons Foods
Burtons Foods
- 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: Missing title elements in a view, TM1 9.5 and up
I had this one just tonight (9.5.2). It wasn't happening on all views on all cubes but I once it started happening I could reproduce it on the same cubes repeatedly.
- Did a search and found this thread.
- Deleted .exd files - Did nothing.
- Deleted .ini file - Did nothing.
- Deleted contents of Temp folder - Did nothing.
- Found this link on IBM's site which was... not entirely helpful, given that this is clearly happening on machines which have never had "DigitalPersona Pro" anywhere near them, and which were NOT necessarily Dell or HP. (Mine was neither, and indeed I do not deal with Dell, a company which I consider to be parasitic scum, in any way that doesn't involve needles and voodoo dolls.)
- Reinstalled base client.
- Reinstalled FP1.
- Problem no longer occurred.
Which brings me to the reason that I don't consider the Support document to be that helpful. I did not disable any startup programs. I did not uninstall any software other than the TM1 client. Does it not seem reasonable to assume that this is, in fact, something that is going wrong in the client? For if it was truly and always an issue with the client interacting with other software... all of that software is still there, and you would expect that the interaction problem would persist.
- Did a search and found this thread.
- Deleted .exd files - Did nothing.
- Deleted .ini file - Did nothing.
- Deleted contents of Temp folder - Did nothing.
- Found this link on IBM's site which was... not entirely helpful, given that this is clearly happening on machines which have never had "DigitalPersona Pro" anywhere near them, and which were NOT necessarily Dell or HP. (Mine was neither, and indeed I do not deal with Dell, a company which I consider to be parasitic scum, in any way that doesn't involve needles and voodoo dolls.)
- Reinstalled base client.
- Reinstalled FP1.
- Problem no longer occurred.
Which brings me to the reason that I don't consider the Support document to be that helpful. I did not disable any startup programs. I did not uninstall any software other than the TM1 client. Does it not seem reasonable to assume that this is, in fact, something that is going wrong in the client? For if it was truly and always an issue with the client interacting with other software... all of that software is still there, and you would expect that the interaction problem would persist.
"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.