none
MDX to get member names?

    Question

  • 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,

    Ernie

     

    Saturday, September 30, 2006 1:57 AM

Answers

  • 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