Custom Data Validation does not work in TM1 Web

[jaygabjoe]

Dear all,

we need to protect our report from data entry with the exception of specific cells. For this exception we used excels data validation and allowed a "Custom" validation based on a cell value (i.e. =e6="String"). In the PAX it works perfectly fine and we get an error if we try data entry for the FALSE case cells. In TM1 Web though, the data validation is "ignored?" completely, meaning it doesn´t work. Entry is allowed in both FALSE and TRUE cells.

PS: Protection via TM1 security wouldn´t work currently for this report, since the criteria in e6 is not in the TM1 architecture.
PAX: IBM Planning Analytics for Microsoft Excel, Version 2.0.67.7
TM1WEB: 2.0.64

Anyone can help out?
Thanks!

[MarenC]

Hi,

I can't help, but all I can say is that custom validation is not supported in TM1web. So has never worked as far as I know.

Maren