Re: time dimension - Urgent -
06-09-2005
, 10:17 AM
Something like this example against Foodmart 2000 would do the job...
with member [Time].[My Time] as
'sum([Time].[1997].[Q1].[1]:[Time].[1997].[Q3].[7])'
select
{
[Measures].Members
} on columns,
{
[Gender].Members
} on rows
from Sales
where ([Time].[My Time])
Notice the ":" operator allows you to specify a range of values. Also
Notice that placing the calculated member on a dimension other than
Measures (in this case the Time dimension) allows it to slice across
Measures affecting each measure. |