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

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 (AT) discussions (DOT) microsoft.com> a écrit dans le message de
news: 05b301c48cf2$ce027ba0$a401280a (AT) phx (DOT) gbl...

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

the easy way :
create a new dimension called "delivery delay" which contains the number of
days
map this dimension to your "Nb of Day" column.

now you can see your time dimension and the delivery delay dimension, just
put your "nb of products" and you'll have the number of products delivered
in 1 day for a specific week (or in a month)....

I hope this can help you.


"alex" <anonymous (AT) discussions (DOT) microsoft.com> a écrit dans le message de
news: 222401c48d82$7ab5dba0$a301280a (AT) phx (DOT) gbl...
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