COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: sumeir on 30 Dec 2009 07:14:32 AM

Title: Multi select prompt not accepting 2 values-- Cube (Crosstab report)
Post by: sumeir on 30 Dec 2009 07:14:32 AM
Hi Guys,

Data source: cube
Prompts: 
Analysis Code (Multi Select)
Entity (Multi Select)
From date: Value prompt
To Date: Value prompt
Currency: Statis Choice

The issue is

if I select 2 Analysis Code and n number of Entities -- Gives error.
if I select 1 Analysis Code and n number of Entities -- No error.
if I select 2 Analysis Code and 1 Entity -- No error.

It means I can use Entity prompt or Analysis Code prompt as multi select but as per the requirement I need to use both prompts as multi select.

Following is the error message:

DPR-ERR-2056
The Report Server is not responding.
Handler trace back: [the_dispatcher] com.cognos.pogo.handlers.performance.PerformanceInd icationHandler [the_dispatcher] com.cognos.pogo.handlers.logic.ChainHandler [service_lookup] com.cognos.pogo.handlers.engine.ServiceLookupHandle r [load_balancer] com.cognos.pogo.handlers.logic.ChainHandler [lb_forwarder] com.cognos.p2plb.clerver.LoadBalanceHandler [reportservicechain] com.cognos.pogo.handlers.logic.ChainHandler [warp_with_authenticate] com.cognos.pogo.handlers.logic.ChainHandler [do_warp] com.cognos.pogo.handlers.logic.ChainHandler [warpmta] com.cognos.pogo.reportservice.ReportServerHandler

Thanks in advance!!

Regards
Sumeir
Title: Re: Multi select prompt not accepting 2 values-- Cube (Crosstab report)
Post by: MFGF on 04 Jan 2010 07:39:42 AM
Hi,

How are you using the parameters in your query?  Do you have detail filters, or are you using dimensional expressions along the lines of [item] -> set(?parameter?)

MF.