Enterprise Command Centers

Overview of Enterprise Command Centers

Enterprise Command Centers (ECC) provide information discovery along with visualization and exploration capabilities embedded within Oracle E-Business Suite user interfaces. Oracle Enterprise Command Center Framework enables the creation of business dashboards in different functional areas. Oracle E-Business Suite users navigate transactional information using interactive visual components and guided discovery capabilities allowing exploratory data analysis. Mobility and responsive design are built into the Oracle Enterprise Command Center Framework, and all dashboards automatically adjust the layout to better fit a desktop or mobile device form factor. Oracle Enterprise Command Center Framework automatically adheres to existing Oracle E-Business Suite security. The dashboard content a user sees is completely consistent with the Oracle E-Business Suite context and security.

Each Oracle Enterprise Command Center extends the owning Oracle E-Business Suite application with discovery-oriented dashboards that bring together diverse operational data from across the Oracle E-Business Suite. ECC dashboard users identify and act on top priorities without the need for custom operational reporting, and use information-driven navigation. With tools and visualizations such as actionable indicators, tag clouds, interactive charts, and consumer-like search and filters, users can browse and drill on whatever engages their attention. With each drill-down or search refinement, the data engine recalculates indicators, tag clouds, charts, and search choices to provide the user with new information on which to base the next discovery steps. Through this "conversation with the data", users narrow in on today's most important business challenges, all without predefined navigation paths, structured queries, or operational reports.

Having identified the most pressing business challenges, users seamlessly transition to detailed transaction screens to take immediate and informed action. Transaction screens are pre-populated with the results of information discovery; no re-querying of data is required. Users can switch between information discovery and transaction screens as they work their way through a set of identified problems, retaining the current discovery context.

Oracle Enterprise Command Center Framework is built on scalable architecture comprising the following three main layers:

Using Oracle Enterprise Command Centers, you can:

For more information, see: Using Enterprise Command Centers and Highlights of an Enterprise Command Center.

Using Enterprise Command Centers

Example of an Enterprise Command Center Dashboard

the picture is described in the document text

Each Enterprise Command Center has a set of features that allows users to answer essential questions, uncover business insights, and drill down to take the relevant action. It helps users quickly and intuitively analyze data so they can make confident decisions driven by data.

Oracle Enterprise Command Center Framework brings an interaction paradigm between business users and data in their system of records. Rather than relying heavily on operational reporting, whether custom or out of the box, or using traditional search-and-results interfaces, Oracle Enterprise Command Center Framework transforms that into an interactive engagement.

Oracle Enterprise Command Center Framework relies on the concept of guided navigation through data to achieve information discovery. This approach presents a high level overview of the data to users, based on their roles and access levels. Users then take whatever path they want through the data to explore different aspects. Through their interactions, Oracle Enterprise Command Center Framework guides them with multi-faceted search, cascaded drill-downs, type-ahead suggestions, highlighted keywords, and more.

Highlights of an Enterprise Command Center

Oracle Enterprise Command Center Framework provides a flexible toolset for creating dashboards in different functional areas. The following are some features that enable you to handle diverse scenarios and obtain several types of insights.

Page Layout

Oracle Enterprise Command Center Framework provides the following page layouts:

Search

Oracle Enterprise Command Center Framework comes with search capabilities that allow users to search for a term within a particular data. To do a basic search, type your search term into the search box then a list of attribute values containing the search terms is displayed, and you can select a value from the list to search for it or click on the magnifying glass (search icon) to retrieve all records containing this value.

Search Box Example

the picture is described in the document text

The Search box supports the following capabilities:

If you search for two terms in the search box, the "AND" operator is applied by default between the terms, and values which match each term are returned, even if the terms are not in the same order. For example, a search for office furniture returns furniture-office because it matches both office and furniture.

Search Example using 'AND'

the picture is described in the document text

Oracle Enterprise Command Center Framework also has advanced search capabilities in the search box as wildcard, phrase, and Boolean search with complicated expressions.

Phrase Search

