Brio Software
Technical Publications
Home Previous Next Index Glossary
Data Analysis and Reporting with Intelligence Clients

Glossary

Adaptive Report Level

The level of privilege that a user can interact with an Intelligence Client document. The adaptive report levels are View Only; View and Process; Analyze; Analyze and Process; Query and Analyze; and Data Model, Query, and Analyze. When a document is published, groups of users are granted access to it with specific Adaptive Report level privileges.

ADR (also called as sync)

See Automatic Distributed Refresh.

Aggregate Limit

Limits placed on aggregated request line items or aggregated meta topic items.

API

Application Programmer Interface

API Socket (DaAPISock)

The API (such as ODBC, SQL Net, and so on) or protocol level information used when connecting to a database that has been abstracted in an API Socket. Brio has one API socket for each supported API/communication protocols.

Application Server

A framework for developing applications that provides fundamental capabilities required by many applications such as session and resource management, and security.

Auditing

The monitoring of Intelligence Client Repository objects to determine usage patterns.

Automatic Distributed Refresh

The process of synchronizing locally saved documents and the version in the repository.

Auto-Join

An administrator can configure a connection file to cause joins to occur automatically for users using the Auto-Join feature. Auto-Join can be configured one of three ways: Best Guess, Custom, and Server-Defined.

Auto-Process

The automatic processing of a query.

Axes

Straight lines on a chart used for measurement and categorization. Typically the X-axis and the Z-axis are both used for categories while the Y-axis is used for quantification (for example, Facts/Values). Pie charts only use the X-axis for its categories and the Y-axis for its Facts/Values.

Brio Repository, Intelligence Client Repository

A specific group of tables created using Intelligence Clients on a database server and used to store Intelligence Client document objects, including data models and standard queries. Administrators can use the Designer client to upload these objects to the repository for end-users to download, providing a template for query and report building. Documents built from repository objects can be version-controlled or audited through a link to the repository.

Catalog

A collection of database tables and local results. This is the information the user can use in a data model or query.

Catalog Pane

Shows a list of elements available to the active section. For example, if Query is the active section, the Catalog pane displays a list of database tables. If Pivot is the active section, the Catalog pane displays a list of results columns. If EIS is the active section, the Catalog pane displays a list of embeddable sections, graphic tools, and control tools.

Categories

Groupings by which the data is organized (for example, month).

CGI

See Computed Item.

Chart

A graphical representation of data. Users create charts to convert raw data into eloquent, visual information.

Chart Section

With a varied selection of chart types, and a complete arsenal of OLAP tools like group and drill-down, the Chart section is built to support simultaneous graphic reporting and ad-hoc analysis.

Client/Server

A network architecture in which each computer or process on the network is either a client (requests information) or a server (delivers requested information).

Clustered Bar Charts

Occurs when the categories are viewed side by side within a given category, useful for side by side category analysis. Clustering is only done with vertical bar charts.

Common Facilities

One of the four categories of objects defined by the Object Management Architecture (OMA). The Common Facilities is a collection of services that many applications may share, but the services are not as fundamental as Object Services. For example, Print Facility and Mobile Agent Facility.

Computed Item

A virtual column (as opposed to a column that is physically stored in the database or cube) that can be calculated by the database during a query, or by an Intelligence Client in the Results section. They are calculations of new data based on functions, data items and operators provided in the dialog box. They can be included in reports or reused to calculate other data.

Connection File

See Open Catalog Extension Files.

Controls Folder

Contains prebuilt items that can be added to your EIS section, such as list boxes, radio buttons, and command buttons. You can then attach scripts to the controls embedded in the EIS section to execute actions.

Correlated SubQueries

Subqueries that are evaluated once for every row in the parent query. A correlated sub query is created by joining a topic item in the subquery with one of the topic items in the parent query.

Cross Join

Creates a query where none of the tables is joined. Every row in one table is joined to every row in another table.

Cube

The data in OLAP databases (MS Plato, Essbase, MetaCube) is stored in 3-dimensional cubes, which is different from standard relational databases (2-dimensional). Cubes are made up of dimensions and measures. A cube may have dozens of dimensions.

