Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Is there a MDX function for this?

4 views
Skip to first unread message

Immy

unread,
Aug 16, 2006, 3:10:24 PM8/16/06
to
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é

unread,
Aug 18, 2006, 12:55:06 PM8/18/06
to
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

unread,
Aug 19, 2006, 12:53:14 PM8/19/06
to
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

0 new messages