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?

View previous topic View next topic 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?

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

View user profile

Back to top Go down

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

View user profile http://brentgreenwood.blogspot.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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