Oracle Analytics Server (OAS): Analytics Classic Course

Learn how to install Oracle Analytics Server. Skip the installation steps if OAS is already installed on your machine.

Install Oracle Analytics Server 6.4 on Windows or Linux by setting up a supported Java Development Kit and JAVA_HOME. Install WebLogic and the RCU repository to configure OAS.

Learn to set the JAVA_HOME environment variable on Windows after installing Java, point it to the JDK path, and verify the Java version via the command line.

Learn to install Oracle Fusion Middleware infrastructure, configure the JDK, run the Oracle Universal Installer, perform prerequisite checks, and verify the Middleware home after completion.

Install oas binaries into the existing weblogic middleware home by extracting the oracle analytics installer and completing the setup with required visual c++ components.

Run the RCU (repository creation utility) from Oracle Home to create the required schemas, configure the database host, port, and service name, and define the dev prefixes and schemas.

Apply the Oracle analytics server configuration to a WebLogic domain using the Oracle Fusion Middleware configuration assistant, selecting analytics, data visualization, and publisher, and verify services via status.cmd.

Install and configure the Oracle client tool on Windows or Linux, set up an ODBC data source to connect to the Oracle BI server, and open RPD online or offline.

Create a data model by building a user and schema, fact and dimension tables, setting up foreign keys, and loading data with two scripts in Oracle.

Explore your schema by distinguishing fact and dimension tables and mapping their relationships via foreign keys, using TOAD and ER diagrams before building the RPD model.

Create a new Oracle 12c database and a connection pool in the physical layer, configure data source names, credentials, and import metadata to verify the connection.

Create a new business model and mapping layer by importing tables, removing dummy and unused objects, and transforming snowflake structures to a star schema.

Transform a snowflake schema to a star schema in the business model and mapping diagram, merging detailed dimensions into dim product, dim organization, and dim currency through column mapping.

Create alias objects in the Oracle administration tool RPD to link time columns to the dim time table and connect to the fact internet sales, ensuring proper one-to-many and many-to-one cardinalities.

Learn how to create measures in the Oracle Administration tool, apply aggregation rules such as sum, max, min, and average in fact tables to enable self service reporting.

Rename measures, dimensions, and logical names in the PPM layer using the Oracle Registration Tool to create business friendly labels across languages, enabling self-service reporting.

Create subject areas in the Oracle Administration Tool by mapping facts and dimensions to finance and internet sales, enable the PM model, verify consistency, and save the RPD for reporting.

Learn how to upload an RPD in offline mode, reload files and metadata to refresh subject areas, and replace the data model via data visualization, with backups.

Create level-based hierarchies in Oracle Analytics Server by building a three-level product dimension: product category, product subcategory, and product, and validate with consistency checks while enabling drill down.

Create a time hierarchy in Oracle Analytics Server with year, quarter, month, week, day, and full date, set the chronological key, and enable drill-down from year to full date.

Resolve the month name sorting issue by using the month number as the sort key. Configure set order and hide the key column for display to maintain global consistency.

Discover how ragged hierarchies create unbalanced branches in Oracle Analytics Server and how to use skipped and dragged hierarchies to model multi-level relationships between parent and child nodes.

Learn to log into Oracle Analytics Server products, including Divi, using hostname and port paths /db. Access Analytics Classic Home or BI Publisher from the same IP address and port.

Learn how to log in to Oracle Analytics Classic Home via dv or direct analytics, explore the homepage, and navigate catalogs, folders, and favorites to manage analyses, dashboards, and reports.

Navigate Oracle Analytics administration to manage privileges and sessions, monitor agent sessions, configure device types, maintenance mode, and catalog search, and customize themes and captions.

Create analyses in Oracle Analytics by selecting finance or internet sales, adding dimensions and measures, configuring prompts and views, and saving the analysis and its business SQL.

Explore the Oracle Analytics create analysis interface, detailing the criteria, results, prompt, and advanced tabs, including subject areas, filters, saved columns, views, and top-ten selection after aggregation.

