Business Objects Dictionary

Aggregate Awareness

The term Aggregate Awareness refers to the ability of Business Objects to select data from pre-aggregated data tables. This can result in considerable time savings in the querying process.
The use of Aggregate Awareness is covered in more detail on the Universe/Information Design course.

Alerter

The term Alerter refers to the ability of Business Objects to apply conditional formatting to the data in a block. Users can be ‘alerted’ to certain figures if they stand out from the rest. This is commonly used to create ‘traffic light’ reports.

Audit Database

The term Audit Database refers to the optional database that can be assigned to and managed by the Central Management Server. The CMS will write to the audit db at set intervals with information about the enterprise system. Each of the Enterprise server services has an audit tab that appears when displaying their properties. An admin user has the ability to switch auditing on or off for whatever services they wish.

Block Types

Break

The term Break refers to the ability of Business Objects to break a table up into smaller more understandable divisions.

This concept is covered in more detail on the Webintelligence report creation courses.

Cascading LOV

The term Cascading LOV refers to the concept that a user is able to pick a value and then be presented with a sub-set of values based on their initial choice.

The creation of cascading LOVs is covered in more detail on the Universe/Information Design course.

Central Configuration Manager

The term Central Configuration Manager (CCM) refers to the windows-only tool provided as part of a Business Intelligence Server install. It allows the user to manage and configure the server processes individually. In release three this tool was deprrecated and a great deal of its functionality removed.

Central Management Console

The term Central Management Console (CMC) refers to the web-based administration tool available from Business Objects. This tool allows admin users to create and manage all aspects of the Business Objects Enterprise Architecture.

The CMC is covered in more detail in the course ‘Administering Groups and Users’

Central Management Server

The term Central Management Server (CMS) is used to refer to the BI Enterprise process that manages the system database.

The CMS is covered in more detail in the ‘Business Objects Administering Server’ courses.

Chasm Trap

The term Chasm trap refers to a problem inherit in SQL that can occur in the Universe design stage. If not recognised and resolved a Chasm trap will result in incorrect data being returned. Depending on the amount of data being viewed this may not always be spotted.
Chasm Traps are covered in more detail in the Universe/Information Design course.

Cluster

The term Cluster refers to the ability of Business Objects BI Platform to run more than one Central Management Server. Multiple CMS services will automatically load balance all requests. In the event of a CMS failure the other remaining CMS services will carry on with no break in the service.

The concept of Cluster is covered in more detail in the ‘Managing the Enterprise Servers’ courses.

Concurrent Active Users

The term Concurrent Active Users refers to number of users who are concurrently logged on to the enterprise server and actively interacting with the system.

Connection Server

The term Connection Server refers to the server process in Business Objects BI Platform responsible for handling requests to view and edit Documents stored on the Enterprise System.

Contexts

The term Context refers to a method to resolve loops in the Universe/Information Design course.

Contexts are covered in more detail in the Universe/Information Design course.

Crosstab Table

The term Crosstab Table refers to a table style available in Webintelligence. This style re-arranges the columns and rows across two axis. Down the left runs a series of labels and similarly along the top. If you were to run along the row and down from the column header you would find the value they refer to at the intersection. Crosstab Tables is a style better known as a Pivot Table.

How Crosstab Tables are created is covered in more detail in the Web Intelligence report creation courses.

Crystal Reports Cache Server

The term Crystal Reports Cache Server refers to the server process in Business Objects that caches viewing requests for crystal reports.

Crystal Reports Explorer

The term Crystal Reports Explorer refers to a web-based application provided by Business Objects as part of an Enterprise r2/3 install. This tool age allows users to create reports, perform ad hoc queries, analyse data, and apply report formatting.

Crystal Reports Job Server

The term Crystal Reports Job Server refers to the server process in Business Objects XI r2/3 responsible for managing and processing scheduled reports.

The Crystal Reports Job Server is covered in more detail in the ‘Business Objects XI V2/3: Enterprise Administration- Administering Servers: BO and Crystal (Windows)’ courses.

Crystal Reports Processing Server

The term Crystal Reports Processing Server refers to the server process in Business Objects that processes viewing and editing requests for crystal reports.

Xcelsius

