MDX to get member names?


  • I want to get a list of member name for an attribute, without accessing the fact table, for speed.

    I can write a statement like "select {Measures.SalesAmount} on columns, {CostCenter.Members} on rows from MyCube", which will give me a list of Cost Centers going down.  Is there a way to get this same list, but without accessing the fact table, with the hopes that the query will execute faster?

    Thanks for any assistance,



    Saturday, September 30, 2006 1:57 AM


  • Assume the CostCenter attribute belongs to the dimension [CCDim]


    select CostCenter.members on rows

    from [$CCDim]


    Saturday, September 30, 2006 5:40 AM

All replies