A SERVICE OF

logo

Open as PDF
next previous
SAP Online Help 07.09.2004
SAP NetWeaver Visual Composer: User Guide 95
3. Click Next.
Result
You proceed to the Define Filters [Page 107] screen.
Example
You want to know which products did not sell at all in January. 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 Members Of section:
• Dimension = Product
• Hierarchy = Product
• Level = Product Name
• Based on the measure = Store Sales
With No Activity For section:
• Time dimension = Time
• Hierarchy = Time
• Period level = Month
• From = January
• To = January
The result of this query is a simple table such as the following:
Zero Activity Query Result
Product
Portsmouth Imported Beer
Top Measure Imported Beer
Fabulous Apple Drink
Great Cranberry Muffins
Great Muffins
...