The term Xcelsius refers to the application provided by Business Objects for building dynamic dashboards and presentations.

This application is based on Adobes Flex technology which provides an API for developers to rapidly build slick, professional-looking applications that are viewed using Adobes Flash player. In its original form Xcelsius turned static data from Excel spreadsheets into dashboards and presentations filled with dynamic charts and graphics.These stand-alone ‘swf’ files could be embedded into into HTML, PDF and a number of portal systems. Business Objects bought the original company behind Xcelsius in 2005 (Infommersion) and set about integrating it into their Enterprise Server. In doing so they extended the range of data that underpinned the visualisations. The latest version has been rebranded as ‘Dashboard Design’ and has the ability to publish dashboards to HTML5

Data Integrator

The term Data Integrator refers to the tool provided by Business Objects that is used widely in the creation of Data Warehouses. Data Integrator is used to design, schedule and execute Extract, Transform and Load (ETL) jobs. Data Integrator was rebranded in 2012 as ‘Data Services’

Data Provider

The term Data Provider refers to the data structure that stores the data returned by a query. It is possible to have more than one data provider in a document. It is also possible to link them.

This concept is covered in more detail on the Webintelligence report creation courses.

Datamart

The term Datamart refers to a concept in Data Warehousing theory. A datamart can be defined in different ways. In terms of Business Objects it is best to see a datamart as a way to view a subset of a larger dataset. A Universe can be seen as a way to set up a datamart as the Universe designer can choose what data to expose the user to.

Derived Tables

The term Derived Tables refers to the ability of the Universe Designer to create a view of a table in the underlying database.

The use of derived tables is covered in more detail in the Universe/Information Design course.

Designer

The term Designer refers to the name of the BO application that is used to design the meta data layer between the database and the user.

Desktop Intelligence

The term Desktop Intelligence refers to the name of the BO application used to view, create and edit reports. It has to be installed as an application. Desktop Intelligence has the ability to view reports stored on the Enterprise Server. Desktop Intelligence was dropped from BI4 onwards.

Destination Job Server

The term Destination Job Server refers to the server process in Business Objects responsible for sending objects to different locations. It should be understood that although this is a job server it does not create any instances of the objects it processes.

Detail

The term detail refers to an object that returns information that should not make sense on its own. Whether this is the case or not depends on the Universe Designer. A post code is an example of a detail. Details were rebranded as ‘attributes’ in the new Information Design Tool.

Details are covered in more detail in the Web Intelligence report creation courses.

Dimension

The term dimension refers to an object that returns alpha-numeric data.
How to use Dimensions is covered in more detail in the Web Intelligence report creation courses.

Disaster Recovery

The term Disaster Recovery refers to the plan put into action in the event of a serious system failure, fire or natural disaster.

Drilling

The term Drilling refers to the ability of Business Objects to drill down, up, through and across data. It is a powerful concept that can be used to answer questions that normally would be difficult to do or would require multiple reports and comparisons.

This concept is covered in more detail on the Webintelligence and Desktop Intelligence report creation courses.

DSN

The acroynym DSN stands for Data Source Name. The DSN is required when setting up a connection between the Universe and the underlying database. It is the missing element that allows the Universe to ‘talk’ to the database itself.
Setting up and troubleshooting the DSN is covered in the Universe Design course.

Fan Trap

The term Fan trap refers to a problem inherit in SQL that can occur in the Universe design stage. If not recognised and resolved a Fan trap will result in incorrect data being returned. Depending on the amount of data being viewed this may not always be spotted.

Fan Traps are covered in more detail in the Universe/Information Design course.

Fault Tolerance

The term Fault Tolerance refers to ability of a system to continue processing requests in the event of a failure. To achieve this duplicate services are required to allow fail-over to occur. Due to the nature of some of the enterprise services this is not always possible.

Financial Table

The term Financial Table refers to a table style available in Webintelligence and Desktop Intelligence. A financial table is simply a horizontal table turned on its side with the column headers as row labels instead.
How Financial Table are created is covered in more detail in the Web Intelligence report creation courses.

Formula

The term Formula refers to an un-named calculation. This can be a simple as the Sum of values in a column to a complex function parsing and manipulating date values.
This concept is covered in more detail on the Webintelligence report creation courses.

