HideMemberIf with SSAS store proc

Topics: Developer Forum
Dec 24, 2010 at 3:56 AM

Hi,

I am trying to Hide unique child members on a set when displaying the set on a row axes

The HideMemberIf property of user defined hierarchy levels depends on the ability of the client application to implement the logic. And actualily the one I use does not have this feature available..

So I created a .net function with adomd server assembly as following :

 

public Set HideUniqueChildren(Set dataselection)
    {
      if (dataselection == null)
        return null;

      if (dataselection.Tuples.Count == 0)
        return dataselection;

      // use this function with set dimensionality of 1
      if (dataselection.Hierarchies.Count != 1)
        return dataselection;


      SetBuilder sb = new SetBuilder();
      foreach (Tuple t in dataselection.Tuples)
      {
        if (t.Members.Count > 0)
        {
          Member member = t.Members[0];
          if (member.Parent != null)
          {
            Member parent = member.Parent;
            if (parent.GetChildren() != null && parent.GetChildren().Count != 1)
              sb.Add(t);
          }
        }
      }
      return sb.ToSet();
    }

 

I would like to use the same logic but on the fact that a member has the same caption of his parent & in a second time, i would like to use this function with a crossjoin of attributes that belongs to the same dimension

I am newbe in .net & I would really appriciate some kind of advices to help doing this

thanks a lot

Stéphane