Adding the SQL Report Dimensions

  • Article

Create the displayable report dimensions using a set of INSERT statements in the ReportDimension table.

Specify the fields to display and the dimension type (column, row, or measure). Fields that are specified in the SELECT statement but are not inserted into the ReportDimension table can be exported, but not displayed.

For more information about the ReportDimension table, see Analysis/Reporting Schema.

Step 4

INSERT INTO [dbo].[ReportDimension] ([ReportID], [DimensionType],
 [DisplayName], [FieldName], [Ordinal]) 
VALUES (@ReportID, 0, 'Email', 'rcp_email', 1)
INSERT INTO [dbo].[ReportDimension] ([ReportID], [DimensionType],
 [DisplayName], [FieldName], [Ordinal]) 
VALUES (@ReportID, 0, 'UserId', 'rcp_guid', 2)

INSERT INTO [dbo].[ReportDimension] ([ReportID], [DimensionType],
 [DisplayName], [FieldName], [Ordinal]) 
VALUES (@ReportID, 0, 'FirstName', 'FirstName', 3)

INSERT INTO [dbo].[ReportDimension] ([ReportID], [DimensionType],
 [DisplayName], [FieldName], [Ordinal]) 
VALUES (@ReportID, 0, 'LastName', 'LastName', 4)

INSERT INTO [dbo].[ReportDimension] ([ReportID], [DimensionType],
 [DisplayName], [FieldName], [Ordinal]) 
VALUES (@ReportID, 0, 'DateCreated', 'DateCreated', 5)

INSERT INTO [dbo].[ReportDimension] ([ReportID], [DimensionType],
 [DisplayName], [FieldName], [Ordinal]) 
VALUES (@ReportID, 0, 'DateRegistered', 'DateRegistered', 6)

Copyright © 2005 Microsoft Corporation.
All rights reserved.