This is part 1 of a two part blog focusing on the new features in OBIEE 11.1.1.9. This post touches on the Subject Area search and sort options, saved calculated items in the catalog, horizontal layout of dashboard prompts and new preview styles.
1. Subject Area Search and Sort Options
This simple feature allows the user to search a subject area for a specific column or folder. By clicking the magnifying glass icon in the Subject Areas pane, a search box appears and OBIEE will return all objects that contains the text that was entered into the search box. Users can also make use of the % wildcard.
Additionally, the sort feature allows users to alter the order of folders and the presentation columns within those folders by clicking on the Sort Subject Area icon in the Subject Areas pane.
2. Saved Calculated Items In the Web Catalog
This feature allows users to create calculated items in an analysis and save them in the catalog for re-use in future analyses for the same subject area. Ideal for quickly creating calculated items in the user interface without having to make changes in the Administration tool and upload a new RPD.
In the Results tab, select the calculated measure in the global header. The calculation is created in the same way a column formula is created.
Return to the Criteria tab, select the more options icon on the newly created measure and select the Save Column As option.
NOTE: this calculation will only be available for re-use in analyses in the same subject area that it was originally created in. Also, notice when this measure is added to the Selected Columns pane, the icon has a disk next to the golden ruler, indicating that it is a saved measure.
The calculated measure can be edited directly from the catalog pane. Changes made in the catalog will be valid for every analysis that the calculated measure is applied to. If the calculated measure is modified within a particular analysis, the changes will only apply to that specific analysis.
3. Horizontal Layout for Radio Button and Check Box Dashboard Prompts
Radio button and check box dashboard prompts can now be shown horizontally. In the new prompt dialog box, expand the Options section and select your layout preference.
4. New Preview Styles: Skyros and SkyrosCloud
OBIEE now offers different style options to preview an analysis. Depending on which preview style is selected, you’ll notice slight differences in color scheme and the style & formatting of the content. Below is a comparison of Skyros, which is the default style, SkyrosCloud and Fuse.
Have more questions? We can help:
- Contact us using the form here, or call us at 952.947.9300.
- Drowning in data but parched for predictive insights? Arrange a free half-day analytics health check.
- Talk to our experts face to face at one of our upcoming industry events.