Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > SQL Language
SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old October 28th, 2013, 06:43 AM
Registered User
Join Date: Oct 2013
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default MDX WHERE clause don't work


I am having problem with MDX query, I am not sure if the procedure is right or wrong !

SELECT NON EMPTY [Measures].[Gross Sale] ON 0
FROM [Measures]
WHERE ([Data Type].[ID].[ID] = 2 AND [Chain].[Customer ID] = [Measures].[Customer ID]),


Bellow is the case; I have 3 dimensions(Datatype, Customer, Product) and one measure (GrossSales). so what will be the MDX query if I want GrossSales for ProductID = 1,2,3 and Dataype = 4,5,6 ? Here Datatype has relationship with GrossSales, Customer has relationship with GrossSales and Product has relationship with Customer. if you please help me. thanks in advance!


Similar Threads
Thread Thread Starter Forum Replies Last Post
MDX lem SQL Server 2005 1 June 6th, 2008 03:40 PM
Recursive Relationships with MDX Dima20 BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9 0 October 6th, 2006 04:45 AM
Mdx queries and java mybestfuture SQL Server 2005 0 September 12th, 2006 05:56 AM
MDX filters an Parameters GabrielP BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9 2 May 16th, 2006 08:31 AM
MDX - where clause with parameters?? boson SQL Language 3 August 24th, 2004 05:44 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.