SAP BusinessObjects Analysis, edition for Microsoft Office has just been released in its 1.1 version and is available for ramp-up customers. The MS Office edition of Analysis is a premium alternative to BEx analyzer. Version 1.0 was mainly targeted to introduce a new usability paradigm: simple, intuitive, tightly integrated into the Microsoft Office framework. This story is continued in release 1.1, which can be titled “planning release”. It leverages the BW-IP framework of SAP NetWeaver BW 7.x (also note the new features in BW 7.3 such as the new ABAP-based planning modeler) and extends it to an intuitive ad-hoc planning client. You may start your planning workflow within the design panel of Analysis – similar to how you analyze. You can enter new values, write them back to BW, add new lines or use planning functions or planning sequences. Adding new lines is easy – and supported by a value help for the dimension values as well as a validation of new entries with BW master data tables.
In addition to ad-hoc planning, you would certainly build powerful workbooks for planning (or, of course, for analyses). Release 1.1 extends the existing API (application programming interface) substantially. You can use a rich set of functions in your macros and your VBA code that affect the filters or prompts, execute drilldowns, execute planning functions or simply get contextual information on where the cursor is located. This enables you to build sophisticated workbooks targeted to your end users.
Analysis 1.1 runs on top of SAP NetWeaver BW – like the 1.0 release -, but can also connect to SAP In-Memory Appliance (HANA). You can use it stand-alone or you can run via SAP BusinessObjects BI platform. Together with BI 4.0, you can leverage single sign-on offered by the platform and you can interoperate with other clients such as Web Intelligencr, Crystal Reports or the web client of Analysis.
In addition, several continuous improvements features have made it into release 1.1, such as default workbook handling, remove data before saving (enforces refreshing upon opening a workbook), storing and using analysis views (when using BI platform), changing conditional formatting rules/filter by measure, and some more.
You can find detailed information in the “what’s new” guide.