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

Nayana
Member
Registered: 2018-11-15
Posts: 62

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

Offline

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

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

Offline

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

Nayana
Member
Registered: 2018-11-15
Posts: 62

Re: Apply Filter parameter in Saiku Reports

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


Thanks & Regards
Nayana

Offline

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

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

Offline

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

Nayana
Member
Registered: 2018-11-15
Posts: 62

Re: Apply Filter parameter in Saiku Reports

Thanks Eduardo


Thanks & Regards
Nayana

Offline

Board footer

Powered by FluxBB