DaConnect (aka DaConn)

An Intelligence Clients’s main connectivity class. Contains all the connectivity specific information. Instance of a connection class is made whenever Intelligence Clients needs to connect to any database.

Daemon-mode BQ

The Brio client/server executable. It is spawned in daemon mode by node JREs. The role of the daemon-mode BQ is simply to execute database queries and return results.

DaSession

When a client needs to perform an operation such as select, insert, update on a database, a session is created. The life time of a session synchronizes with the operation’s duration. Sessions are created when a client needs to perform operations on the database and are destroyed when the operation is considered complete.

Data Function

Computes aggregate values, including averages, maximums, counts and other statistics, which summarize groupings of data. You can use data functions to aggregate and compute data from the server before it reaches the Results section, or compute different statistics for aggregated totals and items in the other analysis sections.

Data Model

A representation of a subset of actual database tables that acts as a menu for the query-builder. Data models are the sources for building the Request, Limit, and Sort lines in a query section. You create a data model by dragging database tables from the Catalog pane Table Catalog into the Content pane. The data model displays database tables graphically as topics when they are in the Content pane.

Data models can be distributed through the Brio repository and used by end users to create their own queries.

Database Function

A predefined formula in a database.

Database Server

A computer that stores database management system software (DBMS, for example, Oracle, Sybase, Essbase), and a database shared by a network of computer clients. Most databases are used in a client/server environment.

By storing data on a single, powerful machine on a network, the data is centralized and accessible to many users. The server ensures that the data is maintained correctly and serves as a traffic cop to regulate client machine access to the data. The server’s computing power is also useful in computing and filtering data from the database before it reaches your workstation. For small or localized databases, your own computer can act as both database server and client.

Datatype

The type of data stored in a specific column in a database. For example, data can be stored as a numeric datatype.

Date Group

A feature in the Results and Table sections that separates a date into Year, Quarter and Month columns. The display format for the new Month column is automatically set to mmm so that the month names sort chronologically (as opposed to alphabetically) in the report sections. Quarters are based on the calendar year, beginning January 1.

Designer

A client/server-based tool that delivers query, analysis, and reporting capabilities and centralized solution administration for developers, database administrators, and system administrators.

Design Mode

A toggled environment used to build and modify EIS sections. In Design mode, you build EIS sections with an array of prebuilt control items and graphic items.

Designers can switch out of design mode to test EIS features and deploy them to end users. Design mode is only available in EIS sections. Intelligence Clients Navigator users cannot switch to EIS Design mode.

Detail View

Displays a topic as a database table. When you select Detail view, the database returns ten sample rows from the associated table. Each topic item displays as a database field. Detail view enables users to browse a sample of the raw data, which is useful when unfamiliar with the data model or the underlying data. Users cannot view a meta topic in Detail view.

Dimension

In an OLAP database cube, categories of information are called dimensions. Examples of dimensions may be Location, Products, Stores, and Time. In an Intelligence Client, related, nonquantifiable items in a topic are also referred to as dimensions, such as Contact or Store Name.

Dimension (Legend Dimension)

The current axis categorization or grouping method. This can be set to the X, Y, or Z-axis for most chart types. For line and area charts it can only be set to the Y or Z-axis. For pie charts it is always set to the X-axis. When you change the Legend Dimension the color is distributed along the new axis you change to.

Dimension Tab

In the Pivot section, the tab that enables you to pivot data between rows and columns.

Dimension Table

Consists of numerous attributes about a specific business process. Each row in a dimension table is unique.

Drill Anywhere

Allows you to drill into and add items to pivot reports residing in the Results section, without having to return to the Query section or trying to locate the item in the Catalog pane. Drill Anywhere items are broken out as new pivot label items.

Drill to Detail

Allows you to retrieve items from a data model that are not in the Results section, without having to rerun the original query. This feature provides the ability to interactively query the database and filter the data that is returned. Drill to Detail sets a limit on the query based on the user’s selection and adds the returned value as a new pivot label item automatically.

Drilldown

Allows you to progressively narrow your focus on a selected chart category. Very useful when you have too many categories on a particular axis.

