Relationship built in FM seems not available in Report Studio

[januschoy]

Dears...

I want to create a report in report studio with available drill-up-down options.

I have create two regular dimensions & one measure dimension which built from the query subjects.
The relationships have been created between query subjects.

And when I create a crosstab in report studio with dimension1.level1 as row, dimension2.level2 as column, measure1 as crosstab corner.

Then I check the generated sql, I can't see the relationship which has been created between dimension & fact.

Here's the model I've created in FM:

Dimensions

Sales:
Sales_Key,
Distrct

Product:
Product_Key,
Level1,
Level2

Measure
Sales_Amount

The measure comes from the fact query subject I've created below relationship:
Sales.Sales_Key = Measure.Sales_Key
Product.Product_Key = Measure.Product_Key

Then I dragged District as row, Level1 as column, Sales_Amount as crosstab corner.

The generate sql is:

select sum("Measure"."Sales_Amount") "Sales_Amount"
from dbo."FACT_PRODUCTION" "FACT_PRODUCTION"
having count(*)>0 FOR READ ONLY

Please kindly help me with this.... Many thanks!!!