Need information on Alteryx connectivity to AO report

[svankad1]

Hi All,

Can anyone knows how to input the AO (Analysis for office) Report as an input to Alteryx work flow? Please suggest.

[mceleavey]

Hi @svankad1 ,

can you give us more information?

If you're talking about the SAP AO report, for example, you can output the report data into .csv and pull into Alteryx, you can push the report to the SAP API and connect Alteryx to that.

M.

[svankad1]

Thanks M for the reply.

your understanding is correct. My requirement is simple. I want to input the SAP AO report to the alteryx work flow. so just want to know the feasible solution. instead of connecting to the SAP HANA ODBC data base layer connection, is there any other way to connect SAP application layer level  connectivity as the AO reports residing in SAP Application layer level.

[MichelleL]

@svankad1 It's been a couple years for me since I used an SAP AO report, but if I recall, the file extension is still .xlsx, correct?  If yes, you can simply bring it into Alteryx with an Input tool, just like any other Excel file.  If no, please remind me what the file extension is.  Thanks!

Please let me know if this helps!

[someotherguy]

@svankad1 I use the input tool and select the named range SAPCrosstab1 and it automatically imports all the data in the table