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:
ECC User Interface and UI Designer - Modern and interactive UI components with a browser-based designer that allows dashboard content creation through a drag-and-drop framework and fully declarative controls.
ECC Service Interface - REST-based APIs that control the creation and retrieval of data and metadata. They provide advanced capabilities for data retrieval such as aggregations, associations, rollups, and more.
ECC Core - A storage and query engine that enables the definition of data sets along with customized behaviors, relationships, calculations, and more.
Using Oracle Enterprise Command Centers, you can:
Browse and drill on actionable indicators
Use consumer-like search and filters
Drill down with all indicators and search choices recalculated
Through "conversation with the data", narrow in on most important priorities
Navigate to selected transactions to take action
Example of an Enterprise Command Center Dashboard
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.
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.
Oracle Enterprise Command Center Framework provides the following page layouts:
Side Navigation (default): In this default page layout, the side navigation panel is always displayed on the page. This panel contains the search, selected refinements, and available refinements components.
Collapsed Side Navigation: In this page layout, the side navigation panel is collapsed by default and can be expanded by clicking the "Toggle Navigation Panel" icon. When the side navigation panel is collapsed, the Selected Refinements component is displayed as a floating icon on the page. When the side navigation panel is expanded, this icon no longer appears.
No Side Navigation: This page layout lets you display a page without the side navigation panel. This layout is best suited for a landing page or home page that will not have any navigation components. However, the Selected Refinements component is displayed as a floating icon after any filter is applied.
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 Search box supports the following capabilities:
Look and Feel: The search box appears at the page level instead of in the side navigation panel. This look and feel provides easy-to-read search term highlighting and keyboard navigation for the auto-suggestion list.
Multi data set: In the products where the search box is configured with more than one data set, the user can switch among the data sets to search for values from each data set and apply as filters. Name of the selected data set appears on the component header.
Example 1 of a Search Box with a Multi Data Set
Example 2 of a Search Box with a Multi Data Set
Search Attribute: You can choose a context under which you want to perform your search. The context can be configured to refer to any attribute in the system. Inline search within the context attribute is also supported.
For example, if you are using Oracle iProcurement and would like to shop for a monitor, you can select the Computer Monitor category from the Search drop-down menu. Then you start searching for a monitor, a specific list appears that applies to the selected category.
Search Behavior: If you select a search attribute, additional controls let you choose how to display the remaining values of context attributes based on the current filter state on the page.
You can remove applied filters from the search box by changing their selection from the attribute list.
Hyperlink: You can now search and navigate to another page and apply the search term as a filter on the destination page.
Condition: The search box supports applying a data set condition on the suggestion list results.
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
Search Example using 'AND'
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 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
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
Example of a Wildcard Search
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%, 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
Example of a Search using '*'
To perform a single (one and only one) character wildcard search use the "?" symbol. For example, a search for
LAND, and a search for
Example of a Search using '?'
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 Operator||Purpose||Example Usage and Results|
|AND||Returns results with all specified terms.|
Returns results with both 'cip' and 'addition'
|OR||Returns results with any specified terms.|
Returns results with either 'desktop' or 'laptop'
|NOT||Negates the following term (Will not retrieve records that have the unwanted keyword).|
Returns results with 'desktop' but not 'monitor'
Operator precedence is determined in the following order:
Any sub-expressions in parentheses are evaluated first
NOT is evaluated before other operators
AND is evaluated after NOT
OR is evaluated after AND
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'.
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:
With the same attribute and same operator, filters are displayed in the same accordion
Example of the Same Attribute and Operator in Selected Refinements
With the same attribute but different operators, filters are displayed in different accordions
Example of the Same Attribute but Different Operators in Selected Refinements
With different attributes and different operators, filters are displayed in different accordions
Example of Different Attributes and Operators in Selected Refinements
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 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
Example of a Date Range in Available Refinements
Available refinements also support categorizing the attribute in a logical grouping using attribute groups.
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
Example of Search Box for Multi Data Sets
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
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.
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:
Add refinements to the dashboard.
Click the star icon in Selected Refinements header.
To create a Public Saved Search, check the Public Saved Search check box.
Enter a title for Saved Search and click Save.
Once a Saved Search is created, the icon is highlighted.
Example of Creating a Saved Search
Saved Search Example
To search and apply a Saved Search:
Place your cursor inside the search box and to get a list of saved searches.
All Seeded Searches are grouped separately, and Public Saved Searches are marked.
Enter a search query to refine the list.
Click on a Saved Search.
Example of Applying a Saved Search
Example of Application of a Saved Search
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:
Apply a Saved Search.
Click the star (highlighted) icon.
The icon will no longer be highlighted, indicating no Saved Search is applied.
Example of Deleting a Saved Search
The following instructions describe how to edit a Saved Search.
For editing the Saved Search name:
Apply a Saved Search.
Click the star icon.
Update the name.
For editing the filter state:
Delete the Saved Search.
Update filter state.
Click the star (highlighted) icon.
Enter the previous Saved Search's name.
To copy or modify a Public Saved Search:
Apply a Public Saved Search.
Add or delete filters, if necessary.
Click the star icon.
Update the name,
Click Save to create as Private Saved Search.
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.
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
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 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
Example of a Bar-Line Chart
Example of a Vertical Bar Chart
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:
Click a data point on the chart to refine the data by all of the applicable dimension values
Click a label on the category axis to refine the data by that value only
Click a legend entry to refine the data by that value only
Example of a Multi-Metric Chart
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.
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
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
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)
Pie charts show a single metric aggregated across a group dimension.
Example of a Donut Chart
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 Example
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
Bubble Chart Example
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
Example of a Reference Line in a Chart
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.
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
You can change the attributes of the Tag Cloud by using the Options icon.
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
Grid functionality includes the following:
Runtime Sorting: Business users can sort by any attribute displayed at runtime.
Pagination Control and Selection: Pagination control and record selection can be removed from a grid to support additional business use cases for the grid.
Text Formatting: You can change the text style, alignment, size, and color.
Example of a Grid
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
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
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
Example of Results Table with Function Call
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:
Click Export in runtime options to open a pop-up with export options.
Choose standard or custom delimiter.
Choose the Attributes to export.
Choose the number of records.
Choose if hidden attributes and primary key needs to be included.
Choose if the file needs to be compressed.
Example of an Export Pop-Up Window
Example of an Aggregated Table
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
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
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
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.
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.