Is it possible to have times as measures in a cube?
We're trying to view employee start times by day, aggregating as an average over time. Even with a No Aggregation measure type I'm getting an error when deploying saying that StartTime is a String value. It is stored as
Is this at all possible? It doesn't seem like such a crazy thing to want to do?
We are using SQL Server 2008 R2 Enterprise.