Tip: Using Row-wise variables and Initialization Blocks
It is often required to use row-wise variables (array’s) to store a list of items. E.g. For the security/visibility it may be required to store the Organization a User has access to. This can be achieved using row-wise variables and Initialization Blocks from OBIEE.
SELECT ‘ActiveOrgs’, OrganizationTable.Name
WHERE OrganizationTable.Use = ‘:USER’
This will initialize the Variable ActiveOrgs with the results of the Initialization Blocks. This variable can than be used at other places to filter the respective Organizations.