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
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