Share via

Adding the MDX Report Definitions

  • Article

Add the MDX report definitions to the query.

Step 4

-- Dimension and measure types
Declare @RowDim tinyint
Declare @Measure tinyint
Select @RowDim = 1
Select @Measure = 2

-- Add report dimensions
Insert Into [dbo].[ReportDimension] ([ReportID], [DimensionType], [DisplayName], [Ordinal]) 
Values (@ReportID, @RowDim, N'Referrer Domain Name', 1)
Insert Into [dbo].[ReportDimension] ([ReportID], [DimensionType], [DisplayName], [Ordinal]) 
Values (@ReportID, @Measure, N'Visits', 1)
Insert Into [dbo].[ReportDimension] ([ReportID], [DimensionType], [DisplayName], [Ordinal]) 
Values (@ReportID, @Measure, N'Requests', 2)

Copyright © 2005 Microsoft Corporation.
All rights reserved.