PDA

View Full Version : how to deal with parent child hierarchy



ming
10-15-2007, 08:02 PM
I had to try the metadata editor 1.6 GA and it looks pretty good. I have a little question. what shall I do with parent child hierarchy?

I tried two instances of same table within parent child relationship. But I failed. The error is "Not unique table/alias".

Is there anyone can help me out? Thanks in advance.

MattCasters
10-16-2007, 01:50 PM
You should drag the same physical table (under your database connection) multiple times onto the business model to create a business table.
This happens a lot if you for example have dimensions such as date/time.

HTH,

Matt

ming
10-21-2007, 10:06 PM
Many thanks