You can format the BO Reports by using various features available. You can turn the table reports into a 2-Dimensional or 3-Dimensional charts. You can apply an Alert to show some data in a different format , based on some business rule. You can also create some prompts, which will asks user to give some input values before seeing the reports, this way they will see only filtered data. There are many similar exciting options available to enhance the reports.

There are lot of ways are there to use the conditional formatting, most of the Process flow maintains more attention in the loops, alias and contextCheers.

Catalog Manager supports command line options.

To move reports and dashboards, we need to use some general syntax using catalog manager.

e.g:

catalogmanager -online/offline

-cmd {report | replace | export}

{command line options}

In extra, by keeping it online, This will automatically open up the catalog 

manager without having the need to enter the connection details every time.

If you create an Aggregate with more than 16 characteristics, then we call that aggregate as FLAT Aggregate. When an aggregate is active then new data is not available for reporting,These aggregates are called Flat Aggregates.

Some of the standard Business Intelligence tools in the market According to there performance 

1)MICROSTRATEGY 

2)BUSINESS OBJECTS,CRYSTAL REPORTS 

3)COGNOS REPORT NET 

4)MS-OLAP SERVICES

A universe is a business-oriented mapping of the data structure found in databases: tables, columns, joins, etc. It can represent any specific application, system, or group of users. For example, a universe can relate to a department in a company such as marketing or accounting.

In the BusinessObjects User module, universes enable end users to build queries from which they can generate and perform analysis.

- SQL Server Integration Services:- Used for data transformation and creation. Used in data acquisition form a source system.

- SQL Server Analysis Services: Allows data discovery using data mining. Using business logic it supports data enhancement.

- SQL Server Reporting Services:- Used for Data presentation and distribution access. 

For any member of the company who makes decisions based on transactional systems' data. Such systems may be oriented to different levels (analysts, managers, directors, auditors, etc.), providing different kinds of information in each case.