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