Phrase Search allows you to search for an exact sequence of terms using quotation marks (" "). For example, searching for "phillip taylor" returns only records with phillip taylor (case-insensitive).

Phrase Search Example

the picture is described in the document text

Wildcard Search

Wildcard or partial search used when you are searching for a term where you only know a few letters. By default when you start typing your search term in the search box, a trailing wildcard (*) is implicitly added at the end of the word. For example, a search for work returns all values with terms that start with work; for example, PC WORKSTATION, and WORKSTATIONS.

Example of a Wildcard Search

the picture is described in the document text

Also, you can use (*) or (%) at the beginning of the search term and the results matches any text contains the characters between the search operator, even if they occur in the middle of a word. For example, with a search for *work* or %work%, all values that have 'work' are returned in the search results. (*) or (%) perform a multiple character wildcard search that looks for 0 or more characters. For example, a search for *work* returns values such as PC WORKSTATION, NETWORK, and WORKSTATIONS.

Example of a Search using '*'

the picture is described in the document text

To perform a single (one and only one) character wildcard search use the "?" symbol. For example, a search for ?and returns LAND, and a search for ??and returns STAND.

Example of a Search using '?'

the picture is described in the document text

Boolean Search

You can include logical operators in the search to set more precise search logic based on the operators listed below:

Note: Boolean operators must be in capital letters only: AND, OR, and NOT.

Boolean Search Operators
Boolean Search Operator Purpose Example Usage and Results
AND Returns results with all specified terms. cip AND addition
Returns results with both 'cip' and 'addition'
OR Returns results with any specified terms. desktop OR laptop
Returns results with either 'desktop' or 'laptop'
NOT Negates the following term (Will not retrieve records that have the unwanted keyword). desktop NOT monitor
Returns results with 'desktop' but not 'monitor'

Operator precedence is determined in the following order:

  1. Any sub-expressions in parentheses are evaluated first

  2. NOT is evaluated before other operators

  3. AND is evaluated after NOT

  4. OR is evaluated after AND

Expressions

An expression is used to build a more complex search query. You can combine keywords with AND, OR, or NOT. Use parentheses () to determine the relationship between operators when more than one operator is used. For example, a search for (computer OR desktop) NOT monitor returns records that contain both the words 'computer' and 'desktop' but do not contain 'monitor'.

Selected Refinements

The Selected Refinements region allows you to view and understand how the applied filters are displayed and grouped based on refinement operator.

In the Selected Refinements region, filters are grouped as described below:

Breadcrumbs

The Breadcrumb feature is an intuitive representation of the selected refinements as a trail of filters.

The Breadcrumb feature is configured along with the search box on the page. It places emphasis on the sequence of path user has chosen to arrive at the current state of the dashboard.

The sequence of filters is separated by corresponding data set name and with a control to remove individual values. Filters of the same attribute are placed next to one another, and hierarchical filters are separated by '>'.

Example of Selected Refinements as Breadcrumbs

the picture is described in the document text

Available Refinements

The Available Refinements region allows interactive navigation of the data without your having prior knowledge of its spread and characteristics. Available Refinements presents you with all available possible values of an attribute through facets, date ranges, and number ranges.

As you interact with available refinement components or perform filtering operations from other components on the page, Available Refinements will dynamically update its list to show relevant attributes and attribute refinements. This navigation is data driven and supports progressive disclosure of additional options as appropriate according to your navigation path through the data.

You can search for a specific attribute value using the search box embedded in the available refinements. The minimum number of search characters is 2 to help you to find some search terms like 'IT'.

The Available Refinements feature includes an option to perform a 'Like' search. This type of search supports pattern matching when you enter a search string with wildcards or a Boolean expression. Click the magnifying glass icon displayed next to the attribute for the search to take effect on all page components.

Example of a Search Box in Available Refinements

the picture is described in the document text

Example of a Date Range in Available Refinements

the picture is described in the document text

Available refinements also support categorizing the attribute in a logical grouping using attribute groups.

Multi Data Set

The Available Refinements feature also allows you to apply the appropriate filters from multiple data sets. When more than one data sets are configured in available refinements, the user can switch among the data sets and find, search, apply the right refinements. The name of the data set selected appears on the component header as a title.

