Hi,

I have a cube in SQL Server 2000 Analysis Services with 'Time of Day'
dimension with Levels as
Hour of Day
15 Min interval
5 Min Interval

In my MDX, I need to display analysis for Morning, Afternoon and
Evening hours. Lets assume
Morning is from 8.00 a.m to 10.00 a.m
Afternoon is from 12.00 to 3.00 p.m
Evening is from 8.00 to 11.00 p.m.

Here is the MDX

with
SET [SelectedSalesDept] AS '{ [Sales Department].[standard].children
}'
SET [Morning] AS '{ [Time of Day].[Standard].[08a-09a]:[Time of
Day].[Standard].[09a-10a]}'
SELECT {[SelectedSalesDept]} on columns, {[Morning] } on rows FROM
[Sales]
where [Measures].[Sales Transactions]

It shows two members in the set on the rows correctly. What I need
instead is to display the name of the set 'Morning' as single row with
values aggregated for the members in the Set.

It would be really nice if someone can direct me in the right
direction.

Thanks,

Vinayak

Is this what you are looking for?

SET [SelectedSalesDept] AS
'{[Sales Department].[standard].children}'
SET [Morning] AS
'{[Time of Day].[Standard].[08a-09a]
:[Time of Day].[Standard].[09a-10a]}'
Member [Time of Day].[Morning] as
'Aggregate([Morning])'

SELECT [SelectedSalesDept] on columns,
{[Time of Day].[Morning]} on rows
FROM [Sales]

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi Deepak,

Thanks for the reply. That was exactly what I was looking for.

Vinayak

Deepak Puri <deepak_puri (AT) progressive (DOT) com> wrote