With a DMR model, I have a fact table with a measure called net amount. There may be many sales reps associated with each fact record so there is a bridging table between sales rep dimension and the fact table. I want to show the total net amount repeated for each sales rep (i.e. not weighted) but the summary should not double count.
E.g.
Booking X Sales Rep A $1000
Sales Rep B $1000
Summary Booking X $1000
Booking Y Sales Rep A $2000
Sales Rep B $2000
Summary Booking Y $2000
Overall Summary $3000
I thought I could just set the scope of the measure to the All level and then use constant allocation rule but I'm still getting double counting in the summary rows.
Any thoughts? Thanks.
Greg
Hi,
Have you defined determinants in the dimension query subject?
Please define once and check.
Regards,
Manish Tirpude