Skip to Content
0
Former Member
Dec 18, 2007 at 08:45 PM

Characteristic Relationship !

25 Views

Hi IP Gurus,

I am trying to use characteristic relationship of type hierarchy for my model in IP. I have Project ID and Orders as 2 chars. The hierarchy structure is as follows :

Project ID 1

- Order 1

- Order 2

Project ID 2

- Order 3

- Order 4

I have created a Hierarchy in Project ID as above. I am using Order as External Characteristic in Project ID. But I have not taken Order as attribute in Project ID.

Now when I execute query I am getting a cartersian product. That means for each Project ID, I see all the values of the orders in the rows.

I have made proper selections in the Query Designer - selection by Char relations, etc.

Does this work for anyone. I am frustrated simple things like this doesn't work in IP.

Please help.

Thanks,

Jason