Database Reference
In-Depth Information
Step 2: Set Up the Returns by Product Query
The report will start with a query that works with the three regular dimensions: Time, Products,
and Return Reason. After the dimensions are built, the measure is added to the query.
1.
In the
Explorer Bar
, mouse over the
Query Explorer
tab and select the
Queries
folder.
2.
Rename
Query1
to
Product_Returns_by_Product
.
3.
In the work area, double-click the query to open the query definition.
4.
From the
To o l b o x
tab of the
Insertable Objects
pane, drag a
Data Item
object into the
Data Items
pane of the work area.
The Data Item Expression dialog box is displayed.
5.
In the
Av a i l a b l e C o m p o n e n t s
pane, expand the
Time
dimension within the
Returned
items
namespace.
6.
Drag the
Time
hierarchy from the
Av a i l a b l e C o m p o n e n t s
pane into the
Expression
Definition
pane.
7.
In the
Expression Definition
pane, add
->?Selected Time?
after the hierarchy.
The Expression should be this:
[Returned items].[Time].[Time]->?Selected Time?
8.
Click
Va l i d a t e
and then
OK
if there are no errors.
9.
In the
Properties
pane, change the
Name
property to
Time
and change the
Aggregate
Function
property to
None
.
10.
In the
To o l b o x
tab of the
Av a i l a b l e C o m p o n e n t s
pane, drag a
Data Item
object into the
Data Items
pane.
The Data Item Expression dialog box is displayed.
11.
In the
Expression Definition
pane, type the following function:
descendants ( [Time], 1 )
This function shows all the members that are one level below the select Time dimension
member.
12.
Click
Va l i d a t e
and
OK
if the validation returned no errors.
13.
In the
Properties
pane, change the
Name
property to
Time Group
, and change the
Aggregate Function
property to
None
.
With the time periods selected, you will add the product details below the selected prod-
uct information.
14.
In the
To o l b o x
tab of the
Av a i l a b l e C o m p o n e n t s
pane, drag a
Data Item
object into the
Data Items
pane.
The Data Item Expression dialog box is displayed.