Adding date columns

Feb 7, 2012 at 3:47 PM
Edited Feb 8, 2012 at 6:26 PM

I am trying to add two data columns together and get 'subselects only supports the column axis' error.  This is the code I am using.  Please help.  Can't figure out what is causing the issue.

( SELECT NON EMPTY Hierarchize({DrilldownLevel({[Dim Month].[Month].[All]})}) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS , NON EMPTY Hierarchize({DrilldownLevel({[Dim Resource].[Full Name].[All]})}) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON ROWS  FROM (SELECT ({[Dim Month].[Month].&[201112]}) ON COLUMNS  FROM [Clarityrpt]) WHERE ([Measures].[Actual Hours]) CELL PROPERTIES VALUE, FORMAT_STRING, LANGUAGE, BACK_COLOR, FORE_COLOR, FONT_FLAGS

+

SELECT NON EMPTY Hierarchize({DrilldownLevel({[Dim Month].[Month].[All]})}) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS , NON EMPTY Hierarchize({DrilldownLevel({[Dim Resource].[Full Name].[All]})}) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON ROWS  FROM (SELECT ({[Dim Month].[Month].&[201201]}) ON COLUMNS  FROM [Clarityrpt]) WHERE ([Measures].[Actual Hours]) CELL PROPERTIES VALUE, FORMAT_STRING, LANGUAGE, BACK_COLOR, FORE_COLOR, FONT_FLAGS )

<input id="ad942c86-b733-4d15-85f8-cbf77e616ef2_attachments" type="hidden" />