I started running into a problem yesterday with a newer universe I created. I have a measure for count of account number with a sum projection (among other measures) and many different dimensions.
Yesterday I created a webi report with account count (the measure) and a diagnosis code dimension. There were no problems. Then I added in visit end fiscal year (representing the account end date fiscal year). I got the generic "[Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be prepared."
I went back into IDT and created a query there and I get the same results. However, if I remove the visit end fiscal year dimension and add visit start month, the query runs fine.
I discovered that, with certain dimensions, the sql that is generating is not including the "group by" for the dimensions.
Has anyone ever seen this before? Why does it work with some dimensions and not others?