I'm designing a SQL 2008 SSAS Cube that will report product and service sales. We need to be able to report on both at the same time to see the total value spent by customer (products and services). Products have different metdadata (ie. categories) than services do.
What I was considering was to create an item dimension that contained both products and services, but I'm wondering if there is a more logical method.
Does anyone have any suggestions?