how save the mdx query result into a variable???

[Guest_imported]

I would like to do something like this

declare @VAR char
select @VAR = name from Table

but using MDX queries.

select {[Canal].[Grupo].&[6]} on columns
from [PV UsuarioVisitas SemanaMes]

how could i get into a variable the result of the MDX query above???

Could someone help me??
Thanks

Alberto