Hi,

I have a dimension whith only one atribute that is a parent-child
hierarchy.
My Dimension table is something like this:


Code| ParentCode|
1 null
2 1
3 2
4 2

For example what i can't do when i see the dimension in the cube is to
hide de Code 1,so
that the Code 2 becomes the parent of all the hierarchy.
This dimension hasn't got the property "Hide member if" because it's a
parent-child.
Can anyone help me?

Thanks.

Could you explain why you want to hide Code 1? The "Hide Member If"
property allows "ragged" hierarchies to be created from regular
dimensions, but the "SkippedLevelsColumn" property is used for
parent-child hierachies:

http://msdn2.microsoft.com/en-us/library/ms365406.aspx

Working with Ragged Hierarchies
...
Hiding Members in a Regular Hierarchy

For a regular hierarchy, use the use the HideMemberIf property of a
level in a hierarchy to hide missing members from end users.
...
Hiding Members in a Parent-Child Hierarchy

To make a parent-child hierarchy ragged, use the SkippedLevelsColumn
property of the parent attribute in the hierarchy to support the ragged
structure.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***