Expand field member

M

Markus Stehle

Hi all!

I have an OLAP cube that has a dimension named "Partner". This dimension has
two levels, "Type" and "ID" where "Type" is the top level.

On an ASP page I have a pivot table and the row axis of the pivot table is
bound to the "Partner" fieldset. The "Partner" fieldset contains two fields,
"Type" and "ID" (according to the levels in the "Partner" dimension). How
can I expand a single member of the "Type" field programatically? Let's say
I have the types "Standard" and "Premium", how can I expand the "Premium"
member (and only this) of the "Type" field? I can set Field.Expanded = true,
but this expands all members of the field.


Regards

Markus
 
M

Markus Stehle

Thanks alot, it works now :)



Dan Ricker said:
OWC10/OWC11

The PivotMember has a Boolean Expanded Property.

PivotTable1.ActiveData.RowAxis.RowMember.ChildMembers
(0).Expanded = True
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula error on created member 0
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
Changing row background from external program 0
How to filter pivot table programmatically 1
How to expand a single member 0
Retrieve member values for filters in OWC pivot table 0
Finding asymptote equation and how to draw them in excel 0
Retrieve Pivot Member Values 2

Top