Hi All,
I am creating an Analytical grid (Tabular Format) in PPS 2010. I get an error when the no: rows (dimensions) and cols (fact's) increases , the error is:
"Unable to create report. Query produced too many results".
I checked the Event Viewer and it gives the Error details:
An exception occurred while rendering a Web control. The following diagnostic information might help to determine the cause of this problem:
Microsoft.PerformancePoint.Scorecards.BpmException: There was a problem preparing the WebPart for display.
PerformancePoint Services error code 20700.
***********************************************************
I took the query and run it in Management Studio , I get the result in 27 secs.
Any answers are highly appreciated.