hai all
i want a query for the above subject which
analyse the unit sales of products which are increasing for the last four
(or) months

can anyone help me?

This query for the Foodmart Sales cube lists all Product Subcategories
whose unit sales are rising in the last 4 months of 1997 (ie. in each of
Sep-Dec):

'Sgn([Measures].[Unit Sales] -
([Measures].[Unit Sales], [Time].PrevMember))'
Member [Measures].[4MonthTrend] as
'Sum(LastPeriods(4,[Time].CurrentMember),
[Measures].[SalesTrend])'

Select {[Time].[1997].[Q3].[8]:
[Time].[1997].[Q4].[12]} on columns,
Filter([Product].[Product Subcategory].Members,
([Measures].[4MonthTrend],
[Time].[1997].[Q4].[12]) = 4) on rows
from Sales
where ([Measures].[Unit Sales])


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Hi ,

I couldn't get the hang of
==================================
'Sgn([Measures].[Unit Sales] -
([Measures].[Unit Sales], [Time].PrevMember))

==================================

and what is that the filter is working on
[Time].[1997].[Q4].[12]) = 4)

Please explain for understanding it better

Hi ,

I couldn't get the hang of
==================================
'Sgn([Measures].[Unit Sales] -
([Measures].[Unit Sales], [Time].PrevMember))

==================================

and what is that the filter is working on
[Time].[1997].[Q4].[12]) = 4)

Please explain for understanding it better

From the VBA Language Reference:

Description

Returns a Variant (Integer) indicating the sign of a number.

Syntax

Sgn(number)

The required number argument can be any valid numeric expression.

Return Values

If number is
Sgn returns

Greater than zero
1

Equal to zero
0

Less than zero
–1
...
So Sgn() returns +1 whenever current sales > prev sales. The filter
selects products for which the sum is 4 for 4 months, ie. Sgn() returns
+1 for each of last 4 periods.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***