I have two queries that use two different Time dimensions (using FoodMart 2000):
Code:
WITH 
MEMBER [Measures].[My Quarter Profits] as '[Measures].[Profit]'
MEMBER [Measures].[My Annual Sales] as 'NULL'
SELECT
{[Measures].[My Quarter Profits],  [Measures].[My Annual Sales]} ON COLUMNS,
{[Store].[All Stores].[USA].[CA].Children, [Store].[All Stores].[USA].[OR].Children, [Store].[All Stores].[USA].[WA].Children} ON ROWS
FROM Sales
WHERE [Time].[1997].[Q1]
Code:
WITH 
MEMBER [Measures].[My Quarter Profits] as 'NULL'
MEMBER [Measures].[My Annual Sales] as '[Measures].[Unit Sales]'
SELECT
{[Measures].[My Quarter Profits], [Measures].[My Annual Sales]} ON COLUMNS,
Filter({[Store].[All Stores].[USA].[CA].Children, [Store].[All Stores].[USA].[OR].Children, [Store].[All Stores].[USA].[WA].Children}, [Measures].[My Annual Sales] > 25000) ON ROWS
FROM Sales
WHERE ([Time].[1997])
Is there a way to write one single query that uses different Time dimensions for different sets (Year for one and Quarter for another)? I am looking for a single query that will return one table with the results of both queries above.

Thank you.