In my project,Webi reports are being built on top of Bex query.Bex query has few mandatory variables prompts which gets poped up when we run report.
In variable prompts,variable values are not being listed most of the times and throws below error
"java.util.concurrent.ExecutionException: com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: Number of requested members exceeds 5000 ; please do a search by element instead."
And at times shows values in folders as in below snapshot,but these values are supposed to be listed one by one and not in folders.
Kindly give ur suggestions to eliminate this error and Is there any setting where i can change the Folder display of variable values?