Hi,
I got the answer for Yesterdays query thanks Deepak

Can you please help me in getting seven days of data for the current
week

Please find the query

Please note [Time].[JC] is the time hierarchy

Select
member measures.[Production In Tons] AS '[Measures].[Production Qty In
Tons]' on columns,
{([Time].[JC].Currentmember.children)} on rows
from [Product Dispatch Compliance]
WHERE [Time].[JC].[JC Week].[wk46.2003]

i want this query to display ,their is syntax error in this query.I
could not understand.
Seven days of this week with measure value

Regards
Prasanna
Please reply

Hi,

the problem is that you refer to an axis dimension in the where-clause. This
doesn't work "by design" in MDX. A possible solution could be to let the
user select a week somewhere "outisde" of the query, or select a certain day
and then build a set for the last seven days by using the .Lag()-function.

HTH,
Matthias

"Prasanna" <tawargerip (AT) hotmail (DOT) com> schrieb im Newsbeitrag
news:d4b0bad7.0401060235.484d03d3 (AT) posting (DOT) google.com...