The business view manager allow you to create a semantic layer composed of different business elements that could be represented by tables in different data sources (Ex: Oracle, DB2,SQL Server) and after that use this semantic layer to build Crystal Report Reports, In this post we’ll see how to create Data Connection, Business View and Business Elements objects.
To use the Business View Manager you need to install the SAP BusinessObjects BI Platform Client Tools.
To create our Business View we need to open the Business View Manager and log on.
Now we need to create a data connection, select Data Connection and click Create
Now choose the way you want to connect to the data source, in this case I’m going to select OLE DB (ADO)
Now we need to select the Provider we are going to use and click next.
Indicate the properties of the connection, SQL Instance, user, password and data base. I’m using the data base example Adventure Works DW that you can download from codeplex.
Once the Data Foundation has been created we need to create the Business Elements. In the menu select File> New> Business Element.
Now we need to save the Business Element.The last object we need to create is the Business View that will be composed for different Business elements. To create the Business View go to the menu and select File> New> Business View.
Now select the Business Elements that you want to insert.