The default aggregation rule is set in the Oracle BI repository metadata, but can be overridden using controls in the Edit Formula dialog box accessed through the Edit Formula icon in the Edit Table view or the Criteria tab.Click the Column Properties icon above the Amount Sold (000) column.
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.
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.
You can also indicate whether measure labels appear for factual data plotted on an axis.
The available axes can change depending on the type of chart selected from the Graph drop-down list. In the Left tab of the Axis Titles & Labels dialog box, select Custom Title and change the custom title to Amount Sold.
In the Column Properties dialog box, click the Data Format tab, select the Override Default Data Format option, then select Use 1000's Separator option and click OK.