Writing the MDX Query

  • Article

Create a standard MDX query.

Step 1

MDX Query =
"SELECT {[Measures].[Visits], [Measures].[Requests]} ON COLUMNS,
  TopCount({[Referrer].[Referrer Domain Name].members}, 100,
  [Measures].[Visits]) ON ROWSFROM [mscsWebUsage]
 WHERE ([<sitename>]) "

Copyright © 2005 Microsoft Corporation.
All rights reserved.