Re: mdx query stuck up

From: alex (anonymous_at_discussions.microsoft.com)
Date: 08/29/04 

Date: Sat, 28 Aug 2004 21:41:41 -0700

ya, we have an entry for every product abt its entry and
shipment dates , i just want to know the time taken to
ship the product.. i mean if the product is shipped in a
day or two or three...

i got my query as

sum(tail(nonemptycrossjoin([ship date].[week].
[suntosatday].members),1),[members].[day count])

but its displaying the output for all date ...i want it
for current date.

is there any thing i need to chg in my query ?

thanks in advance
>-----Original Message-----
>what do you mean by "shipped in 1 day" "shipped in 2
days" etc... ?
>have you the exact shipping date in your database? (not
only the week)
>
>
>"alex" <anonymous@discussions.microsoft.com> a écrit dans
le message de
>news: 05b301c48cf2$ce027ba0$a401280a@phx.gbl...
>> hi,
>>
>> I had a measure called day_count and a dimension called
>> ship date .week in which the date fields are on weekly
>> basis. the day_count measure displays the count of
>> products shipped for a particular week date. i need to
>> find the count of products shipped in one day, twodays,
3
>> days,... here i need to exclude saturdays and sundays
and
>> holidays..can any one help me how to write the
calculated
>> member for this one ? i'm dammly in need of help guys.
>> please help me
>
>
>.
>

Relevant Pages