SQL Information
Click the SQL Information button in the OLE DB Column options properties page to display the SQL Information options in the properties page. Use these options to enter optional information about the selected column. This SQL Information is used when the OLE DB Column is being used for filtering or auto updating. As the Query is run in the Analysis Configuration, it will use the provided SQL Information to append information to the Query.
SQL Information
For most applications, this information is provided by the OLE DB provider (e.g., SQL Server and Oracle) for the database being queried. For those circumstances in which the OLE DB provider does not return the table name, schema name, and catalog name, ambiguities may arise in the SQL statements generated. In the rare cases in which it is necessary to do so, select the checkbox next to the name of the level in the database hierarchy to be specified and enter the applicable name in the adjacent input box.
Table
Select this check box and type in the table name.
Schema
Select this check box and type in the schema name.
Catalog/User
Select this check box and type in the catalog/user name.
When creating or modifying SQL statements.
Use fully qualified column name
Select this check box to include the user and catalog information when defining the column name in the SQL statement.
Use fully qualified table name (of this column)
Select this check box to include the table information when defined the column name in the SQL statement.