Hi,
I required to view some constant values in my result set
For Example:
Stratification StartValue EndValue
SomeCalculation
$1.5-3M 3000000 1500000
$500K-1.5M 1500000 500000
$250K - $500K 500000 250000
<$250K 250000 0


I have try it but not getting sucess with following statment.
Can anybody help me to achive this.

Regards
Rahul

With
MEMBER MEASURES.CONSTANTVALUE1 AS 99999999
MEMBER MEASURES.CONSTANTVALUE2 AS 5000000
MEMBER MEASURES.CONSTANTVALUE3 AS 3000000
MEMBER MEASURES.CONSTANTVALUE4 AS 1500000
MEMBER MEASURES.CONSTANTVALUE5 AS 500000
MEMBER MEASURES.CONSTANTVALUE6 AS 250000
MEMBER MEASURES.CONSTANTVALUE7 AS 0
Set [Stratification] As
{
MEASURES.CONSTANTVALUE1,
MEASURES.CONSTANTVALUE2,
MEASURES.CONSTANTVALUE3,
MEASURES.CONSTANTVALUE4,
MEASURES.CONSTANTVALUE5,
MEASURES.CONSTANTVALUE6,
MEASURES.CONSTANTVALUE7
}
Member [Date].[Fiscal Year].[CurrentVal] As
[Stratification].CurrentMember
Member [Date].[Fiscal Year].[PreviousVal] As
[Stratification].PrevMember
Select
{[Date].[Fiscal Year].[CurrentVal],
[Date].[Fiscal Year].[PreviousVal]
} On Columns,
{[Stratification]} On Rows
From [Adventure Works];