Analysis services with non normalized table

Posted by Uwe on Stack Overflow See other posts from Stack Overflow or by Uwe
Published on 2010-05-11T11:21:10Z Indexed on 2010/05/11 11:24 UTC
Read the original article Hit count: 340

I have a table with several million rows. Each row represents a user session. There is a column called user which is not unique. There can be multiple sessions per user. I want to use Analysis services to get me the additional properties per user. Example: How many users (unique!) had a session longer than x minutes. How is that possible without changing the database. Note: there is no lookup-table and I cannot create one.
What I am able of at the moment is to ask how many sessions were longer then x minutes.

© Stack Overflow or respective owner

Related posts about analysis-services

Related posts about database