Database Reference
In-Depth Information
•
Campaign
into
Analysis variable 1
•
Order number
into
Cases variable
The chi-square test involves a second variable to compare the frequency of the orders as
well as tracking the count of the order transactions.
22.
From the
Source
tab in the
Insertable Objects
pane, expand the
Order method
dimen-
sion and the
Order method
hierarchy within the
Sales
namespace.
23.
Drag the
Order method type
level into the
Analysis variable 2
in the work area.
For the last variable, we want to count the number of orders (with a gross profit) as our
measure.
24.
From the
To o l b o x
tab of the
Insertable Objects
pane, drag a
Query Calculation
into
the
Counts variable
in the work area.
The Create Calculation dialog box is displayed.
25.
Type
Order count
in the
Name
text box.
26.
Select the
Calculated measure
radio button.
27.
Click the drop-down list for
Measure Dimension
and select
Sales fact
below the
Sales
namespace.
28.
Click
OK
to close the dialog box.
The Calculated Measure Expression dialog box is displayed.
29.
Create the following expression in the
Expression Definition
pane:
count( [Gross profit] )
30.
Click
OK
to close the dialog box.
31.
From the
Run
menu, select
Run Report - HTML
to compare the dashboard to that
shown in Figure 6.51. When prompted, select members
2004
,
Camping Equipment
,
and
Asia Pacific
, along with the Two-Way Chi-Square Test.
The first piece, the crosstabulation, shows the relative percentage of the order method sales
for each campaign. The Canyon Mule campaign seemed to have an exceptional number of
web and fax orders. The chi-square test results are looking for a pattern of exceptional
order methods for a promotion. The chi-square test shows that the numbers in the crosstab-
ulation are not significantly different. If the company wants to continue the Canyon Mule
campaign, marketers may want to focus on these order methods to increase orders.
32.
Close
IBM Cognos Viewer
to return to your query design.
In addition to looking at different statistics reports, we created reports with new back-
ground formatting and used conditional rendering to display only the selected report pages.