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?
A: Please see https://blogs.sap.com/2017/07/12/automated-mass-migrationconvertion-of-bex-workbook-to-ao-2.x/
- SAP Managed Tags:
5 Comments