EIS

See Executive Information System.

EIS Home

A button that returns you to the EIS section designated as the EIS Home section. If you have only one EIS section, EIS Home returns to that section. If you have several EIS sections, the default EIS Home is the top EIS section in the Catalog pane. In Design mode you can specify another EIS section to be the EIS Home section.

Embedded Section

A Intelligence Client section that is embedded in a Smart report or other Intelligence Client section. All embedded sections maintain live data content and formatting from the original section. Reprocessing the query, or modifying the original section automatically updates the embedded section display.

Executive Information System

Allows you to build and deploy analytic applications. Analytical applications focus on delivering significant prepackaged business content that is encapsulated within an application. With Intelligence Clients, customers and independent software vendors can leverage their knowledge of industry specific best practices and assemble their own analytical applications for deployment to end users using the Web. Combining embeddable Report sections with enhanced EIS controls into a visual workspace and hooking up interactivity between these controls and the native Brio Software application, an application designer can quickly create a variety of robust applications.

Explorer

A client/server-based tool that delivers query, analysis, and reporting capabilities for power users who need to directly access data sources—or to explore the information organized in prebuilt data models stored in the repository.

Expression Line

Displays displays the JavaScript syntax for each item displayed in a report. Use this line to build equations in the Report section. For ease of use, it can be undocked and resized.

Extranet

An intranet that is partially accessible to authorized outsiders. Extranets are secured by user names and passwords.

Fact Table

A table that stores business activity measures. Most fact tables are extremely large. Each row in a fact table contains numeric measures (fully additive measures, nonadditive measures and/or semiadditive measures) and foreign keys to each dimension table.

Facts

The numeric values that are broken up in the body of the Pivot section. To add facts to the Pivot, put Results columns from the Catalog pane into the Outliner’s Facts pane. Facts are the numeric values in a relational database that are available to analyze. In an OLAP Query, they are called measures.

Facts/Values

The data that is being visually represented, usually a numeric amount (for example, $15,000)

File Server

A computer and storage device dedicated to storing files.

Filters

In the OLAPQuery section, filters enable you to define and apply limits to the query once Top or Side Labels have been added to the query. You set a filter by applying comparison operators on the values for a specific member. Additional server-specific functions are available based on the selected OLAP database cube. Filters are built to include or exclude data according to specific criteria. Filters can be set on any level in a dimension. However, they must be one of the labels in the Outliner. Filters can be made of members of one of the dimensions or selected by a measure. OLE DB for OLAP has other filter operator types (Top N, Top Sum, Top N %, Bottom N, Bottom N %, Bottom Sum.) Essbase and MetaCube have their own operator types. In Essbase and MetaCube, filters can be done on measures. In OLE DB for OLAP, filters cannot be placed on measures.

Foreign Key

A database column or set of columns included in the definition of a referential integrity constraint.

Fully Additive Measure

Attributes in a table that can have their values added together across any dimension.

Grain

The level of detail at which measures in a table are recorded is referred to as the grain.

Grouping Columns

This feature, in the Results and Table sections, creates a new column in a dataset by grouping data from an already existing column. Grouping columns consolidate nonnumeric data values into more general group values and map the group values to a new column in the dataset.

Hardwire Mode

In hardwire mode whenever the OLAP Query is changed, the database is queried to fetch new cube data. In contrast, process mode is manually controlled. You add or remove several items to the Outliner, and then press Process to query the database. When determining whether to use hardwire mode or process mode, consider the size of the cube in which you are working.

Hierarchy

In an OLAP database cube, a hierarchy organizes a dimension’s levels and corresponding members into parent and child relationships. For the levels in a Location dimension, the hierarchy would have Country as the parent of the child City and City as the parent of the child Address.

Home

Abstract base interface that some Lightning interfaces derive from. Provides basic methods to manipulate and create Bean objects.

HTML

See Hypertext Markup Language.

Hypertext Markup Language

A programming language used to create World Wide Web pages, with hyperlinks and tags that explain how to format the information on the screen.

Icon View

Shrinks a selected topic to an icon in the Content pane. The topic remains part of the data model, but is deactivated and can not be accessed by the query. Associated items are removed from the Request line when a topic is made into an icon, and the topic is not recognized as joined to other topics. Icon view is helpful in restricting the use of server time when a topic is infrequently used, and does not have to be active at all times.

Imported Files

Excel, Text, or CSV files imported into Intelligence Clients. The information in the file goes into a table or a results object. Imported results can be used in other queries (like regular results) for local join purposes.

Indexes

Indexes are created in a database to increase the performance of data retrieval. Just as book indexes help to locate specific information faster, database indexes provide a faster access path to table data. Indexes are created on one or more columns of a table.

Insight

A Web tool that delivers query, analysis, and reporting functionality for intranet, Internet, or extranet access to information. Based on user profiles or report-level security, the client environment adapts in six stages from full query, analysis, and reporting with data refresh to static report viewing.

Integrity Constraints

Constraints on tables that guarantee the data adheres to certain business rules. Integrity constraints are defined with a table and are stored as part of the table definition, central to the database data dictionary, so that all database applications adhere to the same set of rules.

Internal Function

Built-in formulas, defined in the Brio application.

Internet

A global network connecting millions of computers. Unlike online services, which are centrally controlled, the Internet is decentralized by design. Each Internet computer, called a host, is independent.

Interval

Equal subdivisions within a given scale. The interval can be set manually or to best fit.

Intranet

A network belonging to an organization, usually a corporation, accessible only by organization members, employees or other authorization users. Intranet Web sites look and act just like any other Web site, but the firewall surrounding an intranet fends off unauthorized access.

ISAPI

This is a shared library that implements HTTP using Microsoft’s Web server plug-in API (ISAPI). Thus it is appropriate for customers with Microsoft Web servers. Functionally it is equivalent to our CGI. Its advantage is that it is far more scalable than a CGI executable.

Item

A visual representation of a database column that is a member of a topic in the Query section. Items are used to create queries and reports. For example, the Customer Topic may have items including Name, Address, and Phone. You select items from data model topics to build the Request, Limit, and Sort lines in the query section.

JavaScript

The scripting language for Intelligence Client products. Intelligence Clients 8.0 includes the Netscape JavaScript interpreter (version 1.4). JavaScript and Brio’s Object Model allow application developers to use the full functionality of the industry-standard scripting language to control Intelligence Client applications.

Job Repository

A set of database tables that store a queue of scheduled jobs. There can be multiple job repositories in an organization.

Join

A relational database concept indicating a link between two topics. A join typically occurs between identical or similar items within different topics. Joins allow row records in different tables to be linked on the basis of shared information in a column field. For example, a row record in the Customer table is joined to a related record in the Orders table when the Customer ID value for the record is the same in each table. This allows the order record to be linked with the record of the customer who placed the order. If you request items from unjoined topics, the database server has no way to correlate the information between the two tables and leads to awkward datasets and run-on queries.

Intelligence Clients display joins visually in the workspace between topics to indicate joins between database tables. Users can also create new joins that are not already specified in the database.

Join Path

A predetermined join configuration for a data model. Administrators create join paths for users to select the type of data model needed in a user-friendly prompt upon processing a query. Join paths ensure that the correct tables in a complex data model are used in a query.

JRE (Java Runtime Environment)

The Java interpreter used to run the Java Server.

Legend Box

An informative box containing color-keyed labels to identify the data categories of a given dimension.

Level

Similar types of members in an OLAP database cube are grouped at the same level. For example, using the members listed in a Location dimension, France, the USA, and Japan belong to the Country level. Paris, Palo Alto, and Tokyo belong to the City level. 35 Main Street belongs to the Address level.

Limits

Constraints placed on topic items or request line items to limit them to a certain set of values. Limits appear on the limit line in Intelligence Clients. For example, although the database may display worldwide sales figures for all stores, you may only want to see sales for stores in Germany. Limits make data sets retrieved through a query more efficient and manageable by filtering out unnecessary information.

Limit Joins

