Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2012 Forums  Analysis Server and Reporting Services (2012)  Extract function Issue

Author  Topic  Lbarbosa Starting Member 1 Post Posted - 2013-11-05 : 10:31:21 Mdx Query: -------------------- with set g1 as EXTRACT( nonempty( filter( ( [Customer].[Customer].children, [Measures].[Act. Net Sales], [Time].[Calendar Year Hierarchy].[Month Year].&[2012]&: [Time].[Calendar Year Hierarchy].[Month Year].&[2013]&[1] ) ,[Measures].[Act. Net Sales] > 0 ) ), Customer.Customer) select non empty { g1} on 0, { [Material].[Brand Hierarchy].[Signature].&[21] } on 1 from sell_in --------------------------------------------- The G1 Set returns a tuple (Customer - YYYY-MM - Measure). I've created this G1 set to get all customers in the lats 2 months with act. net sales >0. How could I get just the Customers(no duplicates) members of this G1? I ´ve tried Extract(), but it not working. It is returning all customers, and not just memmbers of G1. any Idea?