Learn to format titles and tables in Oracle Analytics Server, adjusting alignment, borders, background, logos, subtitles, prompts, paging, and export options for clear data presentation.

Explore how to format and edit pivot tables, add or modify properties, and use them to group, compare, and summarize large data sets in Oracle Analytics.

Learn to format and edit pie charts in Oracle Analytics, using them to show percentage or proportional data across multiple groups, with customizable legend, style, and data labels.

Learn to create and customize vertical bar charts in Oracle BI, including data setup, sorting, styling, scale, grid lines, and scale markers to compare totals by organization or department.

Learn how to convert a vertical bar chart to a horizontal bar chart in Oracle Analytics Server, adjust criteria and department group name, and tune chart properties and data markers.

Learn to work with stacked bar charts—vertical, horizontal, and 100% variants—creating a total amount by organization name and year, with legend, hover details, and controlled drill-down.

Create area charts to compare multiple data sets and their growth over time, using stacked or 100 stacked subtypes, and drill down by year, organization name, and total amount.

Demonstrates how to create a line chart in Oracle Analytics, configure date-by-date time series, and compare total amount with a second measure while adjusting chart options and formats.

Explore how to build a line-bar combination chart with two y axes, comparing total amount and average amount using bar and line visuals in Oracle Analytics.

Create a performance tile to highlight total amounts with blue and red color cues via conditional formatting, enabling real-time updates and interactive dashboards.

Create and customize a treemap in Oracle Analytics Server to visualize hierarchical data with nested rectangles, using size and color to highlight totals and averages.

Learn to create view selectors in Oracle Analytics to switch between graphs, pivot tables, and tables, with drill down controls and compound layouts for accessible multi-view reports.

Explore selection steps in Oracle analytics server (OAS): analytics classic course to refine results after aggregation, using top ten filters on account description in graphs and tables with view selectors.

Explore how to create and customize gig charts in Oracle Analytics Server to visualize KPI performance using dial, horizontal bar, and sliders, data labels, and traffic light colors.

Explore heat matrix, a color-based matrix visualization in Oracle Analytics that shows values by color rather than size, with options to color by average or total amount.

Learn to create dynamic, data driven text narratives in Oracle Analytics using narrative review, integrate a word map with data visualizations, and customize with JavaScript and CSS.

Learn to combine data from multiple queries using union, union all, intersect, and minus in Oracle Analytics Server, enabling cross-subject reports and distinct dimension handling.

Create analyses that combine data from multiple subject areas using common dimensions, such as time, to build cross-subject area reports.

Learn to display pivot table results as percentages of row or column in Oracle Analytics Server, using show data as percent of column and adjusting labels.

Apply an internal filter through edit formula to show corporate data by scenario, then compute the percentage of total by dividing corporate amounts by the total and multiplying by 100.

Master detail linking in Oracle Analytics Server connects a master view, such as product category, to detailed views showing total sales by product and enables prompts and filters.

Discover how to generate row sequence numbers using r count in Oracle Analytics Server, and build a currency-based total sales view with a flexible table and chart options.

Explore using the case statement in a column formula to map gender values to female or male, and create bar charts and pivot tables in Oracle Analytics.

Apply a case statement in the Oracle Administration tool (RBD) to change marital status across the entire repository, ensuring global consistency and reporting with married and single values.

Explore the timestamp diff function in Oracle Analytics and RBD to calculate age from birth dates and assign age groups with case statements, enabling sales by age group report.

Create a level-based hierarchy in Oracle Analytics to analyze total sales by sales territory, country, and region, enabling country-to-region drill down and live result verification.

Change data types in the RPD physical layer by casting decimals to integers, and build Oracle Analytics reports showing total sales by year and a date line chart with drilldown.

Create performance tiles in Oracle Analytics using internal filters to display four totals: the overall total and per-category totals (accessories, bike, clothing) on the main dashboard.

