November 21, 2014 at 9:33 am
Analysis Services version is 2012 (11.0.5532.0)
Having a problem with Analysis Services on a cube with "proactive caching" enabled. The cube processes fine, but when querying I get the error "Operand data type date is invalid for sum operator." This error does not occur when proactive caching is not enabled (When cube is in full MOLAP mode).
I've tracked the problem down to specific measures in the cube. These measures are dates. When I remove these measures, the error goes away so I'm certain this is the origin of the problem. I also ran a SQL Trace to see if I could figure out what's going on and I do see a query that Analysis Services submits, and this query is trying to SUM the date measures in question. What I can't figure out is *why* it's trying to SUM these measures because the measures, in the measure definition in the cube, are set to "None" aggregate function. It's like proactive caching is ignoring the fact that I said I don't want these measure to be aggregated and is just doing its own thing.
I can't remove these measures as they are needed for user reporting, and I really don't want to turn off proactive caching because we have a reason to use it. And I can't for the life of me figure out why this is happening, or what to do about it.
Tried Googling this problem but have not had any luck so far. Can anyone help me? I don't know what other information is needed, but I'll provide more info if I can.
Thank you.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply