Home Forums Data Warehousing Analysis Services How i can replace the sql query with mdx RE: How i can replace the sql query with mdx

  • September 17, 2012 at 12:12 am

    #1538407

    You can also re-write as below:

    WITH SET SetA as Except([PH_CUST].[Cust].Children,{[EMP].[PHWEB].[Activce].&[1]})

    SELECT { } ON COLUMNS,

    NON EMPTY { SetA } ON ROWS

    FROM Ad_CUBE

    Raunak J