Kimball Forum

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


How can I write an MDX statement or query that selects the clients who paid last month but have not paid this(Current Month) month?

Kimball Forum :: Topics :: Technical Architecture and Related Technologies

Go down

How can I write an MDX statement or query that selects the clients who paid last month but have not paid this(Current Month) month? Empty How can I write an MDX statement or query that selects the clients who paid last month but have not paid this(Current Month) month?

Post  mobzam on Wed Dec 14, 2011 4:15 pm

Hi people,
How can I write an MDX statement or query that selects the clients who paid last month but have not paid this(Current Month) month?. I have a data cube designed and deployed on Microsoft SQL Server Analysis Services R 2. I have a customer dimensions and a fact table.
Please help.

mobzam

Posts : 9
Join date : 2011-07-27

Back to top Go down

How can I write an MDX statement or query that selects the clients who paid last month but have not paid this(Current Month) month? Empty MDX EXCEPT

Post  BrentGreenwood on Sun Jan 01, 2012 9:14 am

You should be able to use EXCEPT to get the set where the 2 sets in question don't overlap. Here's a link to a detailed example of EXCEPT from Vincent Rainardi.

dwbi1.wordpress.com/2010/07/27/mdx-except/

Hope that helps.

BrentGreenwood

Posts : 6
Join date : 2011-12-25
Location : San Diego, CA

http://brentgreenwood.blogspot.com

Back to top Go down

Back to top

Kimball Forum :: Topics :: Technical Architecture and Related Technologies

 
Permissions in this forum:
You cannot reply to topics in this forum