This content has been marked as final. Show 4 replies
You can get it using Level based measure with level Month and City.
Create a metric sum(sales) and set content tab for Levels Month and City, that would result query as
sum of sales group by Month, City
If this is not what you are expecting pls give us more details.
If helps pls mark
Edited by: Srini VEERAVALLI on Jan 18, 2013 10:51 AM
Edited by: Srini VEERAVALLI on Jan 29, 2013 9:42 AM
Create a left outer join from Dimension to Fact in RPD.
I try it in your way, but didn't work
create left outer join of Sales Fact with Dim.
RHis should be the correct solution.
mark if helps,