Adding user-defined tables
The user-defined table is used to create a view within Essbase Studio. User-defined tables should give you some flexibility without having to change the data source. This functionality is going to be important when defining your metadata. Furthermore, this flexibility is valuable in environments where the Essbase developers cannot modify the data source at the risk of impacting other Essbase applications or relational reporting. In this recipe, we will add a user-defined table to our data source and then add that table to the TBC minischema.
Getting ready
To get started, click on the Start menu and navigate to Oracle EPM System | Essbase | Essbase Studio | Essbase Studio Console. On the login menu, enter the server, username, and password.
How to do it...
Right-click on TBC Data Source under the Data Sources node. Then click on New and select User-Defined Table...:
Enter a Table name in the available textbox and the following script to create the user-defined table...
