SAP Online Help 07.09.2004
SAP NetWeaver Visual Composer: User Guide 92
4. Click Next.
Result
You proceed to the Define Filters [Page 107] screen.
Example
You want to identify the trend in unit sales for product families over the last half of the year.
To create this query, configure the values on this screen in the following manner:
This example assumes you have similar types of metadata available in your
data service.
Display section:
Trend in measure = Unit Sales
For Members of section:
Dimension = Product
Hierarchy = Product
Level = Product Family
During Date Range section:
Time dimension = Time
Hierarchy = Time
Period level = Month
From = July
To = December
The result of this query is displayed in a table similar to the below:
Trend Over Time Query Result
Product Family Jul Aug Sep Oct Nov Dec
Drink 2,205 1,921 1,939 1,898 2,344 2,419
Food 17,036 15,741 14,663 14,232 18,278 19,356
Non-Consumable 4,522 4,035 3,786 3,828 4,648 5,021
