Business View Manager
The Business View Manager allows you to simplify data access for report designers by insulating them from the raw data structures.
We can build connections to multiple data sources, join tables, alias field names, create calculated fields, and then surface this simplified structure as a Business View in Crystal Enterprise.
Business Views helps administrators to pull data together from different sources. Data Connections can be integrated into a Data Foundation. Once the Data Foundation is built, Business Elements can be created and combined into a Business View.
Steps involved in creating a Business View using Business View Manager
- Data Connection
- Data Foundation
- Business Element
- Business View
Components in Business View Manager
The Data Connection object merely is a connection to the database, and individual database elements, such as tables and views, are chosen and linked when you later include the Data Connection in a Data Foundation.
A Data Foundation is a collection of one or more tables, stored procedures, views, SQL Commands, and so forth, which make up a single set of available data. Furthermore, additional data in the form of formulas and SQL Expressions can be added to a Data Foundation.
The Business Element object within your overall Business View allows you to organize your data to your liking. A Business Element is simply a smaller set of fields from an underlying Data Foundation. Business Elements determine what set of “virtual tables” ultimately appear in Crystal Reports when a report designer makes use of your Business View.
The ultimate goal of the entire Business View design process is the actual Business View object itself. This is the only object that will appear when you connect to the repository with Crystal Reports. This object is what exposes the set of virtual tables to the report designer, including all row and column security, renamed fields, and so forth.
Working with Business View Manager
Once you’ve installed the Business View Manager, start it by choosing the appropriate choice from the appropriate program group after clicking Start.
· The Business View Manager will appear, with an initial dialog box requesting you to log on to BusinessObjects Enterprise with a valid BOE Central Management Server name, user ID, password, and authentication type in order to create or modify Business Views.
Establishing a Data Connection
On Logon, the Business View Manager window appears which shows the various elements
· Select the “Data Connection” and click on “create”:
· Choose the Data source from the list of available Data sources and provide the credentials to establish the connection.
Creating the Data Foundation
· Once the connection to Database is established, the next step is to create the Data Foundation.
Go to File –> New –> Data Foundation
• Select the connection created earlier and click on “OK”.
• Select “Add Command” and click on “Add” to add the query in Data Foundation as shown:
· Insert the query in “Create a New Command” dialogue box.
- To create a parameter, click on “create” and provide the details like “Name, Prompting Text and its Data type”.
- Click on the save icon on the menu bar and select the folder to save it.
Creating the Business Element
· Once the Data Foundation is ready, we can proceed to the next step of creating the Business Element.
Go to File –> New –> Business Element
- Select the particular folder where the Data Foundation is located and expand it to select the Data Foundation and click on “OK”.
- The tables available under that Data Foundation will be listed as shown.
Expand the table(s) to add the columns into the Business Element. Select all the columns using the Shift Key and click on “Add”.
Creating the Business View
Once the Business Element is created, the final step is to create the Business View.
Go to File –> New –> Business View
- Select the Business Element(s) and click on “Add.
- The Business Element selected will appear as below:
· To save the Business View created, click on “Save” button which is on the menu bar and select the appropriate folder and then click on “save” button.
Report designers can then connect to Crystal Enterprise and use the Business View as the basis for their report, rather than accessing the data directly and building their own queries.