November 24, 2014 at 3:32 am
Hi, I'm not sure if this is an Analysis Services query or a Reporting Services query. Hopefully someone can point me in the right direction.
I have a multidimensional cube and a Reporting Services report. The report has a number of row groups, e.g. Department,Product_Type etc. and the measure is a count of Sales. I need to be able to indicate if the customer also has a sale outside of a particular group.
For example for a customer with a sale in both the Hardware and Gardening Departments, when "Hardware" is drilled into to find the customer_id - it should be able to show that there is another sale in Gardening. It would not have to actually have "Gardening" it could have just an Order_Count for this Customer_id. So the Order_Count would need to be outside of the Department grouping.
I'm not sure if I need to create a new Measure without joins to the Dimensions used in the row groups, or is there a way in Reporting Services to include data outside of the row group.
Thanks in advance.
November 24, 2014 at 5:30 am
Resolved - Added a new field in database with the count using Partition Over.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply