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