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

By admin Last updated Feb 9, 2022

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

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-eda71af511fa&pdf-page=11

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/

Would you like to access Full Article?

If you are already a member in this website, Please Click here to loginIf you are not yet a member, Please Click here to Sign up

if you have any questions don’t hesitate to contact us from the Button bellow

New NetWeaver Information at SAP.com

Very Helpfull

User Rating: Be the first one !