I had a query to be created that gives a count of a certain combination of characteristics from a cube.
Say a cube has 4 characteristics , Say A, B, C, D.
Now amongst all the records that occured in the Cube I need a report of the following A, B and be able to see the count of the number of times a combination of A B occured i.e. variations of C and D for a certain A and B.
For example say in the cube the A B C D has the following contents
the report should show
a1,b1,4 ,where 4 is the number of combination of a1 & b1.
a1,b2,4 ,where 4 is the number of combination of a1 & b2.
a2,b1,1 ,where 1 is the number of combination of a2 & b1.
i want a help from all regarding this query.
Thanking you in advance