regarding a query that gives a count of a certain combination of characters

78 Views

Hi all,

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

a1,b1,c1,d1

a1,b1,c1,d2

a1,b1,c1,d3

a1,b1,c2,d1

a1,b2,c1,d1

a1,b2,c1,d2

a1,b2,c2,d1

a1,b2,c2,d2

a2,b1,c1,d1.

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