Greetings,

Can anybody please give me an MDX example to access the
properties of a level within a dimension. Heres the
scenario. I have a dimension that D1 that has two levels
L1 and L2. L2 has a member property P1. I want to access
this property in the MDX.

I'm trying to run this but its throwin an error

select non empty [D1].[L1].children DIMENSION PROPERTIES
[D1].[L2].P1 on columns, .....
from Cube1

Any help wud be greatly appreciated

Thanx,
Karthik

select non empty [d1].[l1].children DIMENSION PROPERTIES
[d1].[l2].[p1] on columns, non empty ... on rows from
Cube1