Joins between a database table and a local results object. The topic item being joined is limited by the values of the column being joined in of the local results object. A limit join is one of the options that you can choose in a Modify Join operation between a topic item and a local results item.

Linked Data Model

Documents that are linked to a master copy in a repository. When changes are made to the master, users are automatically updated with the changes when they connect their duplicate copy to the database.

Local Computed Meta Topic Items

Computed item definitions evaluated by the Intelligence Client results engine. Local computed items are created to be meta topic items. They can be dragged to the request line like regular topic items. The only difference is that the results engine evaluates these items as opposed to the database.

Local Joins

A join between a local results object and a database table or another local results object. Intelligence Clients perform the actual join in this case.

Local limits

Limits placed on the local dataset in the Results section, as opposed to the Query section. Limits in the Query section restrict the data retrieved by the query to the desktop. Local limits screen data from view in the Results set; although it is still there, you cannot see the data that has been excluded or use it in reports unless the limit is removed.

Local Results

Results of other queries within the same data model. These results can be dragged into the data model to be used in local joins. Local results are displayed in the catalog when requested.

Locked Data Model

Data Models that are locked cannot be modified by a user.

Manager

See Server.

Master Data Model

A Data Model that exists independently and has multiple queries that reference it as a source. When using a master data model, the text “Locked Data Model” appears in the Content pane of the Query section. This means that the data model is linked to the master data model displayed in the Data Model section, which may be hidden by an administrator.

MDX

(Multi Dimensional eXpressions) The language used to give instructions to OLE DB for OLAP- compliant databases (MS Plato), as SQL is the language used for relational databases. When you build the OLAPQuery section’s Outliner, Intelligence Clients translate your requests into MDX instructions. When you process the query, MDX is sent to the database server. The server returns a collection of records to your desktop that answer your query. See SQL.

Measures

Numeric values in an OLAP database cube that are available for analysis. Measures may be margin, cost of goods sold, unit sales, budget amount, and so on. See Facts.

Members

In an OLAP database cube, members are the content values for a dimension. In the location dimension, they could be Palo Alto, Paris, Tokyo, 35 Main Street, USA, France, Japan, and so on. These are all member values for the location dimension.

Metatopic

A customized, virtual topic, built from regular topics that reflects the exact topic and item structure of database tables. Metatopics allow items from disparate topics to be consolidated in a single topic, simplifying its appearance and reducing its conceptual resemblance to the underlying database structure. You can choose to view a data model in terms of its original topics, metatopics, or a combination of both.

Metadata

Data about data. Stored in database tables, metadata describes the history, content, and function of database tables, columns and joins in understandable business terms. Metadata can overcome the awkward names or ambiguous abbreviations often used in a database. For example, in a table named CUST_OLD, metadata may use a descriptive business name, such as Inactive Customers.

Mime Type

A browser mapping of a file type to either a helper application or a plug-in. When a browser attempts to open a file of a particular mime type, it either loads the associated plug-in or launches the associated helper application. A file’s mime type is determined either by a) the file extension or b) the HTTP header. Plug-ins tell browsers what mime types they support and what file extensions correspond to that mime type.

Brio Web clients support the following mime types: application/x-brioquery mime type (for .bqy files). This is the default mime type our Web clients support and are ordinary Brio files. application/x-brioquerydata (for .bqd files). These are data files in text or Excel format, whose extension has been changed to .bqd. When a Brio Web client is launched to open a BQD file, it imports the data and executes any BrioScript or JavaScript the file contains.

Morphing

Mechanism by which Brio Web clients provide document security. See Adaptive Report Level.

Multidimensional Database

A database that stores data in a format often referred to as a cube, such Essbase, MS OLAP, MetaCube, and so on. See also Relational database and OLAP database.

Navigator

A client/server-based tool that provides simplified query, analysis, and reporting for analysts who need more structured access to the data stored in the repository, but need full analysis and reporting functionality.

Nonadditive Measure

Attributes in a table that cannot be added across any dimension, such as a percentage value (for example, margin rate).

NSAPI

A shared library that implements HTTP using Netscape’s Web server plug-in API (NSAPI). It is equivalent to our CGI. Its advantage is that it is far more scalable than a CGI executable.

