Home Forums Data Warehousing Analysis Services MDX: Why is MDX so much slower than getting the ALL data from the cube? RE: MDX: Why is MDX so much slower than getting the ALL data from the cube?

  • Try

    SELECT

    NON EMPTY{

    {[Measures].MEMBERS} *

    {[DIMLINEOFBUS].[LINEOFBUSTYPE].&[Commercial],

    [DIMLINEOFBUS].[LINEOFBUSTYPE].&[Auto],

    [DIMLINEOFBUS].[LINEOFBUSTYPE].&[Residential]}

    ON COLUMNS,

    NON EMPTY {

    {[Dim Geographic].[COUNTYNAME].[All].children} *

    {[Dim Geographic].[CITY].[All].children} *

    {[Dim Geographic].[POSTALCODE].[All].children} *

    {[Dim Geographic].[LOCATIONID][All].children}

    } ON ROWS

    FROM (select [Dim Geographic].[Policy].[STATECODE].&[27] on columns from [Cube]);

    Do you need all the measures?

    In addition have you set the attribute relationships correctly on the Geography hierarchy? Below is a link to this

    http://www.bidn.com/blogs/DevinKnight/ssis/1099/ssas-defining-attribute-relationships-in-2005-and-2008

    There is no time selected in the MDX - is this correct?

    Have you set aggregations in the cube?

    Questions, questions....

    Mack