Contains information needed by WebFOCUS to access the data in a data source. The Access File includes the real name and location of the data source.
A view tab that shows the description of the Access File for a synonym.
Manages the communication between the data interface and the data source. Passes data management requests to the data source and returns either answer sets or messages to the requestor.
An alternative view of the Master File, where you can limit the fields available or create a subset of fields from the original Master File. Fields can be grouped into meaningful folders. Field names, titles, and descriptions can be customized for each business view.
Enables you to choose which columns to display on the grids for transformations, column selections, joins, and sorts.
Enable you to create a new file structure by linking existing synonyms of two or more relational tables and using the same or mixed data sources.
A tool you can use to create synonyms for remote data sources configured with the WebFOCUS Reporting Server, or for tables that reside on a subserver.
A field whose value is not stored in the data source but whose value can be calculated from the data that is available there.
A user who has unlimited access to the Master File and data source. This user can set up or change security restrictions for individual users. Only a database administrator can encrypt or decrypt a data source.
A programming language used for manipulating data or files.
Provides data characteristics for the columns in a synonym.
Allows you to access data and develop applications directly on a remote WebFOCUS Reporting Server using Developer Studio tools. This area displays each WebFOCUS Reporting Server that the WebFOCUS Client can access, and permits development against multiple Reporting Servers. A Reporting Server may be configured on any supported platform.
See Master File.
Enables you to create logical views based on enterprise data (relational or legacy data sources) for multidimensional analysis without manually editing metadata. Dimension Builder works with relational and FOCUS data sources.
A logon procedure that passes the user ID and password you provide to a remote server.
A set of data pertaining to a specific topic.
A view tab that shows a hierarchy of segments and columns on the left with the attributes and values of the selected item in the Properties window. The Properties window displays by default on the right side of the tool.
A selection criterion, or WHERE statement, that you can use to quickly select predefined criteria that limits the data included in a report or a graph.
A field that is created by two or more alphanumeric fields, physically next to each other. It provides an efficient means for grouping similar or logically connected fields that will be accessed as a single unit, but do not warrant a separate segment.
A tool that helps you to generate a report to identify the procedures that access a specific Master File or field within a Master File. It helps you analyze the potential impact of modifying or deleting Master Files or fields. The Impact Analysis tool enables you to analyze data, control search criteria, save reports, and interactively open and edit procedures based on search results.
A logon procedure that passes your Windows user ID and password to the server when a connection is made.
A temporary connection between two or more data source files that share at least one common field. Once files are joined, each time a record is retrieved from the first file (host file), it also retrieves the matching records from the second file (cross-referenced file).
Allows you to create join maps and view sample data.
A view tab that shows the list of available objects, as well as the attributes and values of the selected object.
Describes the data source from which you are reporting. The Master File is a map of the data source and all of the fields. By looking at the Master File, you can determine what fields are in the data source, what they are named, and how they are formatted. You can also determine how the fields in the data source relate to each other.
A view tab that provides a visual representation of the synonym. You can rearrange or add fields to the synonym.
A segment in the Master File that describes repeating fields or groups in a non-FOCUS data source. The repeating group of fields is described as a descendent segment in the Master File, and the OCCURS attribute for that segment specifies how to determine the number of repetitions.
The category of software that allows users to analyze different dimensions of multidimensional data quickly and efficiently.
Modified to create dimensions at the field level and associate fields with each dimension.
Enables you to set preferences and customize the look of the Synonym Editor.
A structure in which a parent is a value that supersedes other values, called children, attributed to it. A child is a value that is subordinate to a parent.
The logon scenario in which the user ID and password received from the client application are passed to a data source at connection time. The option requires for the server to be started with security off.
Enables you to restructure data sources, rebuild indexes, and check the integrity of data sources.
Acronym for relational database management system, a type of a database that stores data in the form of related tables.
A type of expression that tests or defines some kind of relation between two entities.
See WebFOCUS Reporting Server.
Enables you to configure adapters, create and enhance synonyms, and perform a wide range of other server-related tasks.
Allows you to determine the number of rows and columns to retrieve, as well as the default format, when sampling data.
A tool used to test the synonym for field data and to view the type of records returned. This can assist when performing joins, testing connectivity to data sources, and so on.
A view tab that shows the segments that the synonym contains.
A type of statement that restricts a Synonym candidate to having one valid SQL Query.
Defines a unique logical name (also known as an alias) for each web services operation. Synonyms are useful because they insulate client applications from changes to the location and identity of a request. You can move or rename a request without modifying the client applications that use it. You need to make only one change, redefining the request synonym on the server. They provide support for the extended metadata features of the server, such as virtual fields and security mechanisms. Creating a synonym generates a Master File and an Access File.
A tool that enables you to view and edit the attributes of a synonym.
A view tab that shows the synonym in a text editor.
Enable you to configure tracing for the server.
The logon procedure used for a trusted connection, where the current logon user ID is passed to the server.
A temporary field that is evaluated as each record that meets the selection criteria is retrieved from the data source.
Provides data access, number crunching, and report generation functionality.
WebFOCUS |