Null Value

A null value is absent of data.

OCE

See Open Catalog Extension Files.

OCE Wizard

Wizard or set of screens used to create a new OCE or modify an existing OCE.

OLAP Database

A database that stores its information in cubes. Cubes contain dimensions and measures. A cube can have dozens of dimensions. Cubes are built to hold aggregated data, which anticipate how users think about business models. Cubes deliver this information efficiently and quickly.

OLAPQuery Section

Analyzes and interacts with data stored in an OLAP cube. When you use Intelligence Clients to connect to an OLAP cube, the document immediately opens an OLAPQuery section. The OLAPQuery section displays the structure of the cube as a hierarchical tree in the Catalog pane. Queries are built by dragging measures and dimension levels or members directly into the Outliner panes.

OOA

Object Oriented Analysis.

OOA&D

Object-Oriented Analysis & Design.

Open Catalog Extension Files

Encapsulate and store connection information used to connect Brio applications to a database. OCE files specify the database API (ODBC, SQL*Net, etc.), database software, the network address of the database server, and your database user name. Once created, a user can specify the OCE file and database password and logon. An OCE file is required for a Intelligence Clients document to use a database. the file extension is .oce.

Open Client DBLib

API to connect to Sybase, Redbrick, SQL Server, and so on.

Open Metadata Interpreter

The Tables, Columns, Joins, Lookups and Remarks tabs available in the connection wizard when you edit a custom metadata source. These tabs allow Brio administrators to specify a customer source of metadata that can be accessed through SQL statements, and provided to end users with data models.

Outliners

Drag-and-drop command lines used in the Pivot, Chart, OLAPQuery and Report sections. Each Outliner pane corresponds to a specific layout element of the report. When an item is dragged to an Outliner pane, the item assumes the layout attributes of the respective report element. Data appears simultaneously in the Content pane with the appropriate formatting.

Pivot Dimension

A row or column of labels that corresponds to an item in the Catalog pane.

Pivot Section

The section used to create crosstab reports and analyze data.

Pivot Table

Analytical tools that resemble spreadsheets or crosstabular reports. A pivot table overlays a dynamic datacube, which allows data to be sliced and diced for ad-hoc, interactive, and multidimensional analysis.

Pivoting

In the Pivot section, the ability to change a label from a top to a side (or a side to a top) orientation with a simple click and swing of the label’s Dimension tab.

Plot Area

The area bounded by the X-, Y-, and Z-axis. For pie charts, it is the rectangular area immediately surrounding the pie.

Predefined Drill Paths

Enables a user to drill directly to the next level of detail, as defined in the data model.

Primary Key

A database column or set of columns included in the table definition of the PRIMARY KEY constraint. Primary key values uniquely identify the rows in a table. Only one primary key is defined per table.

Query

A set of database instructions to return an answer set to a specific question. Each row returned in the Results section of a document is an answer to the question posed in the Query section.

Query Computed Items

Item definitions created by the user. This can include other request line items or topic items and or database functions. The definition is sent to the database and the database evaluates them.

Query Log

Log of all SQL statements sent to the database (also referred to as SQL Log).

Relational Database

A database that stores its information in tables that are related or joined to each other by common pieces of information called keys. Tables are subdivided into column fields that contain related information. Column fields have parents and children. For example, the Customer table may have columns including Name, Address, and ID number. Each table contains row records that describe information about a singular entity, object, or event, such as a person, product, or transaction. Row records are segmented by column fields. Rows contain the data that you retrieve from the database. Database tables are linked by Joins. (See also Join)

Report Group

In the report section, embedded reports and tables are grouped by other data items. Items placed in the Groups Outliner break information into these dimensional groupings. For example, your table may include the name, contact information, and sales for each of your distributors. This table gains in clarity when broken into groupings that classify the stores by geographical region, year, or both.

Report Section

A dynamic, analytical report writer, that provides users with complex report layouts and easy to use report building tools. Pivot tables, tables, and charts can be embedded in a report. The report structure is divided into group headers and body areas, with each body area containing a table of data. Tables are created with dimension columns and fact columns. These tables are elastic structures. Multiple tables can be ported into each band, each originating from the same or different result sets.

