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

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.developersdex.com ***

Have you thgouth about gettign a survey tool, like RaoSoft? Much
better to drive nails with a hammer that a squid.

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

Ken

"Deepak Puri" wrote: