Expression with count on a member set --> Execution in Database possible?

[florian]

Hi,

we run a Cognos 10.2.2 server with a DMR model on a DB2 database.

I have a report where I want to count the members of a dimension that fulfill a certain condition.
So I defined a memberset called 'mycases' like

Code Select Expand

filter(
cases;
condition
)

Then I defined a data item like:

Code Select Expand


count(1 within set mycases)


This works, but the problem is that the memberset can be (depending on condition) very large and I get out-of-memory-errors in certain circumstances.
The reason is clear - the server fetches all cases and does counting on the server side.

Is there a way to force the server to delegate counting to the database?

Thanks in advance!
Florian