Is there a MDX function for this?

[Immy]

Hi all,

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

[Jéjé]

what's appends in this case?

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...

[ZULFIQAR SYED]

Here is one way of doing some thing similar to this.

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

HTTP://ZULFIQAR.TYPEPAD.COM