Siebel Business Analytics Server Administration Guide > Creating and Administering the Physical Layer in a Repository > Creating and Setting Up Physical Tables >

Viewing Data in Physical Tables or Columns

You can view the data in a physical table or an individual physical column by right-clicking on the object and choosing View Data. In online editing mode, you must check in changes before you can use View Data.

View Data is not available for physical cube tables or columns.

CAUTION:  View Data will not work if you set the user name and password for connection pools to :USER and :PASSWORD. In offline mode, the Set values for variables dialog box appears so that you can populate :USER and :PASSWORD as part of the viewing process.

Using Stored Procedures with an Oracle Database

Stored Procedures within Oracle do not return result sets. Therefore they cannot be initiated from within Siebel Business Analytics. You need to rewrite the procedure as an Oracle function, use it in a select statement in the initialization block, and then associate it with the appropriate Siebel Business Analytics session variables in the Session Variables dialog box.

The function uses the GET_ROLES function and takes a user Id as a parameter and returns a semi-colon delimited list of group names.

The following is an example of an initialization SQL string using the GET_ROLES function that is associated with the USER, GROUP, DISPLAYNAME variables:

select user_id, get_roles(user_id), first_name || ' ' || last_name

from csx_security_table

where user_id = ':USER' and password = ':PASSWORD'