Creating the MDX Base Report Definition

  • Article

Create the base report definition using a set of INSERT statements into the Report table. The MDX query created in Step 2 is inserted into the [Query] field.

The ReportType is set to Static_MDX (3). The Protected bit is cleared (set to 0) which allows the report to be overwritten or deleted.

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

Step 3

-- ReportType
Declare @Static_MDX tinyint
Select @Static_MDX = 3

DECLARE @ReportID int
DECLARE @ReportStatusID int
INSERT INTO [dbo].[Report] ([DisplayName], [Description], [ReportType],
 [Category], [Query], [CreatedBy], [Protected], [Definition]) 
VALUES ('Visits by Referrer', 'Visits by Referrer', @Static_MDX, 
'Web Usage', MDX Query, ''Report Creator'', 0, 
'Long report description goes here')
SELECT @ReportID = @@identity

Copyright © 2005 Microsoft Corporation.
All rights reserved.