Create the Base Report Definition

Insert the required parameters into the Report table including the XMLString created in Step 1 into the XMLData field.

Step 2

INSERTINTO [dbo].[Report] ([DisplayName], [Description], [ReportType],

 [Category], [CreatedBy], [Protected], [ShowPivot], [ShowChart], [XMLData],

 [Definition])

VALUES ('Dynamic OLAP Report', 'Dynamic OLAP Report', 1, 'Advertising', 'user',

 0, 1, 0, XMLString, "Use this report to view advertising information.")

When the above steps have been successfully completed, the report will appear in the Reports module of Commerce Server Business Desk. The next step is to run the report from Business Desk. For more information, see Business Desk Analysis.

Note

• Do not modify the XML structure after the report is initially created. Make any modifications to the report using the pivot table component in the Analysis category in Business Desk. The pivot table view and layout changes are automatically persisted in the XML for the report when it is saved.

All rights reserved.