hide a member from the Pivot Fieldlist

[Rangaswamy]

Is it possible to remove or hide a member from the Pivot fieldlist
(OWC 10)? I do not want to display only selected dimensions of a Cube
in thelist. It is displaying all the dimensions of the CUBE, whether
the pivot is provided with CUBE NAME (Pivot.DataMember) or MDX QUERY
WITH ONLY THE REQUIRED DIMENSIONS (Pivot.CommandText).

I appreciate if some one can provide me a way.

Thanks in advance.

Rangaswamy.

 

[Tony Bull]

Hi Rangaswamy,

You can do one of two things:

1) The Easy Way (in the Cube itself)

Open the cube that's the basis for your PivotTable. Left click on the
dimension in question. Your "Properties" window should be open in the lower
left hand corner of the page. You'll see under "Advanced" a row named
"Visible." Just flick that from "True" to "False."

2) The Hard Way (using XMLData)

Get a handle on the XMLData, however you can. Find the tag for the
column in question. Nested in that tag should be another tag which looks
like "<x:NotVisible/>." Change that to "<x:Visible/>."


Best,

Tony B.

 

[Daniel_Ricker]

This can also be done via the object model for OWC10 and
OWC11.

For an entire Hierarchy:

PivotTable1.ActiveView.FieldSets
("MyFieldSetToHide").DisplayInFieldList = False

<< Note there is no way that I know of to do this for a
single level of a hierarchy (PivotField vs PivotFieldSet)

For a Measure:

PivotTable1.ActiveView.Totals
("MyTotalToHide").DisplayInFieldList = False