Cell type is consolidated- string type

Post Reply
kkmk
Posts: 73
Joined: Wed Jan 25, 2012 9:08 am
OLAP Product: IBM Cognos TM1
Version: 10.2
Excel Version: 2013

Cell type is consolidated- string type

Post by kkmk »

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
Wim Gielis
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

Post by Wim Gielis »

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
kkmk
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

Post by kkmk »

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
Alan Kirk
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

Post by Alan Kirk »

kkmk wrote: Sun Sep 15, 2024 7:59 pm 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?
Basically, THIS:
Forum.jpg
Forum.jpg (408.69 KiB) Viewed 5266 times
In answer to your question:
But I have a different situation where getting this error for the element is String type and N level(0) when CellputS.
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.
"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.
Post Reply