ACS filter tool to pass values from a spreadsheet to bw query tool

[syed_shab03]

Hello Folks,

I am currently using a SAP BW Query tool to query org details for a cost report for my company however to make things easier i want to pass on a list of values which i have in a spread sheet to the BW Query tool in a specific field 

can i achieve this by acs filtering tool if yes, than how?

[aatalai]

Check out this post https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Connect-to-SAP-BW/td-p/489662

[Simon_Theobald_SW]

Hi @syed_shab03 , if you couldn't find a solution, you can also check out Xtract for Alteryx as SAP connector in a free trial. It supports dynamic filtering of BW Queries by using value lists as parameters and is available here:  https://theobald-software.com/en/xtract-for-alteryx/ 

[IAJ1966 · Accepted solution]

Hi Syed,

Thanks for your custom and use of the premier SAP connectivity tools from DVW Analytics.

I'm sure you've managed to work out how to use the Filter tool by now, but failing that please drop our support team a line at ACS_Support@DVWSolutions.com

They are ready and keen to help on all things DVW, and are the best point of call for your SAP connectivity questions.

Kind Regards

Ian