Microsoft Office Tutorials and References
In Depth Information
Figure 5-52. Generate and validate the MDX query
■ if you already know how to build an MDx query, you can create and paste it in the MDx Statement window and
avoid the design step.
When you click the Finish button, the wizard imports the data and displays a success or failure notification. You
can close the window on successful confirmation. powerpivot will display the data from the MDx query. Change
the column header names (titles) to make them more logical; for instance, change Measureinternet Sales amount
to internet Sales amount.
after changing the column names, the final powerpivot data should look like what’s shown
in Figure 5-53 .
Search JabSto ::