IMHO

A little incorrect agregation example on F2 Revenue Aggregate. The table granularity is PRODUCT, QUARTER, When you map only measure columns (Units, Revenue) to F1 Revenue and set all Aggregate Content to total except the H1 Time (Quarter) you get the DISTINCT Sql as you correct pointed in "Inspect the log. Notice that the query uses the expected tables: D1 Time Quarter Grain and F2 Revenue Aggregate"

The mistake is that it's possible to have in the aggregate table different records with the same quarter and revenue but containing the different products and the result is incorrect in this case (but for the year level it's OK anyway as the SUM is used)

Hope to have more about  how to create  logical dimensions with Parent-Child Hierarchies,thanks.

Great tutorial for new BI users.  Gave me an excellent start... Many thanks.