| mansoorak77@gmail.com 2005-08-30, 11:25 am |
| I am using following MDX query to find out the Trend of the measure
values. If it is upward then TrendUp.gif, if down Trenddown.gif and if
equal then Trendequal.gif.
If the ISDN Level is restricted for a user, it is showing all
Trenddown.gif. How can i handle it?
With MEMBER [Measures].[-Sales ValueTrend] AS 'IIF(
Coalesceempty(Measur
es.[
Sales Value], 0) > Coalesceempty(([Time].CurrentMember.PrevMember,
Measures.[Sal
es Value]), 0),"<img src=images\TrendUp.gif>", IIF(
Coalesceempty(Measur
es.[Sal
es Value], 0) = COalesceempty(([Time].CurrentMember.PrevMember,
Measures.[Sales
Value]), 0), "<img src=images\TrendEqua
l.gif>", "<img
src=images\TrendDown
.gif>"
))' SELECT { CrossJoin({[Product].[Product
Type].[ISDN],[Product].[Product Ty
pe].[Package],[Product].[Product Type].[Scratch
Card]},{Measures.[-Sales ValueTr
end]})} ON COLUMNS, {{[Time].[Year].MEMBERS}} ON ROWS
FROM [Sales] CELL PROPERTI
ES [VALUE],& #91;FORMATTED_VALUE]
,[CELL_ORDINAL]
|