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

Title: Expression with count on a member set --> Execution in Database possible?
Post by: florian on 02 Jun 2016 02:14:23 AM

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

filter(
cases;
condition
)

Then I defined a data item like:

Code Select


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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: florian on 02 Jun 2016 02:14:23 AM