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
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