INDEXCOL in OBIEE

Indexcol is an important concept when we use in OBIEE.

You can use the INDEXCOL(constant<Variable>,exp1,exp2,exp3,...)

This can be used in the case of security log in.

For example when the user is of Higher level then he/ she will be able to see the exp1 and the hierarchy wise the user see the expressions.
This really works for the hierarchy columns too.

An example would be-

INDEXCOL(sess_var,col1,col2,col3,col4)

Here-
sess_var       variable value when the user logs in. It gets captured. For ex- Either 1,2,3 or 4
col1,...          Depending upon the sess_var value the columns would be visible to the user.