ReportServer Forum

Nayana

Member

Registered: 2018-11-15

Apply Filter parameter in Saiku Reports

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}

---

Thanks & Regards
Nayana

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Apply Filter parameter in Saiku Reports

Hi Nayana,

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

Regards,
Eduardo

Nayana

Member

Registered: 2018-11-15

Re: Apply Filter parameter in Saiku Reports

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

---

Thanks & Regards
Nayana

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Apply Filter parameter in Saiku Reports

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

Member

Registered: 2018-11-15

Re: Apply Filter parameter in Saiku Reports

Thanks Eduardo

---

Thanks & Regards
Nayana