This is the documentation for SuperSTAR 9.8

SuperSTAR 9.9 is now available.
View this page in the SuperSTAR 9.9 documentation or visit the SuperSTAR 9.9 documentation home.

Skip to end of metadata
Go to start of metadata

The following are some worked examples of configuring Field Level Security:

Hide a Cross Tabulation Field

This example hides the field Customer Mail Indicator from the user vicuser1:

> cat bank "Customer Mail Indicator" access vicuser1 read false

Unrestricted user:

vicuser1:

Hide a Summation Option

This example hides the summation option Customer Profit from the user user3:

> cat bank "Customer Profit" access user3 read false

Unrestricted user:

user3:

Hide a Value Set

This example hides a value set from the group bankusers:

> cat bank Area
[ XTAB Field : 'Area' ]
    [ ID : 'SXV4__Retail_Banking__F_Customer__Area_FLD' ]
    [ Value Set : 'SXV4__Retail_Banking__C_State' ]
        [ Value Set : 'SXV4__Retail_Banking__C_Geography_2' ]
            [ Value Set : 'SXV4__Retail_Banking__C_Geography_1' ]
                [ Value Set : 'SXV4__Retail_Banking__C_Geography_0' ]

> cat bank Area "SXV4__Retail_Banking__C_Geography_1" access bankusers read false

Unrestricted user:

User in the group bankusers:

Hide a Value within a Value Set

This example hides the values Unknown and Not Applicable from Marital Status for the user user3 (note that each individual value has to be explicitly specified):

> cat bank "Marital Status" "Unknown" access user3 read false
> cat bank "Marital Status" "Not Applicable" access user3 read false

Unrestricted user:

user3:

Hide all Values Except One

In earlier versions of SuperSTAR, if you wanted to hide all the values in a value set except one, you had to explicitly deny access to each value individually. For example, the following commands hide all values under Area except Victoria from vicuser1:

> cat bank "Area" SXV4__Retail_Banking__C_State "Victoria" access vicuser1 read true
> cat bank "Area" SXV4__Retail_Banking__C_State "New South Wales" access vicuser1 read false
> cat bank "Area" SXV4__Retail_Banking__C_State "Queensland" access vicuser1 read false
> cat bank "Area" SXV4__Retail_Banking__C_State "South Australia" access vicuser1 read false
> cat bank "Area" SXV4__Retail_Banking__C_State "Western Australia" access vicuser1 read false
> cat bank "Area" SXV4__Retail_Banking__C_State "Tasmania" access vicuser1 read false
> cat bank "Area" SXV4__Retail_Banking__C_State "Northern Territory" access vicuser1 read false
> cat bank "Area" SXV4__Retail_Banking__C_State "Australian Capital Territory" access vicuser1 read false
> cat bank "Area" SXV4__Retail_Banking__C_State "Unknown" access vicuser1 read false
> cat bank "Area" SXV4__Retail_Banking__C_State "Null" access vicuser1 read false

There is now a quicker way to accomplish this: you no longer need to explicitly deny access to each value individually. Instead, you can deny access to all values in a value set with a single command, and then enable only the relevant ones. The following commands achieve the same result as the previous set of commands:

> cat bank "Area" SXV4__Retail_Banking__C_State values access vicuser1 read false
> cat bank "Area" SXV4__Retail_Banking__C_State "Victoria" access vicuser1 read true

Unrestricted user:

vicuser1: