Hi,
We are getting this common error cell type is consolidated when CellputN. But I have a different situation where getting this error for the element is String type and N level(0) when CellputS.
Any suggestions please.
Regards
Cell type is consolidated- string type
-
- MVP
- Posts: 3222
- 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: Cell type is consolidated- string type
My suggestion would be to post in the regular forum, not with Commercial.
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
-
- Posts: 73
- Joined: Wed Jan 25, 2012 9:08 am
- OLAP Product: IBM Cognos TM1
- Version: 10.2
- Excel Version: 2013
Re: Cell type is consolidated- string type
I don’t understand commercial forum and regular forum. Because I post always here. Would you be able to help me with regular forum link please?
Thanks
Thanks
-
- Site Admin
- Posts: 6643
- 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: Cell type is consolidated- string type
Basically, THIS: In answer to your question:
You can write strings to consolidations, but the string element has to be in the last dimension. I don't think that's necessarily the issue here though, otherwise I expect you'd get a "not numeric" error. (I'm not completely sure, because obviously having a string element outside of the last dimension is not something I've ever done, but it seems more likely.) However we'd need to get the full details of the element combination that you're writing to, ideally including a screenshot of the dimension containing the string element.But I have a different situation where getting this error for the element is String type and N level(0) when CellputS.
"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.