Glossary (Report Builder)
Applies To: SQL Server 2016
An integral Windows component that supports building, deploying, and running the next generation of applications and Web services. It provides a highly productive, standards-based, multilanguage environment for integrating existing investments with next generation applications and services, as well as the agility to solve the challenges of deployment and operation of Internet-scale applications. The .NET Framework consists of three main parts: the common language runtime, a hierarchical set of unified class libraries, and a componentized version of ASP called ASP.NET. See also: ASP.NET, common language runtime, .NET Framework class library.
ActiveX Data Objects
Component Object Model objects that provide access to data sources. This API provides a layer between OLE DB and programming languages such as Visual Basic, Visual Basic for Applications, Active Server Pages, and Microsoft Internet Explorer Visual Basic Scripting.
ad hoc report
An .rdl report created with Report Builder 1.0 that accesses report models.
A control or status area that is attached to the edge of a pane or window, such as a toolbar or ruler.
A summary value comprised of multiple individual values.
A function that performs a calculation on multiple values and returns a single summary value.
aggregate of aggregates
A summary value calculated from aggregates, such as the maximum of a set of sums.
A query that summarizes information from multiple rows by including an aggregate function such as Sum or Avg.
A table or structure that contains precalculated data for a cube.
An alternative name for a table or column in expressions that is often used to shorten the name for subsequent reference in code, prevent possible ambiguous references, or provide a more descriptive name in the query output.
In a report, a set of numeric values that can be analyzed. In a report map, analytical values control color, marker type, or size of map elements on each map layer.
In graphics, using an algorithm to smoothing out a jagged approximation of a curved line.
The database that stores user and system data for one application.
A value that provides information to an action, an event, a method, a property, a function, or a procedure.
A managed application module containing class metadata and managed code as an object in SQL Server, against which CLR functions, stored procedures, triggers, user-defined aggregates, and user-defined types can be created in SQL Server.
The process of verifying the identity of a user, computer, process, or other entity by validating the credentials provided by the entity. Common forms of credentials are digital signatures, smart cards, biometric data, and a combination of user names and passwords.
1. The operation that verifies the permissions and access rights that are granted to a user. 2. The process of granting a person, computer process, or device access to certain information, services or functionality.
The vertical and horizontal lines on a graph used to show the position of a point.
The number of units between major tick marks on a chart axis. The interval is automatically calculated, but can be manually set.
To make a duplicate copy of a program, a disk, or data.
A collection of files, folders, and other data that have been duplicated and stored in a file or on one or more tapes.
A table stored permanently in a database. Base tables are referenced by views, cursors, SQL statements, and stored procedures.
1. A set of SQL statements submitted together and run as a group. 2. In Reporting Services, a collection of SOAP method calls within a single transaction.
binary large object (BLOB)
A piece of binary data that has an exceptionally large size, such as images, audio, or multimedia tracks that are stored as digital data, or any variable or table column that is large enough to hold such values.
An operation that manipulates a single bit, or tests whether a bit is on or off.
A link in a report that jumps to another place within the report.
An operation or expression that can be evaluated only as either true or false.
A map layer that displays variable size circles. Bubbles center on polygon center points or on points.
A group of predefined functions provided as part of the Transact-SQL and Multidimensional Expressions languages.
A column in a table that displays the result of an expression instead of stored data.
A field, defined in a query, that displays the result of an expression instead of stored data.
A member of a dimension whose value is calculated at run time by using an expression.
Defines the number of instances allowed and/or required of a child entity per parent entity.
Parameters that derive their available values from the selection of a preceding parameter. Cascading parameters are used to filter a set of parameter values.
category (x) axis
The axis for grouping data in a chart, usually the horizontal axis. Exception: in bar charts, the axes are reversed and the y axis displays grouping data.
A digital document that is commonly used for authentication and to help secure information on a network. A certificate binds a public key to an entity that holds the corresponding private key. Certificates are digitally signed by the certification authority that issues them, and they can be issued for a user, a computer, or a service.
The types of characters that SQL Server recognizes in the char, varchar, and text data types.
chart data region
A report item on a report layout that displays data in a graphical format.
A member in the next lower level in a hierarchy that is directly related to the current member.
In Transact-SQL, a subunit of an SQL statement. A clause begins with a keyword.
A report that displays related report model data when you click data within a rendered Report Builder report.
An application that retrieves data from a server and performs local analysis and presentation of data from relational or multidimensional databases.
A cursor that is implemented on the client. The entire result set is first transferred to the client, and the client API software implements the cursor functionality from this cached result set.
See Other Term: common language runtime
A function created against a SQL Server assembly whose implementation is defined in an assembly created in the .NET Framework common language runtime.
CLR stored procedure
A stored procedure created against a SQL Server assembly whose implementation is defined in an assembly created in the .NET Framework common language runtime.
A trigger created against a SQL Server assembly whose implementation is defined in an assembly created in the .NET Framework common language runtime.
CLR user-defined type
A user-defined data type created against a SQL Server assembly whose implementation is defined in an assembly created in the .NET Framework common language runtime.
code access security
A mechanism provided by the common language runtime whereby managed code is granted permissions by security policy and these permissions are enforced, helping to limit the operations that the code will be allowed to perform.
A set of rules that determines how data is compared, ordered, and presented.
1. An object that contains a set of other objects. 2. In Master Data Services, a hierarchical grouping of members from explicit hierarchies and other collections.
The algorithm that automatically assigns colors to each map element on a map layer.
A type of map legend that is used to interpret what colors represent on a map.
common language runtime
The engine at the core of managed code execution. The runtime supplies managed code with services such as cross-language integration, code access security, object lifetime management, and debugging and profiling support.
An expression that cannot be represented as a single built-in field reference, and is displayed on the design surface as <<Expr>>.
The combining of two or more character strings or expressions into a single character string or expression, or to combine two or more binary strings or expressions into a single binary string or expression.
A process that allows multiple users to access and change shared data at the same time. SQL Server uses locking to allow multiple users to access and change shared data at the same time without conflicting with each other.
See other term: configuration file
In reference to a single microcomputer, the sum of a system's internal and external components, including memory, disk drives, keyboard, video, and generally less critical add-on hardware, such as a mouse, modem, or printer.
A file that contains machine-readable operating specifications for a piece of hardware or software, or that contains information about another file or about a specific user.
The scope in which an expression is evaluated. Scope is determined by the report processor as data and layout elements are combined.
Data used by a principal to establish the identity of the principal, such as a password or user name.
A set of data that is organized and summarized into a multidimensional structure defined by a set of dimensions and measures.
An entity that maps over a result set and establishes a position on a single row within the result set.
A collection of information that is required to access a specific data source. The collection includes a data source name and logon information.
A component in Reporting Services that is used to retrieve report data from an external data source.
A mechanism for users to receive a stream of data from data sources. In Reporting Services, the Atom rendering extension generates data feeds in Atom format from reports.
The organization of data that is processed by the report processor: dataset, data region, data region group, details group.
The process of analyzing data to identify patterns or relationships.
The smallest individual entity in a chart.
data processing extension
A component in Reporting Services that is used to retrieve report data from an external data source.
The layer of sofware that handles communication between data extensions and customized software specific to each type of external data source. Depending on the specific data source, multiple data providers are available from Microsoft and from third-party vendors.
A report item that displays repeated rows of data from an underlying dataset in a table, matrix, list, or chart.
1. In ADO and OLE DB, the location of a source of data exposed by an OLE DB provider. 2. The source of data for an object such as a cube or dimension. It is also the specification of the information necessary to access source data. It sometimes refers to object of ClassType clsDataSource. 3. In Reporting Services, a specified data source type, connection string, and credentials, which can be saved separately to a report server and shared among report projects or embedded in a report definition (.rdl) file.
data source name
In a report, the name of the data source object.
An attribute that specifies what type of information can be stored in a column, parameter, or variable.
A database specifically structured for query and analysis.
A collection of information, tables, and other objects organized and presented to serve a specific purpose, such as searching, sorting, and recombining data.
The part of a database that contains the definition of all the objects in the database, as well as the definition of the database.
The program module or modules that provide access to a database management system (DBMS).
One of the physical files that make up a database.
The language used for accessing, querying, updating, and managing data in relational database systems.
A database component in a database. Can also refer to the database itself.
The member of the database administrator role of a database.
A collection of one or more data connections (a database and the information needed to access that database).
A collection of users and groups with the same access to an Analysis Services database.
The names of tables, fields, data types, and primary and foreign keys of a database. Also known as the database structure.
A collection of statements used to create database objects.
An image that exists in a database, such as a field in a database that contains images.
A subscription in Reporting Services that uses a query to retrieve subscription data from an external data source at run time.
1. In OLE DB for OLAP, the set of multidimensional data that is the result of running a Multidimensional Expressions (MDX) SELECT statement. 2. In Reporting Services, a named specification that includes a data source definition, a query definition and optional parameter values, calculated fields, and filtering and collation information as part of a report definition (.rdl) file. An .rdl file can have multiple datasets.
double-byte character set
1. A data value, option setting, collation, or name assigned automatically by the system if a user does not specify the value, setting, collation, or name. 2. An action taken automatically at certain events if a user has not specified the action to take.
The database the user is connected to immediately after logging in to SQL Server.
The instance of SQL Server that uses the same name as the computer name on which it is installed.
1. In Transact-SQL, characters that indicate the start and end of an object name, by using either double quotation marks ("") or brackets (). 2. In Integration Services and Reporting Services, characters that are used to separate records, fields, or strings.
A component in Reporting Services that is used to distribute a report to specific devices or target locations.
The set of communication rules used to route notification messages to external delivery systems.
On a report server, a report catalog item to which other items contain a reference. For example, when a report definition contains a reference to a shared data source, the data source is a dependent item.
A type of map legend that displays distance units for the current resolution of the map data.
In a map layer, the algorithm to use to divide analytical values into subranges. Range intervals can be calculated to provide equally spaced intervals between the start and end value (EqualInterval), or be set to values so that an equal number of items is in each range interval (EqualDistribution).
A navigation pane in a report arranged in a hierarchy of links to report sections and groups.
1. In Windows security, a collection of computers grouped for viewing and administrative purposes that share a common security database. 2. In relational databases, the set of valid values allowed in a column.
drill down/drill up
To navigate through levels of data ranging from the most summarized (up) to the most detailed (down).
1. In Analysis Services, to retrieve the detailed data from which the data in a cube cell was summarized. 2. In Reporting Services, to open related reports by clicking hyperlinks in the main drillthrough report.
A technique for navigating through levels of data ranging from the most summarized (up) to the most detailed (down). Created by adding toggles (plus and minus signs) to show and hide levels of the hierarchy of a table or matrix.
1. In Analysis Services, a technique to retrieve the detailed data from which the data in a cube cell was summarized. 2. In Reporting Services, a way to open related reports by clicking hyperlinks in the main drillthrough report.
A drillthrough report is the report that opens as the result of a drillthrough action on a report item in another report. The drillthrough report is usually related to the main, or summary, report through data. A common example of a drillthrough report might be a Monthly Sales report that contains links to individual sales orders for that month.
dynamic connection string
An expression that you build into the report, allowing the user to select which data source to use at run time. You must build the expression and data source selection list into the report when you create it in Report Designer.
A temporary container that is created on the report server and used by a client application such as Report Builder. The edit session enables the reuse of report data across multiple previews of reports in Report Builder.
embedded data source
A data source definition that is included in a report definition file. Embedded data sources are report-specific.
embedded data sources
An embedded data source is an XML element that represents a data connection and is included in and used by a single report definition.
A report dataset and is included in a single report definition or a single report part definition.
A method for keeping sensitive information confidential by changing data into an unreadable form.
1. In Reporting Services, an entity is a logical collection of model items, including source fields, roles, folders, and expressions, presented in familiar business terms. 2. In Master Data Services, an entity is an object within a model. Each entity contains related members that are defined by attributes.
A fixed set of integer values or string constants that may be used to specify the value of certain properties.
In a map report item, a very simple equidistant cylindrical projection in which the horizontal coordinate is the longitude and the vertical coordinate is the latitude.
1. In SQL Server, a text file that records system information. 2. In Integration Services, a record of errors, warnings or events, which can be stored by multiple log providers, including SQL Server Profiler, the Windows Event log, and SQL Server.
error state number
A number associated with SQL Server messages that helps Microsoft support engineers find the specific code location that issued the message.
A character used to indicate that another character in an expression is meant literally and not as an operator.
ESRI .shp file
Open specification developed by Environmental Systems Research Institute, Inc. (ESRI) for spatial data.
Open specification developed by Environmental Systems Research Institute, Inc. (ESRI) for spatial data.
Any significant occurrence in the system or an application that requires users to be notified or an entry to be added to a log.
1. A software routine that executes in response to an event. 2. In Integration Services, a control flow that runs in response to a run-time event.
1. In SQL, a combination of symbols and operators that evaluate to a single data value. 2. In Integration Services, a combination of literals, constants, functions, and operators that evaluate to a single data value.
1. An area in a window or record that stores a single data value. 2. In Report Builder, dataset fields represent either numeric or non-numeric data from a data connection. For example, sales amounts, total sales, customer names, database identifiers, URLs, images, and spatial data. A report can have three types of fields: dataset fields, dataset calculated fields, and built-in fields.
1. A set of criteria that controls the set of records returned as a result set. 2. In Full-Text Search, given a specified file extension, filters extract text from a file stored in a varbinary(max) or image column.
An expression used for filtering data in the Filter operator.
A file consisting of records of a single record type, in which there is no embedded structure information governing relationships between records.
The column or combination of columns whose values match the primary key (PK) or unique key in the same or another table. Also referred to as the referencing key.
A table that contains a foreign key.
A piece of code that operates as a single logical unit. A function is called by name, accepts optional input parameters, and returns a status and optional output parameters.
A gauge is a data region that presents data as a range with an indicator pointing to a specific value within the range.
The gauge panel is the encompassing outer element that contains one or more radial and linear gauges. Use the gauge panel to define properties that apply for all gauges in a gauge panel.
A gauge pointer is a needle, marker, or bar that indicates the current value on the gauge. A gauge pointer is always attached to a gauge scale.
A gauge range is a colored area that represents a “critical zone,” always bound by a start value and an end value, on the gauge scale.
A gauge scale is the range of values, bound by a minimum and a maximum, shown on the gauge. Typically, a gauge scale contains gauge labels and gauge tick marks to give accurate readings of what the gauge pointer is showing.
Data that specifies points, lines, or areas on a curved surface.
A SQL Server spatial data type that represents data in a round-earth coordinate system, such as GPS latitude and longitude coordinates.
A SQL Server spatial data type that supports planar, or Euclidean (flat-earth), data.
global assembly cache
A machine-wide code cache that stores assemblies specifically installed to be shared by many applications on the computer.
A view type that displays data in a table.
A set of data that is grouped together in a report.
A type of map presentation where the intensity of color for each polygon corresponds to the related analytical data. For example, low values in a range appear as blue (cold) and high values as red (hot).
A logical tree structure that organizes the members of a dimension such that each member has one parent member and zero or more child members.
Status of a resource that remains operational and usable by clients most of the time with a very low percentage of failures that interrupt service.
See Other Term: Hypertext Markup Language
A user interface consisting of a report toolbar and other navigation elements used to work with a report.
Hypertext Markup Language
A text markup language used to create documents for the Web. HTML defines the structure and layout of a web document by using a variety of tags and attributes
The name of an object in a database.
A column in a table that has been assigned the identity property.
In a relational database, a database object that provides fast access to data in the rows of a table, based on key values.
An aggregate function that is specified as a scope parameter by another aggregate. For example, in =Max(Sum([Quantity]),"Tablix1"), Sum is the inner aggregate.
An operation that retrieves rows from multiple source tables by comparing the values from columns shared between the source tables. An inner join excludes rows from a source table that have no matching rows in the other source tables.
1. A copy of SQL Server running on a computer. 2. A specific copy of a report item, such as a report part, subreport, dynamic member, or group.
A numeric data type category that includes the bigint, int, smallint, and tinyint data types.
Internet Protocol security
Rules that computers follow to provide private and secure communication over Internet Protocol (IP) networks, through the use of cryptographic security services.
See Other Term: Internet Protocol security
One of two international standards bodies responsible for developing international data communications standards. International Organization for Standardization (ISO) works closely with the International Electrotechnical Commission (IEC) to define standards of computing. They jointly published the ISO/IEC SQL-92 standard for SQL.
item-level role assignment
A security policy that applies to an item in the report server folder.
item-level role definition
a security template that defines a role used to control access to or interaction with an item in the report server folder namespace.
key performance indicator
(KPI) A quantifiable, standardized metric that reflects a critical business variable (for instance, market share), measured over time.
A reserved word in SQL Server that performs a specific function, such as to define, manipulate, or access database objects. For example: SELECT, FROM, and AND.
See Other Term: key performance indicator
A report dataset field that identifies a label for a corresponding key field. Parameters and data regions can display the label for a key field instead of the value.
The amount of time that elapses when a data change is completed at one server and when that change appears at another server.
The latitude coordinate as a decimal degree value in World Geodetic System (WGS 84) datum. Valid range is from –90.0 through +90.0.
In a map report item, a layer specifies type and presentation of a single type of spatial data. A map report item is a container for multiple layers.
A number that identifies a Windows-based locale.
In a report chart, map, or gauge data region, an element that provides a guide between the display presentation of data and the underlying data values.
In a map report item, a layer that displays spatial data as lines, for example, for paths or routes.
A report that references an existing report definition by using a different set of parameter values or properties. A linked report is a report server item that provides an access point to an existing report. Conceptually, it is similar to a program shortcut that you use to run a program or open a file.
list data region
A data region on a report layout that repeats with each group or row in the report dataset. A list can be used to create free-form reports or forms, such as invoices, or in conjunction with other data regions.
1. In SQL Server connections, an instance of SQL Server running on the same computer as the application. 2. In a Transact-SQL statement, when resolving references to database objects, the instance of SQL Server executing the statement. 3. In SQL Server distributed queries, the instance of SQL Server executing the distributed query. The local server then accesses any linked servers referenced in the query.
The Windows operating system attribute that defines certain behaviors related to language.
locale identifier (LCID)
A number that identifies a Windows-based locale.
A file or set of files that contain records of the modifications made in a database.
A name used by SQL Server to identify a file.
The operators AND, OR, and NOT. Used to connect search conditions in WHERE clauses.
A coordinate as a decimal degree value in World Geodetic System (WGS 84) datum. Valid range is from –180.0 through +180.0.
A relationship between two tables in which rows in each table have multiple matching rows in the related table. For example, each sales invoice can contain multiple products, but each product can appear on multiple sales invoices.
A relationship between two tables in which one row in one table can relate to many rows in another table.
A report item that is a container for titles, various types of legends, and map layers.
Map data consists of polygons, lines, points, and Bing map tiles. Map data can be embedded in a report or imported from ESRI shapefiles (.shp), SQL Server spatial data queries, or a Web service that returns images as Microsoft Bing map tiles.
The area of the map to display in the map report item. For example, a map for the entire United States might be embedded in a report, but only the area for the northwestern states are displayed.
The symbol that is displayed on a map point layer at each point location.
The system database that records all the system-level information for an instance of SQL Server.
The file installed with earlier versions of SQL Server used to store the master, model, and tempdb system databases and transaction logs and the pubs sample database and transaction log.
A set of fields that are used to build a relationship between analytical data and spatial data.
matrix data region
A data region on a report layout that provides functionality similar to crosstabs and PivotTable reports. At run time, as the report data and data regions are combined, a matrix grows horizontally and vertically on the page. Values in matrix cells display aggregate values scoped to the intersection of the row and column groups to which the cell belongs.
See Other Term: Multidimensional Expressions (MDX)
In a map report item, a cylindrical map projection devised by Gerardus Mercator in 1569.
Information about the properties of data, such as the type of data in a column (numeric, text, and so on) or the length of a column; information about a file, such as its title, description, date created, and date last modified; or information about the structure of data or information that specifies the design of objects such as cubes or dimensions.
A function that performs an action by using a COM object, as in SQL-DMO, OLE DB, and ActiveX Data Objects (ADO).
The file format of an image, such as .bmp, .gif, or .jpeg.
A relationship between two or more models in which one model is dependent on the information of another model.
Multidimensional Expressions (MDX)
A syntax used for defining multidimensional objects and querying and manipulating multidimensional data.
A storage mode that uses a proprietary multidimensional structure to store a partition's facts and aggregations or a dimension.
Multiple copies of SQL Server running on the same computer.
An installation of SQL Server that is given a name to differentiate it from other named instances and from the default instance on the same computer.
In a report expression the calls an aggregate function, a value for the scope parameter that is the name of a dataset, data region, or data region group.
An expression that contains an aggregate function that calls another aggregate function.
A SELECT statement that contains one or more subqueries, or another term for subquery.
A data mining model configuration in which a column of a table contains a table.
Placing one data region inside another data region, such as a sparkline inside a table. Nested data regions are based on the same report dataset, and the scope for data in the nested data region is automatically defined by its placement in the parent data region.
An entry that has no explicitly assigned value.
Any expression that evaluates to a number.
One of the components of a database, such as a table, index, or stored procedure.
1. A unique name given to an object. 2. In Metadata Services, a unique identifier constructed from a globally unique identifier (GUID) and an internal identifier.
ODBC data source
1. The location of a set of data that can be accessed by using an ODBC driver. 2. A stored definition that contains all of the connection information that an ODBC application requires to connect to the data source.
A dynamic-link library (DLL) that an ODBC-enabled application, such as Excel, can use to access an ODBC data source.
Open Geospatial Consortium
See Other Term: online analytical processing
A COM-based application programming interface (API) for accessing data. OLE DB supports accessing data stored in any format for which an OLE DB provider is available.
OLE DB for OLAP
Formerly, the separate specification that addressed OLAP extensions to OLE DB. Beginning with OLE DB 2.0, OLAP extensions are incorporated into the OLE DB specification.
In relational databases, a relationship between two tables in which a single row in the first table can be related to one or more rows in the second table, but a row in the second table can be related only to one row in the first table.
In relational database, a relationship between two tables in which a single row in the first table can be related only to one row in the second table, and a row in the second table can be related only to one row in the first table.
online analytical processing
A technology that uses multidimensional structures to provide rapid access to data for analysis.
A sign or symbol that specifies the type of calculation to perform within an expression. There are mathematical, comparison, logical, and reference operators.
An aggregate function that specifies a scope parameter that is another aggregate function.
1. A string, typically added when the last plaintext block is short. 2. The space allotted in a cell to create or maintain a specific size.
In Report Builder, the page refers to the physical paper page. The paper size that you specify for the report controls how the report is rendered.
A set of predefined or user-defined values for colors used in charts, maps, and gauges.
A built-in global collection in a report that enables users to set values that can vary report data, appearance, and connect related reports. Report parameters are created automatically from query parameters and dataset parameters, and manually by report authors.
A published report that accepts input values through parameters.
parameterized row filter
A row filter available with merge replication that allows you to restrict the data replicated to a Subscriber based on a system function or user-defined function.
A member in the next higher level in a hierarchy that is directly related to the current member.
A rule associated with an object to regulate which users can gain access to the object and in what manner.
1. To rotate rows to columns, and columns to rows, in a crosstabular data browser. 2. To choose dimensions from the set of available dimensions in a multidimensional data structure for display in the rows and columns of a crosstabular structure.
A character or symbol that is used in place of an actual value, text, or object. The actual value that the placeholder represents is unknown or unavailable at the current time, or is not displayed for security reasons. When a simple or complex expression is defined inside a text box, the resulting representation of this expression in design view is known as a placeholder.
Data that specifies points, lines, or areas on a flat geometric plane.
In a map report item, a layer that displays spatial data as areas, for example, geographical regions such as counties.
The maximum total number of decimal digits that can be stored, both to the left and right of the decimal point.
A column or set of columns that uniquely identify all the rows in a table.
The "one" side of two related tables in a one-to-many relationship.
A mapping of data from an N-dimensional coordinate system to an (N-1)-dimensional coordinate system. For example, mapping three dimensional geographic data onto a two dimensional display surface.
A dialog box that displays information about an object in the interface.
A named attribute of a control, field, or database object that you set to define one of the object's characteristics, such as size, color, or screen location; or an aspect of its behavior, such as whether it is hidden.
A standard set of formats and procedures that enable computers to exchange information.
1. An OLE DB provider. 2. An in-process dynamic link library (DLL) that provides access to a database.
Parameters that are specified in a dataset query, such as a Transact-SQL query.
See Other Term: Report Definition Language
A group of related fields (columns) of information treated as a unit. A record is more commonly called a row in a relational database.
A report item that can be used as a container for multiple report items or as a graphical element on a report.
1. A hierarchy of data from a single report dataset that includes multiple hierarchical levels into a hierarchy structure, such as the report-to structure for manager-employee relationships in an organizational hierarchy. 2. In Master Data Services, a derived hierarchy that includes a recursive relationship. A recursive relationship exists when an entity has a domain-based attribute that is based on the entity itself.
A database or database management system that stores information in tables as rows and columns of data, and conducts searches by using the data in specified columns of one table to find additional data in another table.
relational database management system
A system that organizes data into related rows and columns.
A storage mode that uses tables in a relational database to store multidimensional structures.
1. A link between tables that references the primary key in one table to a foreign key in another table. The relationship line is represented in a database diagram by a solid line if referential integrity between the tables is enforced, or a dashed line if referential integrity is not enforced for INSERT and UPDATE transactions. The endpoints of a relationship line show a primary key symbol to denote a primary key-to-foreign key relationship, or they show an infinity symbol to denote the foreign key side of a one-to-many relationship. 2. In Metadata Services, a relationship is an association between a pair of objects, where one object is an origin and the other object is a destination. The association repeats for each subsequent pair of objects, so that the destination of one relationship becomes the origin in the next relationship. In this way, all objects in an information model are associated through a chain of relationships that extend from one object to the next throughout the information model.
A fully processed report that contains both data and layout information, in a format suitable for viewing.
A component in Reporting Services that is used to process the output format of a report.
A plug-in that renders reports to a specific format.
rendering object model
Report object model used by rendering extensions.
The .rdl file that is the XML definition of a report and that conforms to the schema reportdefinition.xsd.
Report Definition Language
A set of instructions that describe layout and query information for a report.
report execution snapshot
A report snapshot that is cached.
A collection of report snapshots that are created and saved over time.
report history snapshot
A report snapshot that appears in report history.
report intermediate format
A static report history that contains data captured at a specific point in time.
Any object, such as a text box, graphical element, or data region, that exists on a report layout.
The placement of data regions, report items, and text within a report and the applied formatting.
report layout template
A pre-designed table, matrix, or chart report template in Report Builder.
A URL to a hyperlinked report.
A metadata description of business data used for creating ad hoc reports in Report Builder.
A parameter that is defined within a report definition. All query parameters have report parameters, but report parameters can be created independent of a query.
Report items that have been published separately to a report server and that can be reused in other reports. Report items such as tables, matrices, charts, and images can be published as report parts. Report parts have an .rsc file extension and they conform to the schema componentdefinition.xsd.
report processing extension
A component in Reporting Services that is used to extend the report processing logic.
The action of combining the report layout with the data from the data source for the purpose of viewing the report.
A location on the network where the ClickOnce version of Report Builder is launched from and a report is saved, managed, and published.
report server administrator
A user with elevated privileges who can access all settings and content of a report server.
report server database
A database that provides internal storage for a report server.
report server execution account
The account under which the Report Server Web service and Report Server Windows service run.
report server folder namespace
A hierarchy that contains predefined and user-defined folders. The namespace uniquely identifies reports and other items that are stored in a report server. It provides an addressing scheme for specifying reports in a URL.
Report Server service
A Windows service that contains all the processing and management capabilities of a report server.
Report Server Web service
A Web service that hosts, processes, and delivers reports.
A static report that contains data captured at a specific point in time.
Schedule defined inline with a report.
A Web server control and Windows Form control that provides embedded report processing in ASP.NET and Windows Forms applications.
Any item in a report server database that is not a report, folder, or shared data source item.
The set of rows returned from a SELECT statement.
1. A user or group to whom a set of specific permissions are granted. 2. In Analysis Services, a role uses Windows security accounts to limit scope of access and permissions when users access databases, cubes, dimensions, and data mining models. 3. In a database mirroring session, the principal server and mirror server perform complementary principal and mirror roles. Optionally, the role of witness is performed by a third server instance.
A security policy that defines users and groups that can access specific items and perform specific operations.
A named collection of tasks that defines the operations a user can perform on a report server.
In an SQL table, a single occurrence of the object modeled by the table.
row aggregate function
A function that generates summary values, which appear as additional rows in the query results.
A filter that limits the rows to include in a dataset.
1. A column or set of columns used to distinguish any single row from every other row in the table. 2. In a heap, a pointer to the row.
A single-value field, as opposed to an aggregate.
An aggregate function, such as MIN(), MAX(), or AVG(), that is specified in a SELECT statement column list that contains only aggregate functions.
In the SQL-92 standard, a collection of database objects that are owned by a single user and form a single namespace. A namespace is a set of objects that cannot have duplicate names.
Used in multiple contexts. Scope can specify the data to use for evaluating an expression, the set of text boxes on a rendered page, or the set of report items that can be shown or hidden based on a toggle.
A collection of Transact-SQL statements used to perform an operation.
Entities that can be secured with permissions.
Secure Sockets Layer (SSL)
A proposed open standard for establishing a secure communications channel to prevent the interception of critical information, such as credit card numbers. Primarily, it enables secure electronic financial transactions on the World Wide Web, although it is designed to work on other Internet services as well.
A component in Reporting Services that authenticates a user or group to a report server.
In Windows-based computers, an account (such as a user, security group, device, or computer) that can be granted or denied access to resources.
Semantic Model Definition Language (SMDL)
A set of instructions that describe layout and query information for reports created in Report Builder.
In a chart, a series is made up of more than one data point.
An aggregate value that is calculated on the data source. Depending on the data source, server aggregates can be treated as detail data or as aggregates based on the dataset option InterpretSubtotalsAsDetails.
A name that uniquely identifies a server computer on a network.
A Service Broker object that defines a name for a specific task or set of tasks, and the contracts that other services can use to accomplish that task.
service principal name
The name by which a client uniquely identifies an instance of a service.
shared data source
A data source definition that is saved and managed as a file on a report server and can be accessed by multiple reports.
shared data source definition
The .rsd file that is the XML definition of a data source and that conforms to the schema shareddatasource.xsd.
shared dataset definition
The .rcd file that is the XML definition of a shared dataset and that conforms to the schema shareddatasetdefinition.xsd.
An expression that contains a reference to a single field and appears in the report layout in brackets, e.g. [ProductID].
A way of identifying different editions of one product; also, acronym for stock keeping unit (standard business terminology).
A subset of the data in a cube, specified by limiting one or more dimensions by members of the dimension.
A smart tag exposes key configurations directly on the design surface to enhance overall design-time productivity in Visual Studio 2005.
See Other Term: Semantic Model Definition Language (SMDL)
See Other Term: report snapshot
The set of rules in a collation that define how characters are evaluated in comparison operations, and the sequence in which they are sorted.
Data that specifies locations of objects on a flat or curved surface. Spatial data can be points, lines, or polygons.
spatial data types
Specifies data that represents geometry (planar) or geography (geodesic) information.
See Other Term: Structured Query Language (SQL)
An SQL statement, such as SELECT, INSERT, UPDATE, DELETE, or CREATE TABLE.
SQL Server Authentication
The mechanism to validate an attept to connect to an instance of SQL Server by specifying a SQL Server login ID and password.
SQL Server login
An account stored in SQL Server that allows users to connect to SQL Server.
An SQL or Transact-SQL command, such as SELECT or DELETE, that performs some action on data.
static connection string
A set of values that the report always uses to connect to the same data source each time the report runs.
A data type that contains letters, numbers, and most characters. Numbers in a String field, that is a field with a data type of String, are not available for numeric calculations. You must use a numeric data type, such as Integer or Float, to perform numeric calculations. For a parameter, String is the same as the Text data type.
Functions that perform operations on character or binary strings.
Structured Query Language (SQL)
A language used to insert, retrieve, modify, and delete data in a relational database, designed specifically for database queries.
A subreport is a control embedded inside the body of a parent report. Conceptually, a subreport is similar to a frame in a Web page that provides a container for other Web page content. The subreport is rendered inside the parent report that contains it. Both reports are processed and displayed simultaneously.
A single key that is used with symmetric encryption algorithms for both encryption and decryption.
system role assignment
Role assignment that applies to the site as a whole.
system role definition
Role definition that conveys site-wide authority.
system stored procedures
A set of SQL Server-supplied stored procedures that can be used for actions such as retrieving information from the system catalog or performing administration tasks.
1. A two-dimensional object, which consists of rows and columns, that stores data about an entity modeled in a relational database. 2. A data region on a report layout that displays data in a columnar format.
table data region
A report item on a report layout that displays data in a columnar format.
A Reporting Services RDL data region that contains rows and columns resembling a table or matrix, possibly sharing characteristics of both.
A collection of permissions that constitute a task (manage reports, manage folders, etc)
The language containing the commands used to administer instances of SQL Server, create and manage all objects in an instance of SQL Server, and to insert, retrieve, modify and delete all data in SQL Server tables. Transact-SQL is an extension of the language defined in the SQL standards published by the International Standards Organization (ISO) and the American National Standards Institute (ANSI).
An instance of SQL Server Express that is generated by the parent instance on behalf of a user.
value (y) axis
The axis for displaying numeric data values in a chart. Usually the vertical axis. Exception: in bar charts, the axes are reversed, and the y axis displays grouping data.
An expression in Multidimensional Expressions (MDX) that returns a value. Value expressions can operate on sets, tuples, members, levels, numbers, or strings.
1. In Integration Services, stores values that can be used in scripts, expressions, and property expressions to set column values and the properties of package objects. 2. Defined entities that are assigned values. A local variable is defined with a DECLARE@localvariable statement and assigned an initial value within the statement batch where it is declared with either a SELECT or SET@localvariable statement.
An option on a Reporting Services chart that can be specified to automatically calculate the optimal number of labels that can be placed on an axis, based on the chart width or height.
In maps, charts, and gauges, the way that a user chooses to visualize analytical data.
In Reporting Services, a service that uses Simple Object Access Protocol (SOAP) over HTTP and acts as a communications interface between client programs and the report server.
Windows Management Instrumentation
An interface that provides information about objects in a managed environment.
Well Known Binary data representation as specified by the Open Geospatial Consortium (OGC).
Well Known Text data representation as specified by the Open Geospatial Consortium (OGC).
See Other Term: Windows Management Instrumentation
See Other Term: category (x) axis
See Other Term: value (y) axis