SAP BW Report - URL Parameter Bug

[Anonymous]

Hi,

I posted this question regarding sending paremters to a report URL, with parameters, like this:

?filter=Posting_x0020_period/Posting_x0020_period_x0020_Level_x0020_01 eq 'Aug'

I had thought it simply not working, because the Filter Pane said (All) instead of Aug. The filter is actually being applied, but the Filters Pane is incorrect:

Thanks,

Nathan

[v-qiuyu-msft]

Hi @Anonymous, 

In your scenario, the table name should be "Posting period", right? Which connection mode do you use, DirectQuery or Import mode?  

I tested on my side by entering some sample data to create a report, append the below section at the end of the report URL does filter the report data correctly, and the correct filter condition is set. I would suggest you test again on your side to see if the same issue occurs. 

?filter=Posting_x0020_period/Posting_x0020_period_x0020_Level_x0020_01 eq 'Aug'

Best Regards,
Qiuyun Yu

[Anonymous]

@v-qiuyu-msft  - This is DirectQuery to SAP BW. I have seen this work properly with Import mode and with other DirectQuery reports, but this specifically is not working. Also, the "In" operator is not working either, with DirectQuery to BW:

Thanks,

Nathan

[v-qiuyu-msft]

Hi @Anonymous, 

I would suggest you create a support ticket to let engineers look into the issue on your side. 

Best Regards,
Qiuyun Yu

[Anonymous]

Thanks @v-qiuyu-msft  - I created a ticket and have discussed the matter with support. Hopefully it will result in a fix. 🙂