Double Join to Same Table

Hi,

I have Four tables

ORDERS

TICKERS

MATCHES

CLIENT

MATCHES table contains matches b/w orders entered by various clients; The match can be on same ticker or tickers in the same sector.

Also the matches tables contains two match records for the match i.e A- B & B-A

I am trying to find out - how many matches are there for each ticker/client/company or any other attributes of orders or Ticker dimension

Also need a straight table in the format

Need to be able to filter by Client and Ticker

One solution I can think of is to introduce a primary key in the matches table in format - BUY_ORDER_ID + SELL_ORDER_ID; so the A-B & B-A legs have the same primary key; However, I am not entirely sure how to do this in the load script.

then use Only({$<SIDE= {'BUY'}>} CLIENT_NAME) as measure in the straight table but this prevents me from doing any filtering on the table. Also, this gives null values when I apply some filters

Would it be possible to have a single filter that would filter on two columns in the straight table i.e if TICKER is in either Buy or Sell then show that records.

I have attached the data and and the test app.

What is the best way to model this?

Thanks in advance!