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?
Page 1 of 1
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?
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.
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
MDX EXCEPT
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.
dwbi1.wordpress.com/2010/07/27/mdx-except/
Hope that helps.
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum