OWC versus MDX Named Sets

  • Thread starter Cristiano Moraes da Silva
  • Start date
C

Cristiano Moraes da Silva

Does anyboby knows how to use PivotTable (OWC) and Named Sets ?
I want to run this MD query:

WITH
SET [Best Customers] As ' Filter( [Customers].[Name].Members,
[measures].[unit sales] > 400)'
MEMBER [Customers].[Best Customers] as 'Aggregate ( [Best Customers] )'
SELECT
{ [Product].[Product Family].Members } on columns,
{ [Measures].[unit sales] } on rows
FROM
Sales
WHERE
( [Customers].[Best Customers] )


I don't know how to define the SET "Best Customers" e how to define the
calculated member "[Customers].[Best Customers]".

===========================================
Cristiano Moraes da Silva
SIG Soluções em Informática e Gestão LTDA
Santa Maria - RS - Brasil
(e-mail address removed)
www.sigbrasil.com.br
+55 552268699
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top