I have a time dimension with 3 levels: year, quarter,month
now i need to group data on month no matter which year it is in. i don't
want to create another dimension. anybody can help me on this? thanks in
advance.

http://groups-beta.google.com/group/...rver.olap/msg/
a0549165137c937f
Here is a Foodmart Sales cube query that categorizes all descendants of
a product at the Brand Name level. Note that, although a Brand Name may
appear multiple times in the hierarchy, each is listed only once in the
results. This seems similar to what you are trying to do:

With Set BrandNames AS
'CreatePropertySet([Store],
Descendants([Product].CurrentM*ember,[Product].[Brand
Name]),
[Product].CurrentMember.Name)'
Select {[Unit Sales]} ON COLUMNS,
TopCount(BrandNames,10,[Measur*es].[Unit Sales]) ON ROWS
From Sales
Where [Product].[All Products].[Drink]

The "CreatePropertySet()" MDX function is not documented in BOL, but
here is a SQL Server mag article by Russ Whitney.
In it, limitations on the maximum set size are discussed:

http://www.sqlmag.com/Articles*/Inde...rticleID=16302

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***