Home > Archive > MS SQL Server OLAP > August 2005 > MDX Help.









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author MDX Help.
bat man

2005-08-30, 11:25 am

Hi Folks,

How do I create a range based on FILTER?

What I mean is, I want to create something like this.

WITH SET [TestRange] AS 'FILTER([dimStore].children,
[Measures].[OrderCount] > 0)'
MEMBER [dimStore].[TestRange] AS 'Aggregate([TestRange])'

When I do this, it doesn't create the set. How can I implement this?

Experts please help.

Thanks



*** Sent via Developersdex http://www.droptable.com ***
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com