The steps to create a report based on data in Bam infrastructure is no different from what one would do for other SQL data sources. It is recommended that you read the “Creating a Report with Report Designer” section in SQL Server 2005 Books Online on how to create a report using the Microsoft SQL Server Report Designer. 

Report Wizard

“Select a data source” page

Bam provides two data sources that Reporting Services may point to:

1.                  Bam Primary Import database for views on activity instances or real-time aggregations. Make sure to select Type=”Microsoft SQL Server” and Connection String=”Data Source=<server name>; Initial Catalog=<database name>”, where <server name> and <database name> are the server and database names of your Bam Primary Import database.

2.                  Bam Analysis database for querying the analysis cube. Make sure to select Type=”Microsoft SQL Server Analysis Server” and Connection String=”Data Source=<server name>; Initial Catalog=<database name>”, where <server name> and <database name> are the server and database names of your Bam Analysis database.                                        

“Design the Query” page

For the Bam Primary Import database, there are two types of views:

1.                  dbo.bam_<view name>_<activity name>View_View. This is the view for instance data.

2.                  dbo.bam_<view name>_<real time aggregation pivot table name>_RTAView. This is the view for the real-time aggregations.

You can type in “select * from view” to return the desired result set.

For the Bam Analysis database, click on the query builder and drag and drop the dimensions and measures of the cube named <view name>  to return the desired result set.                      

Other steps

Go through the rest of the steps to decide what and how you want the data to be presented.