Hierarchies

The term Hierarchy is used to refer to the order of a set of objects from general to detailed. For example Year can be split into Quarters which can be split into Months which can be split into Weeks.Hierarchies are in important concept in Business Objects and are used in the process of drilling into data.

Using hierarchies is covered in the Desktop and Web Intelligence courses. The creation of hierarchies is covered in more detail in the Universe design course.

Horizontal Scaling

The term Horizontal Scaling refers to the concept of improving performance by adding additional computers to an existing enterprise system. Additional server processes would then be installed on these additional computers thus improving performance.

Index Awareness

The term Index Awareness refers to the ability of Universe Designers to take advantage of the existence of Indexes on Primary Key and Foreign Key columns in a database.They can do this by making an object ‘Index Aware’. When the user uses an object in a query the resulting SQL statement is adjusted by Business Objects to try to take advantage of the underlying Index.

This is covered in more detail on the Universe/Information Design course.

Infoview

The term Infoview can be confusing. It is used to refer to the web-based reporting tool from Business Objects. Here users log onto Infoview. It is also used to refer to a level of access where users are considered Infoview users if they are only able to consume reports.

This concept is covered in more detail on the Webintelligence report creation course.

Input File Server

The term Input File Server refers to the server process in Business Objects XI r2/3 responsible for streaming objects to and from the Input file store.

Integrity

Universe designers use the ‘check integrity’ option to run a series of tests on the Universe design. Typical problems that can be highlighted are missing joins or objects defined incorrectly.

Interactive Viewer

The term Interactive Viewer refers to the ability to view documents using a special java viewer in Webintelligence. Users who view documents with the interactive viewer are able to make changes to the formatting and viewable content that are not possible using the default HTML viewer.

This concept is covered in more detail on the Webintelligence report creation course.

Java Query Panel

The term Java Query Panel refers to the java based query panel that can be used by users on Webintelligence. This is only understandable when you consider that there are other types of query panel depending on the technology available on the clients PC.
This concept is covered in more detail on the Webintelligence report creation course and on the ‘Administering Users and Groups’ course.

Level Of Aggregation

The term Level Of Aggregation refers to the amount of aggregation applied to measures when they are combined with dimension objects.
This concept is covered in more detail on the Webintelligence and Desktop Intelligence report creation courses.

Linking Universes

Linking Universes can be used to bring together Universes developed for two different purposes. The resulting ‘linked’ universe appears to be one but is in fact a combination of the two or more underlying universes.

List Of Values

In Business Objects a List Of Values(LOV) is a ‘pick list’ that can be returned to the use during some selection process. Typically this is during the query design process. The LOV is set up by the Designer. The use of LOV can be problematic. For example, if the user wants to find a ‘PO no’ and calls up the LOV only to be confronted with hundreds of thousands of records.
The Correct set up of LOV is covered the Universe/Information Design course.

Loop

A Loop is one of the fundamental issues that come up when designing a Universe. When a user submits a query to the database , Business Objects needs to generate the correct SQL to do this. If there is any ambuguity about the path the SQL should take to return the data then a ‘Loop’ will have occurred.
This is covered in more detail on the Universe Design course.

LOV Job Server

The term LOV Job Server refers to the server process in Business Objects XI r2/3 responsible for managing and processing scheduled Lists of Values for crystal reports only.

Measure

A measure is an object that returns numeric data. Measures usually return aggregated data such as the sum of sales or the number of purchase orders.

Meta Data

Meta data is often described as data about the data. The Universe is an example of a layer of description that overlays the underlying database.

Meta-Data Exchange

The term Meta-Data Exchange refers to the functionality included in the Designer Application. A typical use of the Meta-Data Exchange is to import Universe descriptions from an XML source file.
A good example would be the process of exporting the meta-data from Business Objects Data Integrator and then importing this into Designer. A Universe can be built automatically that is a mirror of the Data Warehouse.

My Infoview

The term My Infoview refers to the ability of users to customise the start page of the web based reporting tool.

This concept is covered in more detail on the Webintelligence report creation course.

ODBC

