Hierarchy with duplicate keys(at leaf node)

[Former Member]

Hi,

We have a requirement to create a hierarchy in BO.

1. Category

2. Department

3. Brand

The issue we are facing is, if there is same Brand may come under different Department/Category.

Eg: Womens Wear (C) - Ethnic Wear(D) - First Class(B)

Mens Wear (C) - Ethnic Wear(D) - First Class(B)

All Fields are mandatory in report, if i use hierarchy, the query is filtering only on Brand assuming that it is unique. But if i go Womens Wear (C) - Ethnic Wear(D) - First Class(B) selection, the same report also shows data from other category.

How i can resolve this.

Regards

Baby

[Former Member · Accepted solution]

Hi,

You have to defined the index awareness for each object implied in the hierarchy definition.

The index awareness is defined in the object properties, keys tab.

You create a primary key and select a column that uniqueley define your object: for instance it could be the concatenation of category, department and brand.

So when you are filtering on First Class of Mens Wear, only First Class of Mens Wear is retrieved.

Didier

[Former Member · Accepted solution]

Hi Didier,

Thank you for your helpful reply.

We are creating this hierarchy on a derived table. Is there any option to create index awareness on derived tables column.

Regards

Baby

[Former Member · Accepted solution]

Hi,

Index awareness has to be set on the business layer not on the data foundation.

It can be set on any object.

Regards,

Didier

[Former Member · Accepted solution]

Hi Didier,

Thanks once again.

Issue Resolved. I was using key of type character, that why it show some error.

After cast in to Numeric type, it is showing results properly.

Regards

Baby