none
multiple dimension and multiple measures query

    Question

  • I am using Adventure works cube.

    I am trying to fire a crossjoin query having multiple dimension and multiple measures

    Select
    {
    {[Product].[Category].Children}
    }
     ON COLUMNS,
    CrossJoin
    (
     {[Sales Territory].[Sales Territory].Children}
    ,
    {[Measures].[Internet Sales Amount]}
    )
     ON ROWS
     From [Adventure Works]

    This query works fine with 1 measure.

    Kindly help

    Monday, October 14, 2013 3:52 AM

Answers

All replies