Hi, I had designed my table like this :
Row1 : Measure=Cost, Period=Nov13, Tag=Tag1, Tag=TagA, Value=50 Row2 : Measure=Cost, Period=Nov13, Tag=Tag1, Tag=TagB , Value=20 Row3 : Measure=Cost, Period=Nov13, Tag=Tag1, Value=210 Row4 : Measure=Cost, Period=Nov13, Tag=Tag2, Tag=TagA Value=120 I need to two types of queries : A) Give me all rows which has tag as Tag1 Query : Tag:Tag1 Expected Result : Row1, Row2, Row3 B) Give me all rows which has only tag as Tag1, no other tag Query : ? Expected Result : Row3 Please help me in writing BLUR query for problem B) Thanks Naresh
