Filter() Strings -
08-03-2004
, 09:41 AM
Someone knows how to Filter a SET like the query below ?
( Database: FoodMart 2000 Cube: sales)
WITH
MEMBER [measures].[X] as ' [Customers].CurrentMember.Properties("Member
Card") '
SET [X] as ' Filter( [Customers].[All Customers].[USA].[OR].[Lake
Oswego].children, [Measures].[X] = "Silver") '
SELECT
{ [measures].[X] } on columns,
{ [X] } on rows
FROM
Sales
Regards
Cristiano.
===========================================
Cristiano Moraes da Silva
SIG Soluções em Informática e Gestão LTDA
Santa Maria - RS - Brasil
cristiano (AT) sigbrasil (DOT) com.br
www.sigbrasil.com.br
+55 552268699 |