Repository

Central location used to store data models, queries and queries with reports. Repository is usually a database chosen by the user.

Request Line

Holds the list of items requested from the database server and that will appear in the user’s results.

Request Line Items

Columns listed in the request line.

Results Section

A section in an Intelligence Client document that contains the dataset derived from a query. Data is massaged in the Results section for use in the report sections.

Run Mode

A toggled environment used to test EIS sections. It simulates a Navigator user’s view of the section. In Run mode, you can not add any features, but you can use features that are part of the deployed EIS sections. See also Executive Information System and Design Mode.

Scale

The range of values that allow you to gauge how much each category represents. This range can be either at equal intervals or at logarithmic interval. The scale can be set manually or to best fit.

Script

A series of instructions for a computer. Scripts are activated when an event occurs, such as clicking a button or selecting an item from a drop down list. Intelligence Clients’s scripting language is JavaScript.

Section Pane

Lists all the sections that are available in the current Intelligence Client document.

Section Title Bar

A navigational aid under the toolbars that provides a means of moving between sections and toggling section-specific tools and gadgets, such as the outliner.

Semiadditive Measure

Attributes in a table that can be summarized across some dimensions, but not all.

Server Computed Meta Topic Items

Metatopic item definitions created by the user. These items can use any of the database functions available, or any of the other topic items in the data model. These items are evaluated by the database.

Session Socket (DaSessionSocket)

Abstracts session information specific to each database or API.

Simple Join

Retrieves rows to create a query where the values in joined columns match.

Slicer

An axis that filters the data in an OLAPQuery. Only individual members can be used in a slicer. A slicer can be thought of as a third axis in a OLAP Query. The other axis are the Side Labels and the Top Labels. Every dimension folder contains a members subfolder named “Values for…” that dimension. This subfolder contains the members that are eligible for the slicer.

Snapshot

A local (readonly) copy of table data that originates from one or more remote master tables.

Sort

Conditions placed on request line items to sort the results in ascending or descending order. These are displayed in the sort line in an Intelligence Client.

SQL

See Structured Query Language.

SQL Net

Oracle’s native API to connect to an Oracle database.

Stacked Charts

A chart where the categories are viewed on top of one another for visual comparison. This type of chart is useful for subcategorizing within the current category. Stacking can be used from the Y- and Z-axis in all chart types except pie and line. When stacking charts the Z-axis is used as the Fact/Values axis.

Stored Procedure

Precoded queries in languages other than SQL. This is a feature available in some database software. Intelligence Clients can run stored procedures and retrieve the Results.

Structure View

A view that displays a topic as a list of component items allowing users to see and quickly select individual data items. Structure view is the default view setting.

Structured Query Language

The language used to give instructions to relational databases. When you build the query section’s Request, Limit, and Sort lines, Intelligence Clients translate your requests into SQL instructions. When you process the query, the SQL instructions are sent to the database server. The server returns a collection of records to your desktop that answers your query. This reply is displayed as the Results section. You can look at the SQL generated by a query in the Query Log, or code a query directly in SQL using the Custom SQL window.

Subquery

A query embedded within another query.

Surface Values

A setting in the Pivot section to base aggregate calculations on the values in the report, rather than the values in the Results section.

Synonym

An alias for a database table or view. It is a direct reference to a table view.

Table

The basic unit of data storage in a database. Database tables hold all of the user-accessible data. Table data is stored in rows and columns.

Table Catalog

Displays tables, views, and synonyms to which users have access. Users drag tables from the Table catalog to the Content pane to create data models in the Query section.

Table Section

Used to create tabular-style reports. It is identical in functionality to the Results section, including grain level (table reports are not aggregated). Other reports can stem from a Table section.

Top and Side Labels

In the Pivot section, labels are the column and row headings on the top and sides of the pivot. These define categories by which the numeric values are organized.

Topic

A visual representation of a database table in the Content pane. Topics are part of data models displayed in the Query section and can contain one or more items.

Topic Items

Individual items in a topic or metatopic.

Topics

