Avoid expand some nodes but not another ones in Pivot Table.

[Ixabre]

Hi friends, I have a little problem for you, I query my Pivot Table
with this MDX sentence :

SELECT [DimE].[Name Enterprise] ON COLUMNS, NON EMPTY
{[DimA].[Hierarchy1].[DesNiv1]} ON ROWS FROM [Cube Name] WHERE
{[Hierarchy1].[Year].&[2006]&[8]}

and I want that some X members dimensions ( Member1, Member2, etc) can
be expanded but not other ones,

How can I do this?, Can I use any Pivot table property or Do I have to
use an special MDX sentence?.

Apologies for my english and thanks in advance.

David

 

[Alvin Bruney [MVP]]

Your best bet is to use a customized MDX expression. Alternatively, you can
set the expand property of the pivotcell object but that involves finding
the cell and you may not have all the information to find the cell.