Re: hide members in parent-child

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Darren,

Unfortunately, none of the properties solves my problem.

I have an unbalanced hierarchy, but not ragged, on which I needed to hide
some leaf members according to a rule.

Members With Data doesn't solve it, neither Skipped Levels...

Thanks anyway.

"Fernando Marçal" wrote:

> Hi Darren,
>
> Will look into it Monday.
>
> Thanks!
>
> "Darren Gosbell" wrote:
>
> > Strictly speaking the answer to your question is no, but there are a
> > couple of properties which may achieve the result you are after. :)
> >
> > One option is the MembersWithData property, it is in the advanced
> > properties of the dimension. This allows you specify whether data
> > members for parent nodes are visible , hidden, or not allowed.
> >
> > So if you are seeing...
> >
> > Parent 1
> > - Parent 1 Data
> > - Child 1
> > - Child 2
> >
> > ....and you don't want to see the "Parent 1 Data" members, then this is
> > the property that you need to change.
> >
> > The second option that I can think of is the "Skipped Levels Column"
> > which will allow you to position a child a given number of levels below
> > it's parent. The following description from BOL explains how this works:
> >
> > >>>>
> > This property contains the name of a column that stores the number of
> > skipped (empty) levels between each member and its parent. This allows a
> > parent-child hierarchy to skip levels between members. The values
> > contained in this column must be nonnegative integers; otherwise a
> > processing error occurs. If the column contains no value, the current
> > member has a level depth one below its parent.
> > >>>>
> >
> > HTH
> >
> > --
> > Regards
> > Darren Gosbell [MCSD]
> > Blog: http://www.geekswithblogs.net/darrengosbell
> >
> > In article <9C849107-B110-4CA3-8C83-6F57AED8617F@xxxxxxxxxxxxx>,
> > FernandoMaral@xxxxxxxxxxxxxxxxxxxxxxxxx says...
> > > Hello,
> > >
> > > Is there a way to hide members in a parent child-dimension? Like the "hide
> > > member if" in normal dimensions?
> > >
> > > I'm using Analysis Services 2000.
> > >
> > > Thanks.
> > >
> >
> >
.

Relevant Pages

  • Re: hide members in parent-child
    ... members for parent nodes are visible, hidden, or not allowed. ... - Child 1 ... The second option that I can think of is the "Skipped Levels Column" ...
    (microsoft.public.sqlserver.olap)
  • Re: Named Set Alias
    ... > see the "parent" calculation but this will not let you drill down. ... > 2) Introduce duplicate members into the dimension to create a fake ... > the secondary hierarchy from affecting the "All member" totals. ... >> I have a named set with 5 non-leaf members from the same dimension, ...
    (microsoft.public.sqlserver.olap)
  • Inner Classes Change Access Rights Of Parent Members?!?
    ... I read that if you access a parent class's private memebers or methods ... from within an inner class, ... need access to certain private members and methods of their parent. ...
    (comp.lang.java.programmer)
  • Re: Hide A Level Based on Members
    ... There is a property on each level called "HideMembersIf". ... members to be hidden if they have the same name as their parent or if ... Blog: http://www.geekswithblogs.net/darrengosbell ...
    (microsoft.public.sqlserver.olap)
  • Re: Parent child dimension and fact table
    ... divides it into leaf members (I know it is possible because someone showed ... > Data for Nonleaf Members ... > the fact table and individual dimension members. ... > Many parent-child dimensions will have data for nonleaf members in the ...
    (microsoft.public.sqlserver.olap)