ReportServer Forum

danlaw

Member

Registered: 2018-01-23

Passing parameter to Saiku Reports

Hi,

I see there is a "Parameter Management" page for Saiku reports but seems there is no documentation on how Saiku reports can get the parameters.

I tried to get the parameter in the associated XML schema but doesn't work.

Any advice on the above? Thanks in advance.

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Passing parameter to Saiku Reports

Hi danlaw,

we have a ticket for being able to pass parameters to Saiku reports: RS-2973.

Regards,
Eduardo

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Passing parameter to Saiku Reports

Hi danlaw,

ReportServer 3.0.6 will support parameters in Saiku Reports analogously as parameters in dynamic lists (https://reportserver.net/en/guides/admi … arameters/).

For example:

<SQL dialect='generic'>
    select * from mytable
    where myfield > ${myparameter}
</SQL>

oder

<SQL dialect='generic'>
    select * from mytable
    where $X{IN, id, myparameter}
</SQL>

Regards,
Eduardo