tags:

views:

368

answers:

1

Hi, I'm quite new to MDX and im having some trouble getting the following t-sql query to MDX.

select distinct
  System
from Systen
  where System <> 'MIS'
UNION
  SELECT  'ALL'

So far i got something like this. But i have no idea how to add that final row 'ALL'.

SELECT 
  {} ON COLUMNS,
  {[Concesionario].[Sistema].[Sistema].ALLMEMBERS} ON ROWS
FROM 
(
  SELECT 
    -
      {
        [Concesionario].[Sistema].&[]
       ,[Concesionario].[Sistema].&[MIS]
      } ON COLUMNS
  FROM [DW]
);

Any idea how to do this?

Thanks

+1  A: 
Darren Gosbell
Ha, didn't think about that for some reason. Thank you!
Alan FL