To create an odbc data source for importing the SH schema information, perform the following steps: Back to Topic List Files ending in are metadata files, also known as repositories.
The metadata contains the information that the server uses to translate from a logical query (using business terms) to one or more physical queries needed to retrieve the correct information to satisfy the request.
Then, below that entry, create a new line and enter Star = sh.rpd, DEFAULT; to point to your repository.
You create queries and work with views including charts, pivot tables, and narratives.
You then create selectors to drive interactivity in your Business Intelligence requests, and build a custom Dashboard to contain the requests and views you've created.
Finally, you work with dashboard prompts to filter your dashboard and populate variables.
Back to Topic List The dashboard you build in this tutorial charts sales for the last 12 months by channel, country region, and product category and provides trend analysis data as well as narrative highlights of categories that have declined in sales in the last month.. Make sure you have 2 GB RAM and 15 GB hard disk space. If you do not have VMWare software, download a copy of VMWare Player from For all others, before starting this tutorial, you should: Back to Topic List An odbc data source is needed to import schema information about a data source into an Oracle BI Server repository.
It contains a number of parameters that control server settings and behavior.
Right now, you are concerned with the section that tells the server which metadata repository to read.