Apply Filter parameter in Saiku Reports

Nayana · 2019-01-08 10:53:23

For achieving authorization, we are going to apply following filter for each and every report query.
Is there anywhy to apply this filter for Saiku reports?

Filter Condition:
Where AuthTable.User = ${_RS_USER_USERNAME}

eduardo · 2019-01-09 15:47:09

Hi Nayana,

please check here for parameters with Saiku reports: https://forum.reportserver.net/viewtopi … 5095#p5095

Regards,
Eduardo

Nayana · 2019-01-10 05:31:14

Noted. That means we are still unable to add this parameter to Saiku Reports. Is there any workarounds which we can try out?

eduardo · 2019-02-08 18:38:36

Hi Nayana,

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

Nayana · 2019-02-11 05:55:33

Thanks Eduardo

ReportServer Forum

#1 2019-01-08 10:53:23

Apply Filter parameter in Saiku Reports

#2 2019-01-09 15:47:09

Re: Apply Filter parameter in Saiku Reports

#3 2019-01-10 05:31:14

Re: Apply Filter parameter in Saiku Reports

#4 2019-02-08 18:38:36

Re: Apply Filter parameter in Saiku Reports

#5 2019-02-11 05:55:33

Re: Apply Filter parameter in Saiku Reports

Board footer