I want to simply take a value that is returned in my fact table for a
measure and copy is across all cells for that measure.
Current result
Date Measure
1/1/06 0
2/1/06 0
3/1/06 100 -- there will only ever be 1 value for any day
4/1/06 0
Desired result
Date Measure
1/1/06 100
2/1/06 100
3/1/06 100 -- just copy this value to all cells and allow it to
roll up to 400 when drilled up.
4/1/06 100
Regards
Immy
Date Measure
1/1/06 0
2/1/06 200
3/1/06 0
4/1/06 100
5/1/6 0
what is your value for the day with 0?
do you use AS2000 or 2005?
"Immy" <thereala...@hotmail.com> wrote in message
news:%23dQpheW...@TK2MSFTNGP02.phx.gbl...
with
member measures.x as
(
[Measures].[Reseller Order Count],
[Date].[Calendar].currentmember.parent.firstchild
)
select
{
[Measures].[Reseller Order Count]
, measures.x
}
on 0
,
[Date].[Calendar].[Calendar Quarter]
.&[2003]&[1]
.children
on 1
from
[Adventure Works]
HTH..
ZULFIQAR SYED