MS SQL Server OLAP - Survey categories

Author

Survey categories

ktrock

2006-03-24, 11:39 am

Hi. I've seen some discussion about tracking survey data here but couldn't
get a grip on how to do this. Our fact table has Q1Answer (possible answers
1-5) that is llinked to dimension d_Answer that has values 1-5 in it so I can
get the counts for each answer. That works fine.

I'm having trouble with the "satisfied" range, where a respondant answered 4
or 5. I thought this would work as a calculated measure:
[Answer].[Answer Val].&[4] or [Answer].[Answer Val].&[5]
Nope. Maybe it does a bitwise or. Anyway, I'm probably missing something
straightforward.

TIA,
Ken Trock

Deepak Puri

2006-03-24, 8:26 pm

Typically, client tools like Excel pivot tables will use the MDX
Aggregate() function, like:

Member [Answer].[Satisfied] as
'Aggregate({[Answer].[Answer Val].&[4],
[Answer].[Answer Val].&[5]})'

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.droptable.com ***

ktrock

2006-03-27, 11:32 am

Thanks Deepak. Actually my syntax works too. Was using the wrong set. Takes
some getting used to.

Ken

"Deepak Puri" wrote:

> Typically, client tools like Excel pivot tables will use the MDX
> Aggregate() function, like:
>
> Member [Answer].[Satisfied] as
> 'Aggregate({[Answer].[Answer Val].&[4],
> [Answer].[Answer Val].&[5]})'
>
>
> - Deepak
>
> Deepak Puri
> Microsoft MVP - SQL Server
>
> *** Sent via Developersdex http://www.droptable.com ***
>

Sponsored Links