OT-Portal is a client application which provides users access to the data in the OptimalEnterprise database. The application features rich UI functionality and enables users to build and design their own customized templates showing the data that they need in user friendly charts or tables. It also contains powerful and easy to use analysis features such as drill-down, pivoting, highlighting and performance measurements against KPIs (Key Performance Indicators). Standard Microsoft Windows features such as Copy and Paste are fully supported so users can export richly formatted data to other applications such as Microsoft Excel, PowerPoint and JMP.
Data Sources, Groups and Measures [read more]
Queries are defined using Data Sources consisting of Groups and Measures. For example, the Lot / Operation data source contains dozens of groups including Product Name, Lot Name, Wafer ID, Tester Name, Probecard Name, Test Program Name and more. It also contains measures such as Total Units, Total Good, Total Bad, Yield, Average Test Time, Retest Rate, etc. Users have ultimate flexibility to generate any report they want by selecting any combination of groups and any combination of measures and immediately seeing results summarized by the specified groups. For example, if a user selects the Product Name and Tester Name groups and the Total Good, and Total Bad measures, the system will display a list of all the products together with all the testers on which the products were tested and for each combination, it will provide the cumulative number of good and bad parts tested in the specified time-frame.
Data sources exist with various levels of granularity. There are data sources dedicated to bin results, site data (for parallel testing), parametric results, detailed pass/fail data, rule feedback, equipment utilization and even OT-Portal usage metrics.
Widgets and Pages [read more]
OT-Portal displays are built around pages and widgets. A single widget contains either a chart or data table from a single data source. Creating a widget is a simple task. The user selects a data source, selects the fields to display, specifies a filter and within seconds the data is displayed.
Pages contain multiple widgets which can be moved around and placed on the page freely. Users can create their own pages containing the tools and data they need to do their job and then save the page as a template or share it with other users.
Widgets on a page can be connected. For example, a bin chart can be configured to display the bin distribution of a lot selected in another widget on the page. Whenever the user selects a different lot, the chart will refresh and display the bin distribution of the newly selected lot.
Drilldown [read more]
Users can drilldown into a particular row of data by simply right-clicking and selecting another group from the dropdown menu. In the previous example, if the user drills down by lot name, the system will display all of the lots for the selected product and tester together with the good and bad part counts.
Filters [read more]
It is also possible to filter on any combination of groups and measure so for example, it is possible to select all lots tested on a particular tester with a specific probecard during a given period of time.
Table Capabilities [read more]
The most basic widget is the table widget which displays data in rows and columns. The table widget has a rich set of capabilities that make it intuitive and easy to work with, yet provide the user with advanced functionality.
Examples of built-in table capabilities include:
- Move and resize columns
- Sort by multiple columns
- Pivot data
- Highlight data based on numerical expressions
- Group data and expand/collapse groups
- Freeze columns
- Copy-Paste data to other applications with rich formatting
- Export data to Microsoft Excel and other applications
- Email widgets to other users
Chart Types [read more]
OT-Portal contains a wealth of basic and advanced charts such as:
- Line charts
- Bar chart
- Combination Line and Bar charts
- Pie charts
- Box plots
- Normal plots
- Scatter charts
- X/Y plots
Chart Widgets are defined with the same Groups and Measures as other widgets and therefore the charting capabilities are virtually endless.
Wafer sort data can be displayed on wafermaps in a number of ways:
- Bin maps (showing hard or soft bins)
- Composite maps (showing test and retest data for a single wafer in a single view)
- Cumulative yield maps (showing the yield for each X,Y location from multiple wafers as a color scale)
- Parametric test maps (showing shaded dice based on parametric test measurements)
Additionally, wafermaps can be filtered to show only specific test sites, bins or touchdowns.
A powerful feature of the wafer map viewer is the ability to display wafers reconstructed from final test data. This feature, which is available when Unit Level Traceability (ULT) exists, enables users to detect fab process issues using final test data alone.
Custom Measures [read more]
Users can define "custom measures" which are mathematical expressions comprising data from other measures. These custom measures can be used in any widget in the same way as regular measures.
Targets [read more]
OT-Portal Widgets can compare actual data to "targets" such as Key Performance Indicators (KPI's).
Simulations [read more]
OT-Portal also contains special simulation functionality for Test Time Reduction (TTR).
JMP Integration [read more]
Even tighter integration is provided for users of JMP –a commonly used “statistical discovery” application from SAS. Users can export data directly to JMP and even refresh queries from OT-DB directly within JMP to get the most recent data.
JMP integration includes:
- Export of data tables from any report in OT-Portal to JMP
- Recreation of OT-Portal charts in JMP
- Refresh of OT-Portal data directly from within JMP, without opening OT-Portal
The ability to refresh data from within JMP is particularly powerful. For example, a user can generate a weekly yield report in OT-Portal, export the data to JMP, merge it with data from another external source and perform additional analysis steps within JMP. The following week, it is possible to repeat the analysis on fresh data by simply clicking the "Refresh" button in JMP. This will automatically execute the OT-Portal query which produced the original data for the current timeframe and refresh the data in JMP.
"Under the Hood"
OT-Portal contains an easy-to-use querying engine which allows users to access their data in virtually any way they want. Queries are highly optimized which means that they typically return their results within seconds, even when querying against a huge database.
Analysis tools rely on the quality of the underlying data. OptimalEnterprise’s database and data quality processes ensure that the data in the database conforms to standards and is complete and accurate.