-
SP2 issues in SSRS report against a cube
SP2 was applied to our SSAS and SSRS servers today. Also today, a
report which had been in production for many, many months stopped
working correctly.
I narrowed the problem down to a few calculated members which were
using a named set (created in the query) to SUM some measures.
As a test, I did a count for the number of members in my set and
returned it in my MDX... I was getting 0! So my named set wasn't
behaving as it should have been.
As a temporary fix, I simply replaced the reference to the named sets
to the actual logic which created the set, which works for now.
Does this make sense? Anyone from MS have any ideas?
Could this be a bug in SP2? Or a fix in SP2 which broke what I was
doing??
Thanks,
Todd