Visual representation of tables in the database, related by joins that link certain items in each topic. Each topic title bar displays the topic’s name. The topic shows a list of items, one for each column in the database table.

Underlying Values

Another name for Results values. When Use Surface Values is disabled in a Pivot section, aggregate calculations are based on values in the Results section.

Union/Intersection/Minus Queries

Queries created to perform set operations such as Union, Intersection, and Minus. These queries are created by the Append Query option.

Variable Limits

Limits that prompt users to enter or select limit values before the queries are processed on the database.

View

A custom-tailored presentation of the data in one or more database tables. Views do not actually contain or store data; rather, they derive their data from the tables on which they are based, referred to as the base tables of the views.

Web Clients

The Web-enabled counterparts of an Intelligence Client client/server application.

World Wide Web

A system of Internet servers that support specially formatted documents. The documents are formatted in a language called HTML (HyperText Markup Language) that supports links to other documents, as well as graphics, audio, and video files.

WWW

See World Wide Web.

Zero Administration

Installs Brio Web applications (Insight Viewer, Insight Dynamic Viewer, and Insight Analyzer) automatically without the help of an administrator when a user publishes a document.

Adaptive Report Level

ADR (also called as sync)

Aggregate Limit

API

API Socket (DaAPISock)

Application Server

Auditing

Automatic Distributed Refresh

Auto-Join

Auto-Process

Axes

Brio Repository, Intelligence Client Repository

Catalog

Catalog Pane

Categories

CGI

Chart

Chart Section

Client/Server

Clustered Bar Charts

Common Facilities

Computed Item

Connection File

Controls Folder

Correlated SubQueries

Cross Join

Cube

DaConnect (aka DaConn)

Daemon-mode BQ

DaSession

Data Function

Data Model

Database Function

Database Server

Datatype

Date Group

Designer

Design Mode

Detail View

Dimension

Dimension (Legend Dimension)

Dimension Tab

Dimension Table

Drill Anywhere

Drill to Detail

Drilldown

EIS

EIS Home

Embedded Section

Executive Information System

Explorer

Expression Line

Extranet

Fact Table

Facts

Facts/Values

File Server

Filters

Foreign Key

Fully Additive Measure

Grain

Grouping Columns

Hardwire Mode

Hierarchy

Home

HTML

Hypertext Markup Language

Icon View

Imported Files

Indexes

Insight

Integrity Constraints

Internal Function

Internet

Interval

Intranet

ISAPI

Item

JavaScript

Job Repository

Join

Join Path

JRE (Java Runtime Environment)

Legend Box

Level

Limits

Limit Joins

Linked Data Model

Local Computed Meta Topic Items

Local Joins

Local limits

Local Results

Locked Data Model

Manager

Master Data Model

MDX

Measures

Members

Metatopic

Metadata

Mime Type

Morphing

Multidimensional Database

Navigator

Nonadditive Measure

NSAPI

Null Value

OCE

OCE Wizard

OLAP Database

OLAPQuery Section

OOA

OOA&D

Open Catalog Extension Files

Open Client DBLib

Open Metadata Interpreter

Outliners

Pivot Dimension

Pivot Section

Pivot Table

Pivoting

Plot Area

Predefined Drill Paths

Primary Key

Query

Query Computed Items

Query Log

Relational Database

Relational Database

Report Group

Report Section

Repository

Request Line

Request Line Items

Results Section

Run Mode

Scale

Script

Section Pane

Section Title Bar

Semiadditive Measure

Server Computed Meta Topic Items

Session Socket (DaSessionSocket)

Simple Join

Slicer

Snapshot

Sort

SQL

SQL Net

Stacked Charts

Stored Procedure

Structure View

Structured Query Language

Subquery

Surface Values

Synonym

Table

Table Catalog

Table Section

Top and Side Labels

Topic

Topic Items

Topics

Underlying Values

Union/Intersection/Minus Queries

Variable Limits

View

Web Clients

World Wide Web

WWW

Zero Administration


Home  |  Previous |  Next  |  Index |  Glossary

Privacy/Legal | Copyright 2002 Brio Software, Inc.