Example of a Multi Data Set

the picture is described in the document text

Example of Search Box for Multi Data Sets

the picture is described in the document text

Attribute Group

An attribute group is a logical grouping of attributes for display purposes. Attribute groups provide ease of navigation through Available Refinements.

For example, in an Assets application, the attributes could be grouped into the following: Asset Details, Category, Financial Details, Sources, and Assignments. The Asset Details attribute group contains the attributes Manufacturer Name, Model Number, Serial Number, and so on.

Example of an Attribute Group in Available Refinements

the picture is described in the document text

Attributes are then displayed in a hierarchical order based on the attribute groups.

Oracle Enterprise Command Center Framework supports advanced scrolling functionality by limiting the height of refinements section by the height of the dashboard. Any expansion of refinements due to the addition of selected refinements or expansion of accordions in available refinements will be within this height.

Saved Search

Oracle Enterprise Command Center Framework provides an option to save the frequently applied filters or preferred filters as saved searches for allowing users to use them. All saved searches are context-sensitive to the page and are part of the search suggestions. The list of saved searches appeared when focused on the search component. Saved searches are searchable by their title, filter attributes, and filter values.

Three types of saved searches are available for the users: Public, Private, Seeded. Seeded saved searches are published along with the product, and admin users create public saved searches, and all the saved searches created by users are called Private saved searches. Private saved searches are accessible only by the users who created them whereas public saved searches are accessible by all the dashboard users.

To create a Saved Search:

Example of Creating a Saved Search

the picture is described in the document text

Saved Search Example

the picture is described in the document text

To search and apply a Saved Search:

  1. Place your cursor inside the search box and to get a list of saved searches.

  2. All Seeded Searches are grouped separately, and Public Saved Searches are marked.

  3. Enter a search query to refine the list.

  4. Click on a Saved Search.

Example of Applying a Saved Search

the picture is described in the document text

Example of Application of a Saved Search

the picture is described in the document text

Note: If the search box is inside the side navigation panel, then the saved search list appears without the saved search filters.

To delete a Saved Search:

Example of Deleting a Saved Search

the picture is described in the document text

The following instructions describe how to edit a Saved Search.

For editing the Saved Search name:

For editing the filter state:

To copy or modify a Public Saved Search:

Data Visualization

Oracle Enterprise Command Center Framework has a set of graphs and charts that provide a powerful way of summarizing and presenting data that are critical in decision making in an easily comprehended manner. You can find insights, detect outliers, filter the data directly from the charts, and drill down to a deeper level of details. The following examples show how charts and graphs are used to detect and solve several problems or highlight bottlenecks and exceptions.

Summarization Bar

As the name implies, metrics, flags and dimensions in the bar summarize important aspects of the data displayed. All values are updated with new calculation results when you change the focus as you filter the data.

The summarization bar supports conditional formatting. With conditional formatting, a metric item can be displayed in a specific color based on a specific value or range of values, so that the color changes depending on the value of the metric.

Summarization Bar Example

the picture is described in the document text

You can apply a filter from a metric item in the summarization bar; this filter can be based on static condition. For example, "Draft Orders" based on conditions (open flag = Y AND booked flag = N). Also, the filter can be based on a variable condition. For example, "My SRs" metric is based on service requests assigned to the logged-in user. In this case, the condition is changing based on the logged-in user.

Charts

Charts depict data trends, distributions, anomalies, and more. You can drill down through different levels of hierarchy and allow the system to expose different levels of details dynamically. You can control which options to slice the data by and affect the whole navigation path by picking filters directly from the charts.

Charts are effective when there is numerical data that splits nicely into different categories so you can quickly see trends within the data, compare related information, and gain immediate insight.

Example of a Horizontal Bar Chart

the picture is described in the document text

Example of a Bar-Line Chart

the picture is described in the document text

Example of a Vertical Bar Chart

the picture is described in the document text

You can refine the displayed data by clicking the data point on the chart. Also, by hovering the mouse over a chart, you can display the dimension and metric value for a data point.

