User-defined tables are logical tables that you create in Essbase Studio, rather than in the RDBMS. These virtual tables, which behave as standard RDBMS views, can be used anywhere regular RDBMS tables or views are used.
User-defined tables enable you to create and to edit models without altering your relational schema or modifying the SQL generated by Essbase Studio. If your database schema is not properly structured for use with Essbase Studio, use user-defined tables to build models and outlines without changing the database schema.
Essbase Studio verifies the SQL commands you use to create a user-defined table and enables you to establish a virtual view of the database schema.
Note: | You cannot create user-defined tables for text file data sources. |
Note: | Oracle recommends including the full path when specifying database tables in the user-defined table SQL statement. |
See also User-Defined Table Examples.