Open Database Connectivity is a protocol signed up to by the all the large database vendors.They each agreed to provide a standard method for third party vendors to connect to their database systems and to provide drivers that would allow this. So, for example, BO Designer is able to communicate with a MS Access DB through the ODBC drivers provided free of charge by Microsoft.

OLAP

The term OLAP refers to the concept of Online Analytical Processing. Business Objects allows companies to quickly retrieve and aggregate sales data. This data can be analysed and ‘sliced’ in various ways to discover trends and opportunities. Before this was possible many database companies came up with the idea of holding this pre-aggregated, historical data in a structure called an OLAP cube. The OLAPcube could then be viewed and anaylsed at leisure. A great deal of investment was made in the ability to generate and view OLAP cubes. Despite new technology overtaking the OLAP concept companies are still keen to see a return on their investment.
Viewing OLAP cubes is covered in the Administering Users and Groups/ Administering Servers courses.

OLAP Intelligence

The term ‘OLAP Intelligence’ refers to a windows-based tool provided by Business Objects to view the data within OLAP data cubes.

Outlining

The term Outlining refers to the ability of Business Objects Web Intelligence to divide a large table of data into collapsable and expandable divisions.

This concept is covered in more detail on the Web Intelligence report creation course.

Output File Server

The term Outout File Server refers to the server process in Business Objects XI r2/3 responsible for streaming instances to and from the Output file store.

Parameters

In Universe design the parameters are the fundamental settings that dictate how the Universe connects to the database, the no of records that are allowed to be returned by a query, the maximum amount of time allowed for the query and many other options.
This is covered in more detail on the Universe Design course.

Potential Users

The term Potential Users refers to the total number of users who have the ability to log on to the enterprise server.

Pre-defined conditions

The term Pre-defined conditions refers to pre-built restrictions that can be called upon by the user to restrict the data being returned by a query. The purpose of a Pre-defined condition is to hide the complexity of this operation away. For example, a user wishes to view all the records for the last 7 days of transactions. They use the objects entitled ‘last 7 days‘ oblivious to the SQL required to return this.
Using Pre-defined conditions are covered in the Web Intelligence courses. Designing them is covered in the Universe design course.

Program Job Server

The term Program Job Server refers to the server process in Business Objects XI r2/3 responsible for managing and running program job.

Projection

Projection is the term used to describe the ‘placing’ of objects together in a block of data on a report. A block of data is another way of saying a ‘table’.

Projection Aggregation

When a measure projected on a report along with other dimensions is will always display numeric values at the level of what it had been combined with. For example a table showing Year and Sales revenue will show the Sales split year by year. This is a fundamental behaviour of Business Objects but it can be controlled in different ways and can be set up wongly by the Universe Designer.
This is covered in more detail in the Universe Design course.

Prompt

The term Prompt refers to the ability of Business Objects to prompt the user for more information. This occurs during a query.
This concept is covered in more detail on the Webintelligence Intelligence report creation courses.

Public Folders

The term Public Folders refers to the shared folders in Webintelligence.
This concept is covered in more detail on the WebIntelligence report creation course.

Query

The term Query refers to the question that can be set using the Business Objects reporting tools such as Desktop Intelligence or Webintelligence. The query is created in the ‘query panel’.
The concept of the query is covered in more detail in the Webintelligence courses.

Query Panel

The term Query Panel refers to the graphical interface that allows users to easily create a question that can be submitted to the database.

The query panel is covered in more detail in the Desktop Intelligence and Webintelligence courses.

Report Application Server

The term Report Application Server refers to the server process in Business Objects XI r2/3 that processes viewing and editing requests for crystal reports. This server is used whenever the ADHTML viewer is used.

Restrictions

The term restrictions can refer to the rules that applied to the objects created in the Universe design phase. For example, a restriction can be placed on an object that it only return data for a particular department.

Restrictions can also be placed on the data being returned in a query by the user. For example they may wish to view records where the Tax Payable is greater than £200,000.00.

Scalability

The term Scalability refers to the capacity to address additional system loads without fundamentally altering the system architecture or design. Scaling can be Vertical or Horizontal.

Scheduling

The term Scheduling refers to the ability in Business Objects Webintelligence to schedule a document to run at a particular time.

This concept is covered in more detail on the Webintelligence report creation course and on the ‘Adminstering Users and Groups’ course.

