SQ01 query or SQVI query in AO (Analytics for Office)

[former_member774679]

Hi All,

How does one access SQ01/SQVI queries built in S/4 Hana in AO?

I know I can do this in SAC but not sure if this works in AO?

If it works, please let me know the steps to pull the query in.

Regards;

SR

[TammyPowlas · Accepted solution]

You can follow the steps in this blog https://blogs.sap.com/2012/03/25/what-are-transient-providers/

I set the infoset to BI following transaction SQBWPROP

Create a BEx Query against the infoset

Then launch Analysis Office and open the BEx query as a datasource

I just tried it in S/4HANA 1909 and it works

[former_member774679]

Thanks Tammy - I read thru your blog and then discovered note 2636574 via program RSRTS_ACTIVATE_R3IS which seems to be more appropriate for S/4 based systems. I will follow the steps therein.