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?
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?
Hi Vivek - I haven't had a chance to test that. I am not sure. When I get a chance I will try that.
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
Thanks for the information. Does Analysis for Office come as part of the standard S/4 License or do we need any additional license?
Hi Bala - Analysis Office is a separate license from S/4HANA
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?
Thank Tammy Powlas, This I knew for sometime now already.
I have a question on Scenario, what do you think when should the business use AfO directly with S4HANA?
For me I think it depends if the desired CDS view is available and released
Ofcourse if a CDS View is Anlaytical enabled/released, it will be accessible. My Question was for what Business Scenario, business user should connect S4HANA in AfO?
I think that depends too
So far I like the financial statement view and the asset accounting views
Maybe start with the accountants since finance is a more mature module in S/4HANA
Can you please share the link or let me know, were i can find the standard content Finance CDS views in S/4 HANA system , so that i can review and consume then Analysis for Office.
Hi Saneet - thank you for reading and commenting
It depends on your S/4HANA release
I recommend using the Query Browser; to use the Query Browser, the user must be assigned to role SAP_BR_EMPLOYEE
From my notes per SAP "
The Query Browser is a SAP Fiori application allowing you to quickly and easily search for and launch analytical queries.
Analytical queries are CDS views of the type consumption (C_) that are marked for use by analytical tools (annotation @ANALYTICS.QUERY = true) and contain rich metadata, including default rows and column layouts and default filters"
That should help you find the queries that should work with Analysis Office