Multi select prompt not accepting 2 values-- Cube (Crosstab report)

[sumeir]

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

[MFGF]

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.