Schema

The word Schema refers to the display of tables and joins that appear in the Designer window.

Scope Of Analysis

The term Scope Of Analysis refers to how far the user wishes to drill into the data.

This use of the Scope Of Analysis is covered in more detail in the Web Intelligence courses.

Section

The term Section refers to the ability of Business Objects to break up large tables into more fundamental divisions. This is similar to breaks but is far more powerful.

This concept is covered in more detail on the Webintelligence Intelligence report creation courses.

Security Access Level

This is a hangover from the early days of Universe Design when this method was the only method of securing your Universe. Users are assigned a security level by the Administrator and objects are assigned a security level by the Designer. Whether a user is able to view an object depends on the correspondance between the security levels.

This is covered in detail on the Universe Design course.

Select Aggregation

When a query is converted into SQL the data returned by the database is at a basic level we call ‘Select Aggregation’.

Select Aggregation is covered in more detail in the Universe Design course.

Semantic Layer

The term Semantic Layer refers to the concept of placing a ‘layer of meaning’ between the data and the user. Users can view the data through the semantic layer and doing so have the complexity cut away.

This concept is covered in more detail on the Web Intelligence report creation courses.

Simultaneous Requests

The term Simultaneous Requests refers to number of actions carried out by the Concurrent Active Users at the same time.

SQL

Structured Query Language is used to communicate with a database. Over the years the functions of SQL have been extended from the intial ability to query tables for records to creating users and much more advanced DBA-type functions. In Business Objects the query set up by a user is translated into SQL before being passed to the target database.

Table-based Hierarchies

The term Table-based Hierarchies refers to the process of setting up a table in the underlying database to return a dba-defined hierarchy. The most common example of this is a time-based hierarchy defining the companies financial year, quarters etc…

The use of Table-based Time Hierarchies is covered in more detail in the Universe Design course.

Thin Client

The term Thin Client refers to the behaviour of the Web Application Server (WAS) that renders a document to a Webintelligence user. Here the WAS does not convert the document into some form of HTML and instead passes it in its native format to a viewer that has to be installed on the clients browser.

Tomcat

The term Tomcat refers to the Web Application Server (WAS) provided by default in Business Objects. Amongst other things the WAS is responsible for rendering reports into HTML for viewing purposes.

Universe

The term Universe refers to the layer that Business Objects places between the user and the database. This layer is often referred to the ‘meta-data’ layer or ‘semantic layer’. The concept of placing some intervening layer between users and their data is not unique to Business Objects but it has to be admitted that, to date, theirs is the most successful implementation of this concept.

Variable

The term Variable refers to a named calculation. As a named calculation the variable can be used more than once in a document and can be referred to in other calculations by name.

This concept is covered in more detail on the Webintelligence report creation courses.

Vertical Scaling

The term Vertical Scaling refers to the concept of improving performance by adding hardware such as extra memory to an enterprise server.

Webintelligence

Webintelligence is the web-based reporting tool provided by Business Objects. It is accessed through a web browser and does not need to be installed on the clients PC.

Workspace Panel

The term Workspace Panel refers to the area in Webintelligence that displays the report data.

The Workspace panel is covered in more detail in the Webintelligence Report Creation course.

Xcelsius

The term Xcelsius refers to the application better known as Crystal Xcelsius. This application is based on Adobes Flex technology which provides an API for developers to rapidly build slick, professional-looking applications that are viewed using Adobes Flash player. In its original form Xcelsius turned static data from Excel spreadsheets into dashboards and presentations filled with dynamic charts and graphics.These stand-alone ‘swf’ files could be embedded into into HTML, PDF and a number of portal systems. Business Objects bought the original company behind Xcelsius in 2005 (Infommersion) and set about integrating it into their Enterprise Server. In doing so they extended the range of data that underpinned the visualisations.

Zero Client

The term Zero Client refers to the behaviour of the Web Application Server (WAS) that renders a document to a Webintelligence user. If the WAS has to convert the document into some form of HTML then the clients PC need do no work to display this document.

Download our 2016 Business Intelligence Training Course

Eyecademy is a leading UK Business Intelligence Training consultancy.  Download our current training course list and contact us on 0844 335 0345 for further information.