Community
Technology Blog Posts by Members
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

#ASUG Webcast: What's New in Analysis Office 2.6 Recap

TammyPowlas
SAP Mentor
SAP Mentor
‎2017 Nov 20 5:53 PM
6,199


Source: SAP

This was an ASUG webcast today.  If you want more Analysis Office webcasts please take our survey today

See our upcoming webcasts here

Expect GA in 3 weeks



Source: SAP

Legal disclaimer applies



Source: SAP

Some nice features are coming

You can schedule events based on dates



Source: SAP

SAP Analytics Cloud integration started in 2.5; making more use of the HANA engine such as exception aggregation

 



Source: SAP

You can create a new connection today using Analysis Office 2.5



Source: SAP



Source: SAP

New exception aggregation

 



Source: SAP

Some limitations are shown above

 



Source: SAP

BI platform enhancements include launch workbooks stored in BI platform via URL and passing parameters

 



Source: SAP

Available as of SP5 for BI4.2

 



Source: SAP

It is possible to reschedule scheduling jobs

 



Source: SAP

Schedule based on events - you can trigger scheduling jobs in Analysis Office



Source: SAP

Autocomplete enhancement of table design

 



Source: SAP

You can use VLOOKUP



Source: SAP

You can use full member selector instead of the simple to use search and range options



Source: SAP

Filter by range is possible - has some performance impacts



Source: SAP

Planned for SP1 and BW support package



Source: SAP

Rendering dates Excel natively - and also the chart rendering is correct

Question & Answer










Q: Will the slides be available?



A: Slides are already posted at https://discuss.asug.com/docs/DOC-48711 - please logon to asug.com first



Q:How do we connect to BO Universes?



A: you cannot connect to universes; use Live Office for this



Q: when releasing new version of Analysis, do we plan to apply cloud model and premise both ? seems that analysis office 2.6 is the case?



A: not sure I follow- it works with with on-premise and cloud models



Q: When is convergance of Analysis & Live Office planned for?



A: It is part of the product convergence planned for 2018/2019 - see https://www.sap.com/products/roadmaps.products-solutions.html#pdf-asset=0430a022-c37c-0010-82c7-eda7...













Q: Can we create variables with "IF" statements in it? Can we move key figures to be amongst the dimensions & not stuck at the end of the table?



A: It should work; similar to VLOOKUP



Q: AFO publication bursting supported yet?



A: yes, part of this presentation - BI4.2 SP5



Q: Can we "rename" dimensions for reporting without going back to the bex query in AO?



A: Yes, already there for quite a while



Q: Is there a way to set AO so it does not fetch all Key Figures/Measures by default? This was easy in BEx but does not exist in AO. It displays all by default



A: BEx - handled in query; if HANA - this defaults; no way around - could use query views



Q: Is there any plan to support parallel data source execution ?



A: can do that already in HANA out of the box; BW does not support it



Q: Not just publication....but bursting like Webi. I must have missed it....



A: bursting = publications; referring to something else?











Q: With BW 7.5 and BEx sunset in 2021, will AO convert workbook b enhanced?

























5 Comments