A graph that shows relationships between two or more variables. Use a 3-D display to analyze large quantities of data that are difficult to interpret otherwise.
The mechanisms that limit user access to information or controls based on user identity and membership in predefined groups. Access control is typically used by system administrators to control user access to network resources, such as servers, directories, and files.
A process that monitors data and uses email to deliver alerts when the data meets predefined thresholds and notifications when the data changes. Agents run according to a predefined schedule or when new Business Intelligence content becomes available.
An alternate path within the same dimension that leads to child categories.
In PowerPlay, a category above another category along a drill-down path. For example, 2003 is an ancestor category of 2003/Apr.
Exceptional values that are automatically highlighted. A value is considered exceptional if it deviates significantly from the expected value computed from its row and column percentages.
A method of forecasting based on the auto-correlation approach to time series forecasting. Autoregression forecasting is most reliable when the driving factors of your business affect your measures in a seasonal fashion.
The category against which proportions are calculated in Percent of Base calculations.
A category that shows the results of a calculation. Calculated categories are added to the cube in Transformer. In PowerPlay Web Explorer, you can choose to hide calculated categories.
A column whose values are calculated from other columns, functions, constants, and other calculated columns.
A measure whose values are calculated from other measures, mathematical operators, and numeric constants in an arithmetic equation.
See also Measure.
The items in the rows or columns of the report.
A name that identifies a category.
See also Category.
A category one level below another category along a drill-down path. For example, 2003/Q1 is a child category of 2003, where 2003 is the parent category.
See also Parent Category.
Categories one level below another category along a drill-down path. For example, Outdoor Products, Environmental Line, and GO Sport Line are children of Products.
A chart that groups related information, compares summaries, and compares categories.
A category that shows related information in a vertical list.
A graph that shows the values of two measures that are being compared. Bars represent one measure and a line represents the other. You must have at least two measures to use a correlation display.
A cube that contains the structural information used to combine multiple time-segmented PowerCubes into a time-based partitioned cube.
A chart that shows data in tabular format.
A multidimensional data source created in PowerPlay Transformer. It contains measures (data) organized into dimensions to provide faster retrieval and drill-down in PowerPlay.
Exceptional values that are defined as rules and applied to categories in a report. A value is considered exceptional if it falls within the defined value range.
A group of categories contained in a dimension that appear in a separate, customized category defined by user-specified crtiteria.
Any category below another category along a drill-down path. For example, 2003/Apr is a descendant of 2003.
See also Ancestor Category and Child Category.
A broad grouping of descriptive data about a major aspect of a business, such as products, dates, or markets. Each dimension includes different levels of categories in one or more drill-down paths and an optional set of special categories.
In PowerPlay for Windows and PowerPlay for Excel, one or more rows that shows the categories from each dimension used to filter on data for the current report.
In PowerPlay Web, one or more rows that shows the categories used to filter the data from each dimension in the cube. The dimension line appears above the display in your Web browser.
In Transformer, the row of dimension names that appears either along the top of the dimension map window or just below the Measures and Data Sources option buttons in the Show Scope window.
An organized view of all dimensions, levels, and categories in the selected cube. Use the dimension viewer to add categories as rows or columns and to filter information.
You can also use the dimension viewer in Windows to add categories as layers, create subset definitions, format measures, and define sets of categories.
You can change the display by clicking a display button on the toolbar.
An action that shows different categories. Drilling down shows child categories. Drilling up removes child categories from the report.
An action that shows child categories.
A line that connects a root category to a leaf category and that passes through the drill category of the primary or alternate drill-down path.
See also Leaf Category and Root Category.
To view the information linked to a value in a report, cube, or macro, or a PowerPlay cube, PowerPlay report, PowerPlay Web report, Impromptu report, Impromptu Web report, or IBM Cognos Web Query (IWQ) report. For example, you can drill through a value to view the detailed sales transactions for a particular customer. Any filtering of information in the original object is automatically applied.
An action that removes the child categories, and adds the parent and sibling categories.
PowerPlay Web Explorer interface based on enhanced Web technology support.
An action or occurrence that a program can respond to. An event can be simple, such as clicking a button, or complex, such as meeting a set of conditions defined in an agent. For example, if the event is refreshing a data warehouse, Impromptu Web Reports runs a report each time the warehouse is refreshed.
Formatting that is applied when the information in the report meets the conditions set by the automatic exception sensitivity, or by the application of a custom exception.
A window that shows details about the current information. The administrator decides what to include when they create the cube.
A method to emphasize information important to you by removing unnecessary information from the report. For example, instead of looking at the total sales picture, you can view sales for a specific region, product line, or demographic market without deleting data in the report.
A method of forecasting based on the exponential regression technique of time series forecasting. Growth forecasting is most reliable when the driving factors of your business affect your measures exponentially.
A category at the lowest level of detail in a dimension. For example, if a dimension contains the levels State, City, and Store, and has within these levels the categories California, San Diego, and Pro Form Supplies, then Pro Form Supplies is a leaf category.
An explanatory list of categories in the report for certain displays. It shows the category name and color representing the associated data. The legend doesn’t appear in crosstab, simple bar, simple line, and 3D bar displays.
An object that contains common or default attributes for all its member categories. When users drill down on a dimension, they can drill down on categories from one level to another.
A performance indicator that is quantifiable and used to determine how well a business is operating. For example, measures can be Revenue, Revenue/Employee, and Profit Margin %.
A folder that groups measures from a PowerPlay model into logical groupings. A measure folder can be hierarchical and group either like measures to be collected or calculated measures based on existing measures.
In IBM Cognos Visualizer, calculated measure folders can be referenced in the creation of a chart or filter, whereas measure folders that merely group like measures cannot.
See Cube.
A chart that reveals and compares trends and cycles to show relationships between variables. It also shows time series analysis and relationships between variables.
Categories are arranged in multiple levels along the rows, columns, or layers in a crosstab display. Nested categories form groups of information that add another perspective to a report.
A crosstab display contains categories arranged in multiple levels along the rows or columns.
A container in Upfront for NewsItems, NewsBoxes, and subscriptions to NewsBoxes.
All the objects that a user can see and interact with in Upfront.
The source object that points to the underlying report. Security is applied to the NewsItem.
An email message generated by an agent and sent to one or more recipients to provide information about a business event.
A category one level above another category along a drill-up path. A category can have more than one parent if it lies along more than one drill-down path. The parent value is usually a consolidation of all its children’s values.
For example, 2003 is the parent category of 2003 Q1, 2003 Q2, 2003 Q3, and 2003 Q4.
A chart that shows the relationship between the whole and the parts. For example, a pie display can show you how much of a department’s budget goes to paper supplies.
Creates an item in the portal (Upfront or IBM Cognos Connection) for other report consumers. Publish is equivalent to saving a report.
A special category in a time dimension that allows cube users to create reports using time periods such as Current Month, Last Month, and Quarter-to-Date, each of which is defined relative to the current period.
Relative time categories are updated automatically by the administrator in Transformer, according to the current period set for the dimension.
A document created in PowerPlay for Windows or PowerPlay for Excel, and opened in PowerPlay Web Viewer. A report consists of data selected from a cube. When you save a report and later re-open it, you open the report with the current data from the cube.
The category in a dimension or subdimension from which all other categories are descendant.
A category that shows related information in a horizontal list.
The criteria used by an agent to evaluate data to determine whether a business event occurred. Rules are defined as part of a business information entity.
A graph that compares two different measures. You must have at least two measures to use the scatter display effectively.
Categories at the same level. For example, Outdoor Products, Environmental Products, and GO Sports Line are sibling categories of the parent category Products.
A chart that shows change over a specific time period, contrasts two or more variables, and reveals trends and irregularities in a bar format. This type of display useful for discrete data.
A chart that shows change over a specific time period, contrasts two or more variables, and reveals trends and irregularities in a line format. This type of display is useful for continuous data.
Changes and arranges data when you
For example, if a report shows the number of products sold by each branch at the end of the last quarter, you can slice and dice information to show revenue over the last two months for each product line.
Arranges values in numerical order or labels in alphabetical order. You can sort in ascending or descending order.
A combination display of both a crosstab and a chart (pie, line, bar, and so on) that remain synchronized during filtering, drill down, and slice and dice operations.
A chart that shows relative proportions of parts to the whole and the relationship between the parts in a stacked bar format.
A chart that shows relationships between two or more variables. Use to analyze large quantities of data that are difficult to interpret otherwise.
A cube that combines multiple time-segmented PowerCubes based on the structural information in a control cube.
The data items evaluated by an agent to determine whether a business event occurred.
A method of forecasting based on the linear regression technique of time series forecasting. Trend forecasting is most reliable when the driving factors of your business affect your measures in a linear fashion.
