Solved

MDX 2 Filters Connected By Or Keyword

Posted on 2009-04-02
1
542 Views
Last Modified: 2012-05-06
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
Comment
Question by:Kaporch
1 Comment
 

Accepted Solution

by:
Kaporch earned 0 total points
ID: 24060004
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how the fundamental information of how to create a table.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now