Also, you can make the following refinements:

Multi-metric Chart

Example of a Multi-Metric Chart

the picture is described in the document text

A multi-metric chart supports the display of multiple metrics. Each metric shares the same axis. In this way, you can visually compare metrics against a shared dimension. In a multi-metric chart, the bars are grouped by a series dimension.

For example, an organization could have a number of projects. A multi-metric chart could be used to compare the planned versus the actual quantity of a resource per project, or it could be used in a comparison of cost and revenue per project.

Multi-metric Bar-Line Chart

A multi-metric bar-line chart supports the display of multiple bars and line metrics. Bar metrics and line metrics have their axes, respectively. In this way, you can visually compare metrics against a shared dimension. A series dimension groups the metrics.

Example of a Multi-Metric Bar/Line Chart

the picture is described in the document text

Stacked Bar-Line Chart

A stacked bar-line chart supports the display of bar metrics aggregated over series dimensions and grouped by group dimension. Line metrics are aggregated over group dimension. Bar metrics and line metrics have their axes, respectively.

Example of a Stacked Bar/Line Chart

the picture is described in the document text

Line Chart (With Group Dimension)

A stacked bar chart can be converted to a line chart at run-time, which renders the chart to display the aggregations as lines. A unique shape represents any individual stacks for a group.

Example of a Line Chart (With Group Dimension)

the picture is described in the document text

Pie and Donut Charts

Pie charts show a single metric aggregated across a group dimension.

Example of a Donut Chart

the picture is described in the document text

You can hover the mouse over a wedge or segment to display the corresponding metric value as well as its percent of the total.

Scatter Chart

Scatter Chart Example

the picture is described in the document text

A scatter chart is used to plot two metrics against each other. Scatter charts are used to find clusters of data points, to show gaps, and to identify sub-populations. Example use cases include cause and effect analysis (a driving factor and a dependent one), or analysis of the correlation of two variables, for example, the analysis of the relationship between cash inflow and outflow per project.

You can define the dimensions of the data used in the scatter chart. The group dimension (for example, location) controls the shapes of the data point display. The series dimension controls the number of data points with a particular shape. A data point is displayed at the intersection between the x and y metrics.

Bubble Chart

Bubble Chart Example

the picture is described in the document text

A bubble chart is used to plot two metrics against each other with an additional metric represented as the bubble size. Bubble charts are used to show concentrations of data along two axes with magnitude. For example, they could be used to illustrate performance review ratings or customer profitability.

You can define the dimensions of the data used in the bubble chart. The group dimension controls the bubble color. The series dimension controls the number of bubbles with the same color. A data point is displayed at the intersection between the x and y metrics.

Reference Line

Example of a Reference Line in a Chart

the picture is described in the document text

A reference line in a chart can be used to identify a specific value on a chart axis. The value can be based on a function, such as the average, maximum, or minimum. It is a constant value. The reference line is available only for a defined metric; for example, Invoice Amount (sum).

You can add more than one reference line to a chart. You can add a separate line for each metric defined, or you can add several reference lines for the same metric, using different functions associated with each one.

Reference lines are supported in all types of charts except pie and donut charts.

Tag Cloud

A tag cloud highlights keywords in the system based on a configured importance metric. For example, a tag cloud could show top (or bottom) suppliers by invoice count, invoice amounts, and so on.

Example of a Tag Cloud

the picture is described in the document text

You can change the attributes of the Tag Cloud by using the Options icon.

Detailed Insights

Oracle Enterprise Command Centers can offer detailed insights into the data through results tables and grids which help you gain insight as quickly as possible. You can then act on it by taking the required action to resolve a process bottleneck or address an exception.

On some results tables and grids you can use the Options icon to compare records or perform other functions.

For record search only, you can control the order of the search results based on the record score in the data set. Data is sorted by "Score" by default. You can override this default order or add more sort options when you configure a dashboard. This ranking is supported only in results tables and grids.

A results table displays 10 records per page by default, and when expanded, it displays 50 records per page.

Example of a Results Table

the picture is described in the document text

Grid functionality includes the following:

Example of a Grid

the picture is described in the document text

You can compare records in a results table or grid. The Compare pop-up also allows you to compare among the records view information of attribute values. Attributes are organized into corresponding groups if configured.

Compare pop-up can also have dynamic titles as column headers. An aggregated table displays aggregated metrics in tabular format. The aggregation level is controlled by all dimensions displayed in the table. Examples of aggregated tables include the comparison of the financial information of multiple assets, or the comparison of account balances.

Grid actions can also be accessible from the column headers of the pop-up.

Example of a Compare Pop-Up Window

the picture is described in the document text

Record details allow you to view all the significant information of a record in a tabular format. Record details display the details in a pop-up window like the compare pop-up window. Attributes in a record details pop-up window can also be organized into respective groups if configured. Similar to the compare pop-up window, the record details pop-up also supports dynamic titles and column header grid actions.

Example of a Record Details Pop-Up Window

the picture is described in the document text

Users can invoke Oracle E-Business Suite actions directly from the dashboard using a subset of records or all the records in the results table. This capability is subject to the configuration in the component. Actions configured with this functionality is active even when no records are selected. Also, the user is warned number records used by the runtime actions exceed the limit set in the configuration.

Example of a Runtime Action with Postback Enhancement

the picture is described in the document text

JavaScript functions can be invoked corresponding to each record in the results table.

Example of Results Table with Function Call

the picture is described in the document text

Records in results table and results grid can be exported in a CSV file format. The exported file contains records organized in a tabular structure with attribute keys and attributes names as table headers. The exported file also contains selected refinements on the page and timestamp of export. To Export:

  1. Click Export in runtime options to open a pop-up with export options.

  2. Choose standard or custom delimiter.

  3. Choose the Attributes to export.

  4. Choose the number of records.

  5. Choose if hidden attributes and primary key needs to be included.

  6. Choose if the file needs to be compressed.

Example of an Export Pop-Up Window

the picture is described in the document text

Example of an Aggregated Table

the picture is described in the document text

Additional Features

Exporting a Data Set

Oracle Enterprise Command Center Framework allows the export of data sets along with attribute names and keys as column headers. The new file is exported with the '.csv' extension and has a timestamp of the export in the first row. This feature enables users to evaluate data, create or modify attributes based on their discretion, and create experimental data. The number of records that can be exported is subject to a limit that is set in configuration properties. Users can export the data set from the Data Set section in the Administration UI.

Example of Exporting a Data Set

the picture is described in the document text

Data Ingester

Oracle Enterprise Command Center Framework allows the import of data into a data set using a '.csv' file or an SQL Query. File upload can be used to completely refresh the data set with a new set of records, or to extend the data set by modifying existing data and updating the data. File upload provides the flexibility to use a file with any custom text separator. File upload is specific to the language of the data in the file. File Ingester can also be used to import downloaded data set after any modifications.

Example of File Upload

the picture is described in the document text

Query Upload allows users to input an SQL query to ingest data into the data set from any database connected to Oracle Enterprise Command Center. Query Upload can also be used to completely refresh the data set with a new set of records or extend the data set by modifying existing data and then updating the data.

Example of Query Upload

the picture is described in the document text

Online Data Load

Oracle Enterprise Command Center Framework supports online data load for minimizing the impact of downtime. Users can still use the dashboard while data load runs in the background. Once the full load process is completed, new data replaces the existing data.

About ECC

Oracle Enterprise Command Center Framework has a section in its Administration UI for describing essential details of ECC, called About ECC. About ECC is subdivided into three sections: About, Configuration, Documentation.

The About section describes the version details of Oracle Enterprise Command Center and other driving technologies behind it: Java Extension Toolkit (JET) and SOLR. This section also provides version details of all the applications.

The Configuration section encloses configuration properties of Oracle Enterprise Command Center and Java organized in a tabular structure.

The Documentation section contains links to all the documentation, tutorials required for understanding or basic troubleshooting of Oracle Enterprise Command Center.