Retrieve member values for filters in OWC pivot table

M

mial

Hi

I'm developing an an application that uses owc pivot table on a windows form.
The pivot table has a cube as a data source. The cube has some actions,
which I try to retrieve and execute some update cube statements.

1)
My problem is, that I do not know how I can retrieve the values for the
members used for filtering :
Imagine that I have an attribute hierarchy [Dim Date].[Day Name Of Week]
in the filter pane whose value is checked to Friday. How can I retrieve
the unique member name for that member, that is:[Dim Date].[Day Name Of Week]
&[Friday].

I tried different solutions and I found out that by using : ( cell is
declared as PivotCell)
cell.Data.FilterAxis.FieldSets.Item(0).Member.UniqueName I got
[Dim Date].[Day Name Of Week][All] and the same by using DefaultMember in
stead of Member.

2) If I have more than one field on rows or columns how can I retrieve them ?
I can only retrieve one by using cell.RowMember.UniqueName


Thank you a lot for your answer.
Best regards,
Mihai
 

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

Top