Reporting on a Custom Commerce Event

  • Article

A report for commerce events can be created through Commerce Server Business Desk by using a new cube or an SQL query. But before you can create reports for the new commerce event, you must have wishlist event data in your log files to import into the Data Warehouse. The process of adding the wish list user interface and updating ASP pages is left to the user. If you have not added the wish list functionality to your Web site, you can use the sample log files included in the procedures to see how the process will work when your site has wish list functionality in place for users.

Ee783633.note(en-US,CS.20).gif Important

  • We recommend that you do not develop a production-quality site based on the Retail2002 Site. We recommend that you use the Commerce Server 2002 Starter Site to develop a production quality site. You can download the Starter Site from https://go.microsoft.com/fwlink/?linkid=37800.

To generate sample log file data for the Retail Solution Site

To generate sample log file data for the Retail2002 - International Retail Site

To make the current log file available for reports

To create a Custom Commerce Event report based on an SQL query

To create a Custom Commerce Event report based on an OLAP cube

Ee783633.note(en-US,CS.20).gifNote

  • If you are using the Retail2002 site, or if your site is based on ASP.NET, skip to the To generate sample log file data for the Retail2002 – International Retail Site topic.

To generate sample log file data for the Retail Solution Site

  1. Click Start, point to Programs, point to Accessories, and then click Notepad.

  2. In Notepad, paste the following code:

    <%
 'An array of Commerce Events to log.
 g_rgEvents = Array( _
   "CEVT={T=WISH,EVT=ADDTOLIST,PRID=""Bike"",QTY=""1"",LN=""Wife""}", _
   "CEVT={T=WISH,EVT=ADDTOLIST,PRID=""HolidayCD"",QTY=""1""," + _ 
   "LN=""Holidays""}", _
   "CEVT={T=WISH,EVT=ADDTOLIST,PRID=""Printer"",QTY=""1""," + _ 
   "LN=""Wife""}", _
   "CEVT={T=WISH,EVT=DROPFROMLIST,PRID=""Printer"",QTY=""1""," + _ 
   "LN=""Wife""}", _
   "CEVT={T=WISH,EVT=ADDTOLIST,PRID=""JazzCD"",QTY=""1""," + _ 
   "LN=""Brother""}", _
   "CEVT={T=WISH,EVT=DROPFROMLIST,PRID=""StonewashedJeans""," + _
"QTY=""1"",LN=""Kid""}" _
   )

 'Determine if the request involves adding a new event to the log file
 If (Not vbNullString = Request.QueryString("Event")) Then
    sEventID = CLng(Request.QueryString("Event"))

   'Make sure the requested event is available
   If (Not sEventID > UBound(g_rgEvents)) Then

      'Log the event
      Call Response.AppendToLog("&")
      Call Response.AppendToLog(g_rgEvents(sEventID))

      'Get the event data to display on the page
      sEventData = g_rgEvents(sEventID) 
    End If
 End If
%>

<html>
<head>
<title>Extending Commerce Events</title>
</head>

<body>

