Is it possible to select all weeks in this time dimensions, so i don't have
to calculate weeks if I don't need to?
like this format?
[Time].[2003].[month].[week].[day]

like
[Time].[2003].[1].[*].[1]
[Time].[2003].[1].[All week].[1]

Is this what you mean (supposing Foodmart Years are your Months, and Foodmart
Quarters are your Weeks) ?

select
{[Measures].[Unit Sales]} on columns,
generate([1997].children,{time.currentmember.firstchild}) on rows
from Sales

HTH,
Brian
www.geocties.com/brianaltmann/olap.html

"Cindy Lee" wrote:

No, I have Year, month and day. But I don't have week number (I can
calculate it but don't want to)

Say 1/10/1997

[1997].[1].[week???].[10]

I can't use the date unless I put a week number.

Calculating the week number is easy, but there are other instances where I
need to use something like this.

"Brian Altmann" <findme@thesignaturewebsite> wrote

Maybe there is a more efficient way, but this shoud work (same assumptions as
before):

select
{[Measures].[Unit Sales]} on columns,
filter( descendants( [1997] ,[month]) , time.currentmember is [1] ) on
rows
from Sales

HTH,
Brian

"Cindy Lee" wrote: