Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 567
  • Last Modified:

MDX 2 Filters Connected By Or Keyword

I have the requirement that a schedule should be completed for any people with a one-time spend greater than $50, or an aggregate spend greater than $250.  Below I have the individual queries.  Is it possible to combine these conditions using an 'OR' into 1 query?  I don't want any overlap -- in other words, people selected from the 1st query should not also be selected from the 2nd query.

Code samples appreciated.
-- Query 1
select 
([Measures].[Spend Count].Children, [Beneficiary].[Address].Children, [Activity Start Date].[Date]) ON COLUMNS,
{Filter ([Year Quarter Desc].Members, [Measures].[Total Spend Amount] > 50)} ON ROWS
FROM Spends
WHERE [Party Role].[Beneficiary].[Beneficiary Role].&[Caterer]
 
--Query 2
WITH MEMBER Measures.Year AS SUM
	({[Year Quarter Desc].&[2008/Q1], [Year Quarter Desc].&[2008/Q2]},[Measures].[Total Spend Amount])
	select [Beneficiary].[Full Name] ON COLUMNS,
	{Filter ([Year Quarter Desc].&[2008/Q1], [Measures].[Year] > 250), 
	Filter([Year Quarter Desc].&[2008/Q2], [Measures].[Year] > 250)} ON ROWS
	from spends

Open in new window

0
Kaporch
Asked:
Kaporch
1 Solution
 
KaporchAuthor Commented:
Another question that I think I found my own answer to below.
WITH MEMBER Measures.TotalVendorSpending AS SUM
	({[Year Quarter Desc].&[2008/Q1], [Year Quarter Desc].&[2008/Q2]},[Measures].[Total Spend Amount]) 
	select [Beneficiary].[Full Name] ON COLUMNS,
	IIF([Measures].[TotalVendorSpending] > 250, [Measures].[TotalVendorSpending], {Filter ([Year Quarter Desc].Members, [Measures].[Total Spend Amount] > 50)}) ON ROWS
	from spends
	WHERE [Party Role].[Beneficiary].[Beneficiary Role].&[Caterer]

Open in new window

0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Tackle projects and never again get stuck behind a technical roadblock.
Join Now