Design Ragged Hierarchy in AS 2005

Hi,

I want design a ragged hierarchy in AS 2005.

The content of table as following:

item, catelogy, kind
A0101, A01, A
A0102, A01, A
A0201, A02, A
A0202, A02, A
A0301, , A
A0401, , A

The hierarchy as following:

A
-- A01
-- A0101
-- A0102
-- A02
-- A0201
-- A0202
-- (null)
-- A0301
-- A0401

The hierarchy is a ragged hierarchy obviously.

I design a regular hierarchy that level 1 is attribute kind, level 2 is attribute catelogy, and level 3 is attribute item.

I want hide the (null) when I browsing cube.
So I set HideMemberIf OnlyChildWithNoName at level 2.
But I browing cube, the null still appears.
How could hide the null in a ragged hierarchy?

thanks,

I've had the same issue, both with the no-name option and the same as parent option. I'm starting to thing that SSAS 2005 only supports ragged hierarchies in parent-child hierarchies, not regular hierarchies.
Has anyone gotten this to work?
|||

In SQL Server Book OnLine:

"For a regular hierarchy, use the use the HideMemberIf property of a level in a hierarchy to hide missing members from end users. "

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

Actually, I have no idea how to implement it even if the BOL looks like clearly.

DWBI_Doug wrote:

I've had the same issue, both with the no-name option and the same as parent option. I'm starting to thing that SSAS 2005 only supports ragged hierarchies in parent-child hierarchies, not regular hierarchies.
Has anyone gotten this to work?

|||

I have been trying to create ragged hierarchies and observed the following:

in case the members down the hierarchy all have null values from a certain level- it can be hidden using the HidememberIf = NoName

eg. prod

--Category

SubCategory (null/blank) -the hierarchy gets hidden from here

-Brand (null/blank)

--Product(null/blank)

if there is only one level blank and the level below it has some value in the database, it still displays the blank level

eg. prod

--Category

SubCategory (null/blank) -still visible

-Brand (not blank)

--Product (not blank)

if a level has null and the one below it has some value, using the unknown member property gives an error on browsing the hierarchy.

eg. prod

--Category

SubCategory (null) -- unknown member made visible

-Brand (not blank) -- (browsing this throws an error)

--Product (not blank)