May 20, 2010 at 6:34 am
I am trying to follow the following steps to create a data source using SQL Server Business Intelligence Development Studio. When I get to the second step is tells me to right click on data source views...problem being I don't see that anywhere for me to click on. Any help?? All I have on the solution explorer tab are 2 folders, the first called shared data sources and the second is Reports. I don't see a folder for data source views.
"Right-click on Data Sources and select Add New Data Source. Use the Add New Data Source Wizard to add a connection to the local copy of the AdventureWorks database.
Right-click on Data Source Views and select Add New Data Source View. Use the Data Source View Wizard to add a view based on the Adventure Works data source.
In the Data Source View Wizard, select the Production.Products and Sales.SalesOrderDetail tables, then click the Add Related Tables button to bring in the Sales.SalesOrderHeader and Sales.SpecialOfferProduct tables.
Right-click the Report Models node and select Add New Report Model. In the Report Model Wizard, select the Adventure Works data source view and click Next. The next step is to select the rules that will be used to generate the report model, as shown in Figure 1. I used the default rules. It's these rules that create the entities that will be available to end users for reporting.
Click Next, choose to update the database statistics, and click Next again to finish the Wizard and build the report model. "
May 20, 2010 at 7:38 am
Are you trying to build a SSRS or a SSAS solution?
What you are seeing, Shared Data Source + Reports is SSRS.
What the instructions are saying Data Sources + Data Source views are used in SSAS.
So possibly you selected the worng type of project in the start screen.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply