Skip to Content
Product Information
Author's profile photo Tammy Powlas

Exploring Analysis Office with S/4HANA Out of the Box Queries

I sort of “stumbled” into this feature of using Analysis Office with S/4HANA on premise (in this case, 1909).  I think it is a great feature, especially for finance users

Start by using transaction RAAOE inside S/4HANA, “Launch Analysis Workbook”

I selected the Asset History Sheet query

At the selection screen, most of the prompt values are already populated.

This is what is returned by default

Turn on pause refresh to save trips to and from the S/4HANA server

Move account determination to the background filter

Move asset number to rows

Click the Pause/Refresh from the ribbon again to refresh the query

 

Result is the asset history sheet in Excel by asset; a possible audit schedule.

For fun, search on “asset” as shown above and review the results

So what is is nice is these queries are all “out of the box”.  You just need Analysis Office and authorizations of course.

 

What do you think?

Assigned tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Vivek Goda Varma
      Vivek Goda Varma

      Thank you for sharing this detailed step by step article.

      Can we save these workbooks in our local system and use Refresh functionality of the tool to fetch latest information?

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi Vivek - I haven't had a chance to test that.  I am not sure.  When I get a chance I will try that.

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Vivek - yes, this works in S/4HANA 1909

      Note that name space /BIC/ must be set to changeable in SE06 transaction

      Thanks for asking, reading and commenting

      Author's profile photo Bala Karthik
      Bala Karthik

      Thanks for the information. Does Analysis for Office come as part of the standard S/4 License or do we need any additional license?

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi Bala - Analysis Office is a separate license from S/4HANA

      Author's profile photo Sunny Sun
      Sunny Sun

      Tammy Powlas - Thank you for sharing this. Can we save these workbooks on S4HANA in role ? WIll these be saved on BW Server(Netweaver) which is in S4HANA?