thanks Ravi, but I can't to do this because the query return only values differents of 0.

I used another form:

WITH

SET FILTROS AS STRTOSET(@PERMISSOES)

SET PERIODO2008 AS '{[TEMPO].[MÊS].&[200801]:[TEMPO].[MÊS].&[200812]}'

SET PERIODO2009 AS '{[TEMPO].[MÊS].&[200901]:[TEMPO].[MÊS].&[200912]}'...

I would like to hide the Document Map of my report.

Can I to do this?

Thanks,

Marcelo.

Hi. I can't to do this.

Can you give me a pratice example using "union all" and "openquery" for MDX?

Can I to do this when my query use differents cubes?

thanks,

Marcelo.

No, because my querys using MDX and differents hierarchys.

Any suggestion?

there is one dataset for each matrix.

OK. Per example:

first matrix

|jun |jul |aug |total

aaa | 10 | 20 | 15 | 45

bbb | 5 | 7 | 10 | 22

-----+----+----+----+-----

total| 15 | 27...