<%
 'Dynamically render a collection of links for logging different
 'Commerce Events to the IIS log file. Note that this is required
 'because each call to Response.AppendToLog() will only log the data on
 'a single line associated with the current GET request.
 For itr = 0 to UBound(g_rgEvents)
   Call Response.Write("<a href=""SampleEventData.asp?Event=" _
& CStr(itr) & """>Log Commerce Event " & CStr(itr) & "</a><br/>")
 Next
%>

Commerce Event logged: <b><%= sEventData %></b>

</body>
</html>

  3. On the File menu, click Save As.

  4. In the Save As dialog box, in the Save In box, navigate to the root drive of your Web site, for example C:/Inetpub/wwwroot/retail, type SampleEventData.asp, and then click Save.

  5. On the File menu, click Exit.

  6. Click Start, point to Programs, and then click Internet Explorer.

  7. Navigate to the SampleEventData.asp page, for example, https://localhost/retail/SampleEventData.asp.

  8. To add each event to the log file, click each Log Commerce Event link on the page. Add as many events to the log file as you want. Adding more events to the log file means there will be more events to report on later. You can add multiple instances of the same event.

    To view the log file in which the event information was stored, open the log file for the appropriate day from the log file directory, for example, C:\WINNT\system32\LogFiles\W3SVC1.

  9. To close Internet Explorer, on the File menu, click Close.

Ee783633.note(en-US,CS.20).gifNote

  • If you are using the Retail Solution Site, or if your site is based on ASP and not ASP.NET, skip to the To make the current log file available for reports topic.

To generate sample log file data for the Retail2002 - International Retail Site

  1. Click Start, point to Programs, point to Microsoft Visual Studio .NET, and then click Microsoft Visual Studio .NET.

  2. In Visual Studio .NET, on the File menu, point to Open, and then click Projects.

  3. In the Open Project dialog box, navigate to <drive>:/Inetput/wwwroot/retail2002, select Retail2002.sln, and then click Open.

    The Retail2002 site opens in the Visual Studio .NET window.

  4. On the Project menu, click Add New Item.

  5. In the Add New Item – Retail2002 dialog box, in the Templates section, select Class, type Wishlist.vb in the Name window, and then click Open.

  6. On the Edit menu, click Select All, and then press the Delete key.

  7. Paste the following code into the Wishlist.vb page:

    Imports Microsoft.CommerceServer.Runtime

<CommerceEvent("WISH")> _
Public Class MyWishListEvent : Inherits BaseCommerceEvent

    ' Visual Basic .NET is case insensitive, 
    ' so you must make these names unique 
    ' from the public property names
    Private _myCustomValue As String
    Private _myPRID As String
    Private _myQTY As String
    Private _myLN As String
    Private _myEvent As String

    'Constructor
    Public Sub New(ByVal customValue As String)

        _myCustomValue = customValue

    End Sub

    'Body of BaseCommerceEvent.Validate() method
    Public Overrides Function Validate() As Boolean
        'noop validation
        Return True
    End Function

    'Define event properties

    <CommerceEventMember("EVT")> _
    Public Property MyEvent() As String

        Get
            Return _myEvent
        End Get

        Set(ByVal value As String)
            _myEvent = value
        End Set

    End Property

    <CommerceEventMember("PRID")> _
    Public Property MyPRID() As String

        Get
            Return _myPRID
        End Get

        Set(ByVal value As String)
            _myPRID = value
        End Set

    End Property

    <CommerceEventMember("QTY")> _
    Public Property MyQTY() As String

        Get
            Return _myQTY
        End Get

        Set(ByVal value As String)
            _myQTY = value
        End Set

    End Property

    <CommerceEventMember("LN")> _
    Public Property MyLN() As String

        Get
            Return _myLN
        End Get

        Set(ByVal value As String)
            _myLN = value
        End Set

    End Property

End Class

  8. On the Project menu, click Add New Item.

  9. In the Add New Item-Retail2002 dialog box, do the following: In the Add New Item – Retail2002 dialog box, in the Templates section, select WebForm, type Wishlist.aspx in the Name window, and then click Open.

  10. On the View menu, click HTML Source.

  11. On the Edit menu, click Select All, and then press the Delete key.

  12. Paste the following code into the Wishlist.aspx HTML page:

    <%@ Page Language="vb" AutoEventWireup="false" Codebehind="Wishlist.aspx.vb" Inherits="Microsoft.CommerceServer.Site.Wishlist"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
    <HEAD>
        <title>Wishlist</title>
        <meta name="GENERATOR" content="Microsoft Visual Studio.NET 7.0">
        <meta name="CODE_LANGUAGE" content="Visual Basic 7.0">
        <meta name="vs_defaultClientScript" content="JavaScript">
        <meta name="vs_targetSchema" content="https://schemas.microsoft.com/intellisense/ie3-2nav3-0">
    </HEAD>
    <body MS_POSITIONING="GridLayout">
        <TABLE height="297" cellSpacing="0" cellPadding="0" width="266" border="0" ms_2d_layout="TRUE">
            <TR vAlign="top">
                <TD width="266" height="297">
                    <FORM id="Form1" method="post" >
                        <TABLE height="249" cellSpacing="0" cellPadding="0" width="285" border="0" ms_2d_layout="TRUE">
                            <TR vAlign="top">
                                <TD width="56" height="32"></TD>
                                <TD width="160"></TD>
                                <TD width="69"></TD>
                            </TR>
                            <TR vAlign="top">
                                <TD height="32"></TD>
                                <TD colSpan="2">
                                    <asp:Button id="Button1"  Text="Log Commerce Event 0"></asp:Button></TD>
                            </TR>
                            <TR vAlign="top">
                                <TD height="32"></TD>
                                <TD colSpan="2">
                                    <asp:Button id="Button2"  Text="Log Commerce Event 1"></asp:Button></TD>
                            </TR>
                            <TR vAlign="top">
                                <TD height="32"></TD>
                                <TD colSpan="2">
                                    <asp:Button id="Button3"  Text="Log Commerce Event 2"></asp:Button></TD>
                            </TR>
                            <TR vAlign="top">
                                <TD height="32"></TD>
                                <TD colSpan="2">
                                    <asp:Button id="Button4"  Text="Log Commerce Event 3"></asp:Button></TD>
                            </TR>
                            <TR vAlign="top">
                                <TD height="32"></TD>
                                <TD colSpan="2">
                                    <asp:Button id="Button5"  Text="Log Commerce Event 4"></asp:Button></TD>
                            </TR>
                            <TR vAlign="top">
                                <TD height="40"></TD>
                                <TD colSpan="2">
                                    <asp:Button id="Button6"  Text="Log Commerce Event 5"></asp:Button></TD>
                            </TR>
                            <TR vAlign="top">
                                <TD height="17"></TD>
                                <TD>
                                    <asp:Label id="Label1"  Font-Size="Smaller" Font-Names="Arial">Commerce Event logged:</asp:Label></TD>
                            </TR>
                            <TR vAlign="top">
                                <TD height="17"></TD>
                                <TD>
                                    <asp:Label id="EventData"  Font-Names="Arial" Font-Size="Smaller"></asp:Label></TD>
                            </TR>
                            &nbsp;
                        </TABLE>
                    </FORM>
                </TD>
            </TR>
        </TABLE>
    </body>
</HTML>

  13. In Solution Explorer, click Show All Files button .

  14. In Solution Explorer, expand Wishlist.aspx, and then double-click the code-behind page, Wishlist.aspx.vb.

  15. On the Edit menu, click Select All, and then press the Delete key.

  16. Paste the following code into the Wishlist.aspx.vb page:

    Imports Microsoft.CommerceServer.Runtime

Public Class Wishlist
    Inherits System.Web.UI.Page
    Protected WithEvents Label1 As System.Web.UI.WebControls.Label
    Protected WithEvents Button1 As System.Web.UI.WebControls.Button
    Protected WithEvents Button3 As System.Web.UI.WebControls.Button
    Protected WithEvents Button4 As System.Web.UI.WebControls.Button
    Protected WithEvents Button5 As System.Web.UI.WebControls.Button
    Protected WithEvents Button6 As System.Web.UI.WebControls.Button
    Protected WithEvents EventData As System.Web.UI.WebControls.Label
    Protected WithEvents Button2 As System.Web.UI.WebControls.Button

#Region " Web Form Designer Generated Code "

    'This call is required by the Web Form Designer.
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

    End Sub

    Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
        'CODEGEN: This method call is required by the Web Form Designer
        'Do not modify it using the code editor.
        InitializeComponent()
    End Sub

#End Region

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'Put user code to initialize the page here
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        'Create an instance of the new Commerce Event class
        Dim cevt As MyWishListEvent
        cevt = New MyWishListEvent("My Wishlist Event")

        'Set event data
        cevt.MyEvent = "ADDTOLIST"
        cevt.MyPRID = "Bike"
        cevt.MyQTY = "1"
        cevt.MyLN = "Wife"

        'Log event data
        CommerceContext.LogCommerceEvent(cevt)

        'Output event data to the page
        EventData.Text = cevt.ToString()

    End Sub

    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        Dim cevt As MyWishListEvent

        cevt = New MyWishListEvent("My Wishlist Event")
        cevt.MyEvent = "ADDTOLIST"
        cevt.MyPRID = "HolidayCD"
        cevt.MyQTY = "1"
        cevt.MyLN = "Holidays"

        CommerceContext.LogCommerceEvent(cevt)
        EventData.Text = cevt.ToString()
    End Sub

    Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
        Dim cevt As MyWishListEvent

        cevt = New MyWishListEvent("My Wishlist Event")
        cevt.MyEvent = "ADDTOLIST"
        cevt.MyPRID = "Printer"
        cevt.MyQTY = "1"
        cevt.MyLN = "Wife"

        CommerceContext.LogCommerceEvent(cevt)
        EventData.Text = cevt.ToString()
    End Sub

    Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
        Dim cevt As MyWishListEvent

        cevt = New MyWishListEvent("My Wishlist Event")
        cevt.MyEvent = "DROPFROMLIST"
        cevt.MyPRID = "Printer"
        cevt.MyQTY = "1"
        cevt.MyLN = "Wife"

        CommerceContext.LogCommerceEvent(cevt)
        EventData.Text = cevt.ToString()
    End Sub



    Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click
        Dim cevt As MyWishListEvent

        cevt = New MyWishListEvent("My Wishlist Event")
        cevt.MyEvent = "ADDTOLIST"
        cevt.MyPRID = "JazzCD"
        cevt.MyQTY = "1"
        cevt.MyLN = "Brother"

        CommerceContext.LogCommerceEvent(cevt)
        EventData.Text = cevt.ToString()
    End Sub

    Private Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click
        Dim cevt As MyWishListEvent

        cevt = New MyWishListEvent("My Wishlist Event")
        cevt.MyEvent = "DROPFROMLIST"
        cevt.MyPRID = "Stonewashed Jeans"
        cevt.MyQTY = "1"
        cevt.MyLN = "Kid"

        CommerceContext.LogCommerceEvent(cevt)
        EventData.Text = cevt.ToString()
    End Sub
End Class

  17. In Solution Explorer, double click Web.config.

  18. Update the Commerce Event section with your new class information. Replace the contents of the Commerce Event section with the following code. Notice that the following code contains the fully-qualified assembly name for the first three entries, the original code did not:

    <commerceEvent>
<add className="Microsoft.CommerceServer.Runtime.AddItemToBasketEvent, Microsoft.CommerceServer.Runtime, Version=4.5.2002.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" loggingEnabled="true"/>
<add className="Microsoft.CommerceServer.Runtime.RemoveItemFromBasketEvent, Microsoft.CommerceServer.Runtime, Version=4.5.2002.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" loggingEnabled="true"/>
<add className="Microsoft.CommerceServer.Runtime.SubmitOrderEvent, Microsoft.CommerceServer.Runtime, Version=4.5.2002.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" loggingEnabled="true"/>
<add className="Microsoft.CommerceServer.Site.MyWishListEvent, Microsoft.CommerceServer.Retail2002" loggingEnabled="true" />
</commerceEvent>

  19. On the Build menu, click Build Solution.

    The build process may take a few minutes. The build process is complete when the following message appears on the Output tab:

    ---------------------- Done ----------------------

    Build: 10 succeeded, 0 failed, 0 skipped

  20. To close Visual Studio .NET, on the File menu, click Exit.

  21. After the project is built, click Start, point to Programs, and then click Internet Explorer.

  22. Navigate to the SampleEventData.asp page, for example, https://localhost/retail2002/Wishlist.aspx.

  23. To add each event to the log file, click each Log Commerce Event button on the page. Add as many events to the log file as you want. Adding more events to the log file means there will be more events to report on later. You can add multiple instances of the same event.

    To view the log file in which the event information was stored, open the log file for the appropriate day from the log file directory, for example, C:\WINNT\system32\LogFiles\W3SVC1.

  24. To close Internet Explorer, on the File menu, click Close.

To make the current log file available for reports

Ee783633.note(en-US,CS.20).gifNotes

  • Before creating a new report, you must run the Configuration synchronization Data Transformation Services (DTS) task, the Web server log import DTS task, and the Report preparation DTS task. For more information about running these DTS tasks, see Running the Configuration Synchronization DTS Task, Running the Web Server Log Import DTS Task, and Running the Report Preparation DTS Task, respectively.
  • All World Wide Web Consortium (W3C) log files are logged in Greenwich Mean Time (GMT), and the correction for your time zone occurs when the Web server log import DTS task is run. When running the Web server log import DTS task to import the sample event data, you will need to use the Logs by date/time range option to select the log file for the following day if the time zone for your server is not within the same day as the current time in GMT. For example, if the current time for your server is 8:00 pm on 3/1/2002, and the time in GMT is 2:00 am on 3/2/2002, the sample event data appears in the 3/2/2002 log file.
  • Before you can create a Custom Commerce Event report based on an SQL Query, you must ensure that your sample data was successfully imported into the Wishlist01 table of the Data Warehouse.

To create a Custom Commerce Event report based on an SQL Query

  1. Open the Business Desk for the site.

  2. In Business Desk, click Analysis, and then click Reports.

  3. Click New on the report toolbar to create your new report.

  4. In the Create a new report - Web Page Dialog screen, do the following:

    Use this To do this
    Report Type Select SQL.
    SQL Query Type Select * from wishlist01.

    Ee783633.note(en-US,CS.20).gif Note

    • If the PivotTable Field List does not appear automatically when you open the table, click Field List on the PivotTable toolbar to view the PivotTable Field List.

  5. Drag ProductNameCat from the PivotTable Field List and drop it into the Drop Row Fields Here box on the PivotTable.

  6. Drag Event from the PivotTable Field List and drop it into the Drop Column Fields Here box on the PivotTable.

  7. Select the Event column, click AutoCalc on the PivotTable toolbar, and then select Count from the drop-down list.

    The total number of events for each product appears in the Grand Total column in the PivotTable.

  8. On the PivotTable, click Show/Hide Details.

    The total number of times each product was added and deleted from the list appears in the addtolist and dropfromlist columns.

  9. Click Show Chart on the toolbar to view the chart.

    The chart for the data appears below the pivot table.

  10. In the New Report screen, click Save Report on the toolbar.

  11. In the Save a report—Web Page Dialog screen, do the following:

    Use this To do this
    Report Name Type the name of the new report.
    Report Category Type the report category.
    Report Description Type a description for the new report.
    Report Long Description Optional. Type a longer description for the report. This description will be visible in the browser window above the PivotTable controls when you click Show description above the PivotTable controls.

  12. Click OK.

    Ee783633.important(en-US,CS.20).gif Important

    When you save a new report, you are saving the report definition, not the data. The next time you run the report, it will have the same rows, columns, and filters, and current data will be queried from Microsoft SQL Server 2000 as specified in the report definition.

  13. On the File menu, click Close.

Ee783633.note(en-US,CS.20).gifNote

  • For more information about working with PivotTables, click Pivot Help on the PivotTable toolbar.

To create a Custom Commerce Event report based on an OLAP cube

  1. Click Start, point to Programs, point to Administrative Tools, and then click Commerce Server Manager.

  2. In Commerce Server Manager, expand the Analysis Servers node, expand the node for the local server, right-click the Data Warehouse you extended for wish list events, point to New Cube, and then click Wizard.

  3. In the Cube Wizard screen, click Next.

  4. In the Select a fact table from a data source screen, in the Data sources and tables section, select Wishlist01, and then click Next.

  5. In the Select the numeric columns that define your measures screen, in the Fact table numeric columns section, select Quantity, click the right arrow button, select Request Index, click the right arrow button, select Uri Key, click the right arrow button, select User Key, click the right arrow button, and then click Next.

  6. In the Select the dimensions for your cube screen, click New Dimension.

  7. In the Dimension Wizard screen, click Next.

  8. In the Choose how you want to create the dimension dialog box, select Star Schema: A single dimension table, and then click Next.

  9. In the Select the dimension table screen, select Wishlist01, and then click Next.

  10. In the Select the dimension type screen, select Standard dimension, and then click Next.

  11. In the Select the levels for your dimension screen, select ProductNameCat, click the right arrow button, and then click Next.

  12. In the Specify the member key columns screen, click Next.

  13. In the Select advanced options screen, click Next.

  14. In the Finish the Dimension Wizard screen, in the Dimension name box, type ProductNameCat, and then click Finish.

  15. In the Cube Wizard, in the Select the dimensions from your cube screen, click New Dimension again to create a second dimension.

  16. Repeat steps 8 through 10.

  17. In the Select the levels for your dimension screen, select Event,****click the right arrow button, and then click Next.

  18. Repeat steps 12 and 13.

  19. In the Finish the Dimension Wizard screen, in the Dimension name box, type Event, and then click Finish.

  20. In the Select the dimensions for your cube screen, click Next.

  21. In the Finish the Cube Wizard screen, in the Cube Name box, type Wishlist Activity, and then click Finish.

    The Cube Editor screen appears, displaying the schema of the Wishlist Activity cube.

  22. In the Cube Editor screen, on the File menu, click Exit.

  23. In the Tree tab of Commerce Server Manager, expand Cubes, right-click Wishlist Activity, and then click Process.

  24. In the Process a Cube dialog box, accept the defaults and click OK.

  25. In the Process dialog box, click Close.

  26. In Commerce Server Manager, expand Microsoft SQL Servers, expand SQL Server Group, expand the node for the local server, expand Databases, expand the node for the Data Warehouse that is being extended, and then click Tables.

  27. In the details pane on the right side of the screen, right-click CubeProcInfo, point to Open Table, and then click Return all rows.

    The contents of the CubeProcInfo table are displayed.

  28. In the bottom row of the CubeProcInfo table, type the following information in the Entry column of the following table for each associated column:

    Column name Entry
    CubeName Wishlist Activity
    IncEnabled 1
    IsVirtual 1
    Optimization <NULL>
    ProcessingEnabled 1
    AutoPartition 1
    FactTable dbo.Wishlist01
    ProcessingKeySource dbo.ProductNameCat
    ProcessingKey ProductNameCat
    PartitionKeySource dbo.Wishlist01
    PartitioningKey ProductNameCat
    PartitionSize <NULL>
    ProcessingPass 0

  29. To exit the CubeProcInfo table, click the close button in the upper-right corner.

  30. Before creating the report, you must run the Configuration synchronization DTS task, the Web server log import DTS task, and the Report preparation DTS task. For more information about running these tasks, see Running the Configuration Synchronization DTS Task, Running the Web Server Log Import DTS Task, and Running the Report Preparation DTS Task, respectively.

  31. Open the Business Desk for the site.

  32. In Business Desk, click Analysis, and then click Reports.

  33. Click Add on the report toolbar to create your new report.

  34. In the Create a new report - Web Page Dialog screen, do the following:

    Use this To do this
    Report Type Select OLAP.
    Cube Name Select Wishlist Activity from the drop-down list.
    MDX Query Leave blank.

    Ee783633.note(en-US,CS.20).gif Note

    • If the PivotTable Field List does not appear automatically when you open the table, click PivotTable Field List on the PivotTable toolbar to view the PivotTable Field List.

  35. Drag ProductNameCat from the PivotTable Field List and drop it into the Drop Row Fields Here box on the PivotTable.

  36. Drag Event from the PivotTable Field List and drop it into the Drop Column Fields Here box on the PivotTable.

  37. Drag Quantity from the PivotTable Field List and drop it into the Drop Totals or Detail Fields Here box on the PivotTable.

    The total number of events for each product appears in the Grand Total column in the PivotTable.

  38. Click Show Chart on the toolbar to view the chart.

    The chart for the data appears below the pivot table.

  39. On the New Report page, click Save Report on the toolbar.

  40. In the Save a report—Web Page Dialog screen, do the following:

    Use this To do this
    Report Name Type the name of the new report.
    Report Category Type the report category.
    Report Description Type a description for the new report.
    Report Long Description Optional. Type a longer description for the report. This description will be visible in the browser above the PivotTable controls when you click Show description above the PivotTable controls.

  41. Click OK.

    Ee783633.important(en-US,CS.20).gif Important

    • When you save a new report, you are saving the report definition, not the data. The next time you run the report, it will have the same rows, columns, and filters, and current data will be queried from Microsoft SQL Server 2000 Analysis Services (OLAP) as specified in the report definition.

  42. On the File menu, click Close.

Ee783633.note(en-US,CS.20).gifNote

  • For more information about working with PivotTables, click Pivot Help on the PivotTable toolbar.

See Also

Creating a New Dynamic Report Definition

Copyright © 2005 Microsoft Corporation.
All rights reserved.