Database Reference
In-Depth Information
new perspective includes all attributes, so every single one of them is
checked.
5. Once you are happy with your selections, save the solution.
6. To confirm the perspective works as expected, create a pivot table in Excel
using the newly defined perspective. Within Excel's data tab choose
From
Other Sources
|
From Analysis Services
, then enter the name of your Ana-
lysis Services instance. Choose your database name from the drop-down
list, then ensure the
Connect to specific cube or table
box is checked, and
you will see the list of available cubes/perspectives as shown in the following
screenshot:
Search WWH ::
Custom Search