Microsoft Office Tutorials and References
In Depth Information
Click the edit button. in the Connection properties window, enter the Server name, and then
choose or enter a database name in the “Connect to a database” area. For this example,
choose adventure Works DW 2012 as your database.
Click the advanced button if you need to configure security options, such as integrated
security or extended advanced options. return to the Connection properties window by
clicking oK.
verify the connection by clicking on test Connection, and then click oK.
When you return to the “Select the Data Source” window, click next to continue.
in the “Design the Query” window, click the Query Builder button. then in the Query Designer
window, from the Measure group drop-down list, select internet Sales.
expand Measures, and select internet Sales internet Sales amount. Drag and drop internet
Sales amount to the grid pane.
expand the Date dimension and open the Fiscal folder. Select Date.Fiscal year, and drag and
drop it to the Dimension grid pane. Under Filter expression, select all periods and click oK.
expand the product dimension, and drag and drop the attributes Category, Subcategory, and
product onto the grid pane. Your final Query Designer window should look like Figure 3-5 .
Search JabSto ::

Custom Search