Skip to Content
Product Information
Author's profile photo Jeanne BIGONNET

Announcing general availability of Analysis Office 2.8

Announcing general availability of Analysis Office 2.8

Analysis Office 2.8 has just been generally available since Nov 29, 2019.

It is the latest and best release of Analysis Office, combining the power of the classic Analysis functionality and the EPM features. Here’s some short overview on the new features.

Analysis Plug-in

As SAP wants to provide a strong office solution on top of SAP Analytics Cloud, the Analysis plug-in release 2.8 continue the Integration with SAP Analytics Cloud and introduces the support of “unbooked data” (capability to view and plan on new member) for data entry and live connection to BW queries and HANA views sources (no intermediate model is created).

Analysis Office plug-in 2.8 also offers new Usability improvements in Variables prompts where direct typing on intervals is now possible or a new sorting of the Variants by «user variance/ public variants”; on the Design panel where the used dimensions are highlighted or displayed by group if desired.

This new release also offers enhancement in Reporting features

This new release also offers enhancements in Reporting features as limitations to formula optimized mode have been removed  (support hierarchies, support two structures queries).

Note formula mode is available for any type of source (BW, HANA, SAP Analytics Cloud…).For more details please read the Analysis Help guide.

In addition, the Analysis plug-in reinforce the Security on data with a stricter handling where users get now a warning when they try to connect to an insecure connection.

A new contextual Help complete these features to fully support user during his navigation.

EPM Plug-in

SAP wants to support the best  customers willing to move from EPM  standalone version to the EPM  contained in Analysis for Office.Then  we have made a structural code change in EPM plug in as we replaced it by EPM add in standalone code.

Main goal is to ensure smooth transition to the  EPM version contained into SAP Analysis for Office. Please read more details in following blog Simplifying the EPM plug-in usage.

In addition, the EPM plug-in provides smaller enhancements on top of BPC source as EPM formulas  can now supports “Key Date” as parameter. See Help.

Assigned tags

      14 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Sebastien Lepeltier
      Sebastien Lepeltier

      Hi,

      Is there a possibility to hide insecure connection warning in customize analysis for end users?

      Thanks.

      Author's profile photo Jeanne BIGONNET
      Jeanne BIGONNET
      Blog Post Author

      hI Sebastien,

      You can specify the expected behavior  for the end user  in Customize Analysis/ Technical configuration/ "Allowinsecureconnections" Settings.

      Best Regards

      Jeanne

       

      Author's profile photo Sivaram Bandaru
      Sivaram Bandaru

      Hi Jeanne, I cannot see this setting: Allowinsecureconnections. Where can if find this?

      Thanks!

      Author's profile photo Ting Chuen Thong
      Ting Chuen Thong

      Hi Jeanne, I could not find this settings, where exactly is it located ?

      I am using AO 2.8 SP1.

      Hear from you soon.

      Regards

      TC

       

      Author's profile photo Jeanne BIGONNET
      Jeanne BIGONNET
      Blog Post Author

      Hi TC, please check   Customize Analysis/ Technical configuration/ “Allowinsecureconnections” Settings, Best regards Jeanne

      Author's profile photo Arda Alkan
      Arda Alkan

      Hi Jeanne,

       

      Is AO connection to a live model in SAP Analytics Cloud supported yet?

       

      Best regards

      Arda

      Author's profile photo Jeanne BIGONNET
      Jeanne BIGONNET
      Blog Post Author

      Arda,

      live connection to BW and Hana are supported but directly to the Query / View .

      Connecting live SAC models is not supported . Best regards

      Jeanne

      Author's profile photo Martijn van Foeken
      Martijn van Foeken

      Hi Jeanne,

      Any information when a live connection to S/4HANA via SAC will be supported?

       

      Kind regards,

      Martijn van Foeken | Interdobs

      Author's profile photo Daniel Hostettler
      Daniel Hostettler

      Hello Jeanne

      I get this message "Insecure Connection" when i use an OLAP connection to the BW system on the BO system.

      Do you have any advice for me on what is causing this message?

      Thank you in advance for your response.

      Best regards
      Daniel

      Author's profile photo Jeanne BIGONNET
      Jeanne BIGONNET
      Blog Post Author

      Hi Daniel , can you please check your BW connection has been properly SNC enabled ? Indeed BW uses an RFC connection to Analysis  which requires to have  a Secure Network communications ( SNC) enabled to be considered as a “secured connection”. Best regards Jeanne

      Author's profile photo Daniel Hostettler
      Daniel Hostettler
      Hello Jeanne
      Thank you very much for your valuable advice. We will check this and if not actively consider implementation at a later stage.
      Best regards
      Daniel
      Author's profile photo Karan Sehjpal
      Karan Sehjpal

      Did you mean a message like this Jeanne BIGONNET.  If then you can click continue of go to file click on analysis -> customize analysis -> technical configuration - > all insecure connections as yes .

       

      You wont see this popup in future.

       

      Thanks

      K

      Author's profile photo Florence Mae Guzon
      Florence Mae Guzon

      Hi

       

      Do you know any way to set the Allowinsecureconnections = YES in all user's machine without going thru each settings?

       

      Regards,

      Florence

      Author's profile photo Tulika Rani Shaw
      Tulika Rani Shaw

      I have same question as well.

       

      For now, I have manually edited the config file and added <AllowInsecureConnections value="Yes" />  to config file. Moved the config file to each Users PC.

      It is manually work.

       

      Any procedure to make the OLAP connection as secure.