Trivial MDX and PivotTable

  • Thread starter Cristiano Moraes da Silva
  • Start date
C

Cristiano Moraes da Silva

Does anybody knows how to use this trivial MDX command in PivotTable (OWC
10) ?

----------------------------------------------------------------------------
---------------
WITH
SET [BEST] as ' TopCount ( [customers].[name].members, 5,
[Measures].[Profit])'
MEMBER [customers].[avg best] as ' avg([BEST])'
SELECT
{ [Measures].[Unit Sales], [Measures].[Store Sales],
[Measures].[Profit] } on columns,
{ [product].[product category].Members } on rows
FROM
Sales
WHERE
( [customers].[avg best] )
----------------------------------------------------------------------------
---------------

PivotTable.CommandText = sMdx ' It doesn't work!

Thanks
===========================================
Cristiano Moraes da Silva
SIG Soluções em Informática e Gestão LTDA
Santa Maria - RS - Brasil
[email protected]
www.sigbrasil.com.br
+55 552268699
 
Top