SAP BW Connector: How to exclude filter values within SAP BW variable?

[AndreasScholl]

Hi folks,

does somebody know how I can exclude (!=) some specific filter value within a SAP BW variable?

Seems like I can only select inlcude filter values....

Thank you!

Andreas

[Anonymous · Accepted solution]

Hi @AndreasScholl,

Maybe you can try to add filter query with query parameters in 'advanced option' -> 'mdx statement'.

Use the SAP BW Connector in Power BI Desktop

Deep Dive into Query Parameters and Power BI Templates

Regards,

Xiaoxin Sheng