Joining two queries in MDX

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » Joining two queries in MDX

Joining two queries in MDX

Rate Topic

Display Mode

Topic Options

Author

Message

Aspet Golestanian Namagerdi

Posted Wednesday, February 10, 2010 5:22 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 3:44 PM
Points: 174, Visits: 663

I have two queries that has been implemented in MDX for different dates:

SELECT NON EMPTY { [Measures].[Quantity Received] } ON COLUMNS,
non empty {([Customer - ID].[Customer - ID],[Entry Date Time].[01/01/2008])} ON ROWS
FROM [Sales]

SELECT NON EMPTY { [Measures].[Quantity Received] } ON COLUMNS,
non empty {([Customer - ID].[Customer - ID],[Entry Date Time].[01/02/2008])} ON ROWS
FROM [Sales]

The only difference of these two queries is on their Entry Date Time
Now I want to join these table so I will have result like this

CustomerID EntryDateTime QuantityRecieved EntryDateTime QuantityRecieved
12 01/01/2008 12 01/02/2008 13

Is this doable and also can I chnage the caption of the column on the result Set.Because now I have duplicate EntryDateTime,QuantityRecieved.

Thanks

Post #863735

JimbobsQL

Posted Thursday, October 25, 2012 2:38 AM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 4:11 AM
Points: 251, Visits: 395

I'm trying to do pretty much the exact same thing.

You could create calculated members for each of the [date/time],[Measure] combinations and return them all, but I'm trying to avoid doing that.

I'll post back if I find anything.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Post #1376839

Mackers

Posted Thursday, October 25, 2012 3:20 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 4:19 AM
Points: 117, Visits: 460

I don't understand why you'd need to join two MDX queries together. In the above example wouldn't you just have a set with the multiple dates you want to select.

Like

SELECT NON EMPTY { [Measures].[Quantity Received] } ON COLUMNS,
non empty {[Customer - ID].[Customer - ID].[All].Children}
* {[Entry Date Time].[01/01/2008],[Entry Date Time].[01/02/2008]} ON ROWS
FROM [Sales]

Am I missing something?
Mack

Post #1376859

« Prev Topic | Next Topic »

Permissions