The security auditing of our system will benefit from seeing any action in the catalog, including deletes, renames, moving, copying, etc

In the advanced SQL you can use standard SQL Syntax for out er joins, e.g. you can use LEFT OUTER JOIN (Sorry it took so long to reply!)

Hi 3247122 (Is that your real name?) I see from your posts and replies that you have maybe missed the point that Thomas is putting to you. Your diagrams looks nothing like dimensional modelling, it looks like a pure relational database. Just because you call a table a Fact table and have Dimension tables, it does not mean…

My Advice is to try to create this using Advanced Logical SQL. The trick in the 2nd query will be to remove those items that get into the top 10 in the first query. This could also be achieved by using a nested union, where the 2nd row is a union minus.