Descendant Count of CurrentMemeber with Multiple Selection

K

Ken Mayers

I have run into a problem with OWC XP pivottable component. In XP it allows multiple selection of a dimension in the filter area but this is making my MDX calulated members in the cube return no data. In it's simplest form the MDX expression for the calulated member is

Count(Descendants([Manager].CurrentMember,[Worker]))

Having only 2 levels in the dimension. If all or one is selected in the pivot then everything works fine. However when multiple Managers or Workers are selected in the filter area no counts are returned. Everything works fine when the dimension is in the row or column area

I have masked the issue by using the FieldSets("Manager").AllowMultiFilter = False property in the pivot. This will only allow single selections of the dimension while in the filter area

Is this a known problem and is there a workaround
 

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

Problems with same month previous year measure 1
Bug or feature, Expanding multiple dimension with multiple level. 0
All Level on a Dimension in the Web Controls 0
All filter on a Dimension 1
Define the size of an Excel Chart (Office 2007)?? 0
Multiple reports with common filters on a single ASP.Net page 0
sort totals on multiple dimensions 4
OWC 10 Quick Questions 0

Top