Thank you very much Samuel, i use normally the Analyzer but need more specification in my pivot, so i beginning in use a MDX for enrich my Dashboard.
I need a book of MDX for dummies... jaja a

this is my first step in MDX

Hi Peter, change te code but the execute pivot display de same error:

The MDX used:

WITH MEMBER [Measures].[CondicionesContCompletaCalc] AS (     ISNULL([Measures].[CondicionesContCompleta], 0) ) SELECT NON EMPTY (     [Gerencia].Gerencia].[Gerencia] ) ON ROWS, NON EMPTY (     [Measures].[CondicionesContCompletaCalc] ) ON COLUMNS FROM [Condiciones]

The error displayed:

Error#5001: Expected  operator within tuple: ('SELECT' @pos 156)(2)

Rodrigo has no followers yet.
Rodrigo has not followed anybody yet.
Global Masters badges:
Rodrigo has no Global Masters badges yet.