Create and customize dashboards in Oracle Analytics, combining text, images, links, catalog content, and reports across multiple pages, with styling and export options.

Learn to build a finance dashboard in Oracle Analytics Server by adding reports from the finance folder, configuring dashboard pages and subpages, and enabling drill-down while preserving the main window.

Build an internet sales dashboard in Oracle Analytics, adding a bold header and metrics like total sales by age group, currency, and territory, plus drill-in-place and report links.

Inline prompts are embedded in analyses and not stored in catalog, enabling runtime filtering; dashboard prompts live in catalog and apply to dashboards with column, image, currency, and variable prompts.

Disable the nullable setting for dashboard prompt columns in the physical layer with the Oracle Administration Tool and reload server metadata to eliminate all null values.

Create inline filters in Oracle Analytics Server and link them to dashboard prompts to control data by specific criteria, with filters saved to the report rather than the catalog.

Create a date dashboard prompt with a between value filter on a full date column, using a dynamic SQL window from last year to today.

Build and test dashboard prompts and filters for the internet sales dashboard in Oracle Analytics Server, using currency, product category and subcategory, country region, and date prompts.

Learn how to save an inline filter as a named filter in Oracle Analytics Classic, enabling reusable, consistent filtering across analyses and dashboards.

Learn to create a standalone named filter and apply it to the internet sales analysis, selecting currency, age group, marital status, product category, product, territory, and calendar year.

Split the total sales report by date into two reports, one by year, quarter, and month, and another by specific dates, using dashboard prompts for reports in Oracle Analytics Server.

Learn how to organize and apply a dashboard prompt across or per page, adjust layout and width, and set scope to tailor filters for each page or entire dashboard.

Master report link levels in Oracle Analytics Server using dashboard, page, and analysis links; learn to investigate with analyze and align dashboard prompts to the correct dim time column.

Set up home pages and landing pages in Oracle Analytics to centralize access and security, guiding users from landing pages to finance and internet sales dashboards.

Learn how to format Oracle Analytics dashboards using HTML, JavaScript, and CSS markup to build a centered home page with a logo, navigation links, and landing page buttons.

Learn to manage security in Oracle Analytics Server by creating users and groups and applying predefined and user-defined application rules to control access to reports and dashboards.

Open security in Oracle Analytics Server and create user-defined application rules. Assign predefined rules to groups and link them to users, then apply them to reports and dashboards in BI.

Learn how to manage security in Oracle Analytics Server by controlling report and dashboard access through application rules, permissions, and ownership, with practical role scenarios.

Manage OAS security by assigning users to groups and applying those groups to application rules for dashboards and reports; direct user assignments are possible, but best practice uses groups.

Explore how to manage access in Oracle Analytics Server using users, groups, and application rules to grant or restrict dashboards, reports, and starting pages across finance and internet sales areas.

Learn how to protect filters and convert them to SQL statements to control prompt inheritance across reports and dashboards, with examples of advanced SQL filters.

Explore XML and subject area analysis in Oracle Analytics, duplicate an existing report across finance and internet sales, and modify columns, measures, filters, and formatting using XML overrides.

Configure the Oracle Analytics Server logout URL to redirect back to Oracle Analytics by editing the environment XML, backing up files, and restarting services.

Create and apply presentation variables as column prompts to enforce the same filters across ship date and time tables, using v_year, v_quarter, and v_month with default values.

Explore using presentation variable prompts in Oracle Analytics Server to drive dashboard filters by year, quarter, month, or date with radio buttons.

Master named and inline conditions in Oracle Analytics Server, evaluating analyses and KPIs with presentation variables and radio-controlled prompts to filter dashboards.

Learn to configure a dynamic portal path in Oracle Analytics Server, assigning landing pages per application rule and allowing user overrides via a portal path table and initialization block.

Explore row level security in Oracle analytics, configuring application rules and data filters in the repository or database, using a session variable to restrict product category data for each user.