I have a cube with sales data. Along with factSales tables I have several dimensions. I want to create a report that lists sales reps and their customers.
Is it possible to query the customer and sales rep dimensions directly without including a measure from the factSales table? If I add a measure from factSales I will only get a list of sales reps/customers that have current sales. I'm thinking
this might pose problems for new reps/customers who don't have any sales yet.
View Complete Post