Databases Reference
In-Depth Information
Level=Pkt
Privacy;Auto Synch Period=20000;Default
Isolation Mode=0;Default MDX Visual
Mode=0;MDX Compatibility=0;MDX Unique Name
Style=0;Non Empty
Threshold=0;SQLQueryMode=Calculated;Safety
Options=1;Secured Cell Value=0;SQL
Compatibility=0;Compression Level=0;Real Time
Olap=False;Packet Size=4096
CommandText
=Direct Sales
The details of the connection to Analysis Server are represented by
the name Connection= and the CommandText contains the name of
the cube or perspective you chose.
10. Click OK to dismiss Choose Data Source and then Next on the res-
ulting page. What appears is the final step of the Pivot Table Wizard.
You need to specify if you want the pivot table to be formed in a new
worksheet or existing working sheet (the default value) at a specific
location. Select the default value as shown in
Figure 15-8
and click
Finish.
Figure 15-8
You will now see the pivot table created within the existing worksheet as
shown in
Figure 15-9
. There is a window called the Pivot Table that contains
the various options that can be set for the pivot table. Another window called
PivotTable Field List shows the list of hierarchies and measures from the se-
lected cube, all of which is the data that can be analyzed. Finally you have
Search WWH ::
Custom Search