Skip to Content
0
Former Member
Oct 04, 2005 at 02:57 PM

Any ideas how to get this?

30 Views

Trying to build a query where i need to count the values using two characteristics (Survey, Tag) and a keyfigure (Counter, which is always 1)

This is sample data in the Cube

Survey TAG Counter

-


--- -


1 F1 1

1 F2 1

1 K1 1

1 # 1

2 F1 1

2 # 1

2 F1 1

3 # 1

4 K4 1

4 F1 1

4 # 1

Let me explain the data. there can be multiple records for a Survey with different TAG values. TAG value can be sometimes 'not assigned #'. For every row, counter 1. Survey '3' does not have any tags except the 'not assigned'.

I need these measures in the query.

1. Total number of Surveys (answer 4)

2. Total number of Survey without any tags (answer 1, only Survey 3 has no tags)

anyway how this can be built in the query designer.

As always 10 points guaranteed for the solution.

Thanks

Gova