Database Reference
In-Depth Information
1. In the
Solution Explorer
, click on the
ReportingFirstCube
project.
2. Right-click on the
Reports
node and choose the
Add New Report
option.
3. Click on
Next
in the wizard, choose
New data source
, and then click on the
Edit
button.
4. In the
Server name
box type
localhost
, select the
AdventureWork-
sDW2012
database, and then click on
OK
.
5. Click
Next
, type the following query in the
Query string
box:
select * from
AdventureWorksDW2012..DimProductCategory
6. Click on the
Next
button, select
Tabular
as the type, and click on
Next
.
7. Add all the columns to the
Details
field.
Search WWH ::
Custom Search