instantOLAP Online documentation 2.6.1 - Expression

Expression

Type

Boolean

Since

2.1

Description

Whenever the system evaluates the access-rights of a user for a single key of a dimension, it will execute the expressions of all Grants of this dimension (if the "Action" of the grant is the right one) and let the user access the key if at least one expression returned "true".

Because of this, the expression of a Grant must return a boolan value. In this expression you can access the desired key of the dimension by simply using the dimension name (because the key will be the only filtered of this dimension when the expression is executed).

Examples

Expression = "HASROLE( 'iolapAdmin' )"

Expression = "USER() = 'joe' AND Region = 'North'"

Expression = "HASROLE( PRODUCT ).departmentName"

See also

Action

Using the Web-Frontend
Using the Workbench
Using the Query-Editor
Using the Config-Editor
Concepts
Query properties
Chart properties
Configuration properties
Configuration
Database
Table
Column
Alias
Link
Link-Expression
Table-Expression
Dimension
Grant
Action
See also
Expression
Key
Key-Attribute
SQL-Keyloader
SQL-Attribute
Time-Keyloader
Time-Attribute
Number-Keyloader
SQL-Cube
SQL-Dimension
SQL-Fact
Store
Store Dimension
Store Fact
Formula
File-Cache
Include
Expressions
Formats
SQL-Expressions