#1 2018-12-18 09:57:23

danlaw
Member
Registered: 2018-01-23
Posts: 3

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.

Offline

#2 2018-12-18 10:47:31

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,343
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

Offline

#3 2019-02-08 18:34:45

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,343
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

Offline

Board footer

Powered by FluxBB