Re: hide members in parent-child

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

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: Google Groups outage.
    ... Except that I am describing the case where the person the cost is being ... transferred to is known not to be a parent of the child. ... The rule they are following is one established by members of the same ...
    (rec.arts.sf.fandom)
  • Re: SQL, related records (quotes)
    ... for all (child, parent) relationships that are members of hierarchies, there does not exist a tuple of. ... It also has the limiting factor of disallowing single node hierarchies. ...
    (comp.databases.theory)
  • 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)
  • Re: hide members in parent-child
    ... 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, ... >> members for parent nodes are visible, hidden, or not allowed. ...
    (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)