Dashboards are now much more powerful and easy to create.
Administrators design dashboards to provide an overview to key information that drives decisions. Then, using the dashboard, users can chart and even change key business data. For example, they can change a driver such as Volume in a form that’s in a dashboard and immediately see its impact in other forms and charts:
In a dashboard you can include:
- Up to six forms
- Up to nine charts that dynamically depict data. Use chart types such as Area, Bar, Bubble, Column, Doughnut, Funnel, Gauge, Scatter, Radar, and so on.
- A new chart type called a Tile displays a specific value from the cube, for example, the June Sales target for a particular product.
- A new chart type called Gauge works much like a gas gauge: it shows whether a data value falls within an acceptable range or not. For example:
- A dynamic link to an external web site.
- Explanations of data called Commentary.
Dashboards and composite forms now support global POV bars, so that the local POVs that are common are combined in the global POV bar to avoid repeating them in each object. User variables are supported in both local and global POVs.
You have a great deal of flexibility in designing the dashboard. For example:
- You can choose to display objects vertically or horizontally.
- Each object can be a different size.
- You can set an object’s size as Fixed or Flexible.
- The design can be asymmetric.
SUPPORT FOR ATTRIBUTE DIMENSIONS
You can now use an attribute dimension as a dimension, as a filter in forms and reports, and within
ad hoc grids. Using attribute dimensions enables administrators and end users to perform tasks such as:
- Filtering data using attribute members, such as by products with a certain color
- Performing cross-dimensional rollups across attribute members
- Reporting and analysis with attribute dimension members using Smart View, or financial reports
- Using attribute dimensions in dynamic user variables
Attribute dimensions are optional and are listed separately on the Layout tab of the Form Designer. Drag the Attribute dimension to a Point of View or to a row or column to add it to the form grid.
You can also use Attribute dimension members in Smart View where they can be used to filter data, to zoom, and to pivot.
For new applications, administrators can optionally choose a simplified multicurrency option during application creation. Using simplified currency avoids the use of the Hsp_Rates dimension and adds a Currency dimension with exchange rates stored in the Account dimension.
The Currency dimension contains members for all your foreign currencies under Input Currencies and Reporting Currencies.
The Account dimension contains Exchange Rates that stores the ending and average rates used to convert foreign currencies into the base currency. These rates are in FX Rates-Average and FX Rates-Ending.
Exchange rate data is entered to an exchange rate form called Exchange Rates to Default Currency. Users with view permissions can view the rates for the currencies on this form.
A new action menu in the Console allows customers to clear specific areas within both input and reporting cubes. For ASO reporting cubes, a partial clear allows the use of MDX expressions to identify areas of the cube to clear. Clear Cube jobs can be scheduled as jobs using the job scheduler.
When defining data maps, the designer can pick any of the dense dimensions with Smart List associated to be mapped against a dimension in the target cube.
DRILL FROM SHARED MEMBERS ON A FORM
Users can now drill on shared members to navigate to the children of the base member. For example, if the member Gross Profit has children, and Gross Profit is also a shared member in another hierarchy, the user can drill into Gross Profit(shared) when used in a form to see children of Gross Profit.
SPECIFY RANGES WITHIN SUBSTITUTION VARIABLES
You can now specify range values when defining substitution variables, for example, FY16:FY18
HIDE SAVE CONFIRMATION MESSAGES ON FORM SAVE
Form designers can now prevent the form save confirmation message from being displayed to users by specifying an option in form design.
IMPORT METADATA FOR MICROSOFT WORD
The Import Metadata command gives you the ability to reuse Oracle Smart View for Office content in Word documents, content that has already been formatted and customized for Word. You can use the copy and paste commands in Word to retain the customized formatting of a Smart View object, such as a table or graph, and the use Import Metadata to bring the metadata into the copied object.
For example, suppose you have a Word document containing a highly-formatted table with Smart View data points, and you would like to reuse the table in a different Word document. Instead of recreating the table from scratch, you can reuse the work that is already available with the new Import Metadata command on the Smart View ribbon.
Using the Word copy and paste commands to copy the table from one Word document to another, only the data is copied; the metadata is not copied. After the copy and paste, use the Import Metadata command on the Smart View ribbon to import the metadata from the original document into the new document. You can copy and paste within the same Word document or to a different Word document.
INSERT ATTRIBUTES IN AD HOC GRIDS
You can now quickly add attribute dimensions to an ad hoc grid at any time during the ad hoc session.
To launch the Insert Attributes dialog box, where you can select the attribute members to add to the POV, click Insert Attributes on the Planning Ad Hoc ribbon.
When the attribute dimensions are in the POV, you can pivot or drag them to the grid as required. Once on the grid, you can use the Remove Only command to remove any unwanted attribute dimension or members. If the grid already contains some, but not all, attribute dimensions in the database, you can click Insert Attributes to select any of the remaining attributes to the POV.
Note that you can still use Member Selection to add specific attribute dimensions as required.
CREATE A NEW VARIABLE WHEREVER THE VARIABLE SELECTOR IS AVAILABLE
You can now create a variable anywhere that the Variable Selector is available. For example, if you are in a script rule, click the Variable icon, and then click Create.
After you click Create, the Create Variable dialog box is displayed in the rule, and you can create the variable without having to leave the rule.