If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Read only field set by condition

Started by Stejawh, 16 Jun 2008 03:26:56 AM

Previous topic - Next topic

Stejawh

Hi,

I have a field in a model that needs to be set as read only apart from when one condition is met when users will then need to edit it.  Whats the best way of going about this?

Thanks,

ykud

Make 2 fields and read data from override field on condition

dermeister

YKUD-
For clarity, is what you mean, create an if-then formula involving at least three fields (override field, reporting field, data field)?

Example
Reporting field formula:
if(criteria is true, then take data field value, otherwise take value from override field)

The field that contains this formula (reporting field) will always be read only. The override field is always writeable, but data will not flow through unless criteria is met.

There is no way that I am aware of to edit read/write access on the fly through contributor web grid. It is handled within the CAC. There is data validation functionality in version 8.2 and higher, but I don't believe it can be used to affect read/write access.

ykud

Yes, you got it right, I was talking about setting up a condition.

sascha

The version 8.2+ validation functionality in the admin console might also be a valid way of checking the 'consistency' of the users entries.

Shaunysyd

You can set up read only status bu using D-links. Use a conditional calc based on the contents of the criteria field. D-list format this Conditional using a flag. Include this flag in the dimensions of the cube. use an accumulation link to target the cell you want to be read only.