Description
Returns an Access Right typed value corresponding to the read and write Boolean options.
Users must have the Define Application security permission to be able to use this function.
Syntax
ACCESSRIGHTS(Read, Write)
-
Read(boolean) : corresponds to the Read option. TRUE allows Members to read data, FALSE prevents reading, BLANK prevents reading. -
Write(boolean) :corresponds to the Write option. TRUE allows Members to write data, FALSE prevents write, BLANK prevents write.
Return type
Access Rights
Examples
| Case | Results | Return Type |
|
|
|
|
|
|
| Access Rights |
|
|
| Access Rights |
|
|
| Access Rights |
We recommend to use the BLANK in your formula instead of FALSE where possible in order to benefit from Pigment’s sparse engine. Computations on Pigment are faster on datasets that are sparse; meaning Access Rights metrics that use BLANK in their formulas instead of a value (TRUE/ FALSE) will benefit from this.
Read this article for more details on how Pigment handles sparsity in formulas.
Excel equivalent: none
See also: RESETACCESSRIGHTS
More of a hands-on learner?
Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every Function and Modifier in Pigment!
