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!!!