Hello,
I am hoping someone can help me with the following issue I have.
We are using the following
Environment: TM1 10.2.2
Excel 2010/2013 (some users are either on one or the other)
Issue: Users are using DBRW formula on a spread sheet, connecting to TM1 through Perspectives. There are no security restrictions in place that would stop the upload however the sheet calculates and doesn’t load into TM1.
Multiple users are affected intermittently, the same sheet can be sent to another user with the same access rights and it will work.
Any suggestions on getting this fixed would be amazing.
Thanks
Matt
Excel Recalculation Issue (DBRW)
-
- 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: Excel Recalculation Issue (DBRW)
Hello,
- Are you sure that the user is in the same security groups compared to the user for whom it works ? I assume that for admin user it all works fine ?
- The user has not been marked as 'ReadOnlyUser' ?
- Can the user write a different cube with similar (or equal) dimensions ? Similar slices in the cube ? Etc.
- Not sure it is linked, but did you grant or deny capbilites to certain security groups ?
- Are you sure that the user is in the same security groups compared to the user for whom it works ? I assume that for admin user it all works fine ?
- The user has not been marked as 'ReadOnlyUser' ?
- Can the user write a different cube with similar (or equal) dimensions ? Similar slices in the cube ? Etc.
- Not sure it is linked, but did you grant or deny capbilites to certain security groups ?
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
- 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: Excel Recalculation Issue (DBRW)
You may also want to make sure that the users with problems don't have consolidations selected.
"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.