Page 1 of 1

OPS Conosle CubeCellPickListGet Problem

Posted: Thu Dec 17, 2020 10:39 am
by TM1NB
Hi togehter,

I have a strange issue on one of my perspective reports in Excel. In some situations (scrolling / clicking in a Cell) TM1 is starting to calculate something even though the automatic Excel calculations are switched off.
The OPS Console shows in this moments "CubeCellPickListGet" and I don't understand why. In the Cube / the Dimensions are neither Picklists nor are some Data validations or picklist-sheets in the Excel map.
The Cube had a Dimension with some picklists in, but they were deleted long ago. I have no idea why TM1 has to do the "CubeCellPickListGet" in some situaions. There is no System Cube showing something with }...picklist... only a dimension called "}Picklist" with an element "Value".
Can there still be some remains in TM1 of the old Picklists which causes this "CubeCellPickListGet" loading times?

Thank you very much,
TM1NB

Re: OPS Conosle CubeCellPickListGet Problem

Posted: Thu Dec 17, 2020 11:12 am
by tomok
TM1NB wrote: Thu Dec 17, 2020 10:39 am Hi togehter,

I have a strange issue on one of my perspective reports in Excel. In some situations (scrolling / clicking in a Cell) TM1 is starting to calculate something even though the automatic Excel calculations are switched off.
The OPS Console shows in this moments "CubeCellPickListGet" and I don't understand why. In the Cube / the Dimensions are neither Picklists nor are some Data validations or picklist-sheets in the Excel map.
The Cube had a Dimension with some picklists in, but they were deleted long ago. I have no idea why TM1 has to do the "CubeCellPickListGet" in some situaions. There is no System Cube showing something with }...picklist... only a dimension called "}Picklist" with an element "Value".
Can there still be some remains in TM1 of the old Picklists which causes this "CubeCellPickListGet" loading times?

Thank you very much,
TM1NB
Open the Excel file and check for hidden tabs that start with "Picklist***" in the name. You should delete these.

Re: OPS Conosle CubeCellPickListGet Problem

Posted: Mon Jan 04, 2021 12:38 pm
by TM1NB
Hi,

happy new year and sorry for the late reply.
Open the Excel file and check for hidden tabs that start with "Picklist***" in the name. You should delete these.
There are no hidden Tabs.

Any other suggentions?