Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
bigonnet
Advisor
Advisor
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.
14 Comments
former_member365843
Discoverer
0 Kudos
Hi,

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

Thanks.
bigonnet
Advisor
Advisor
hI Sebastien,

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

Best Regards

Jeanne

 
arda_alkan_dh
Explorer
0 Kudos
Hi Jeanne,

 

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

 

Best regards

Arda
bigonnet
Advisor
Advisor
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
aditya_ponnala
Participant
0 Kudos
Hi Jeanne, I cannot see this setting: Allowinsecureconnections. Where can if find this?

Thanks!
daniel_hostettler
Discoverer
0 Kudos
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
bigonnet
Advisor
Advisor

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

daniel_hostettler
Discoverer
0 Kudos


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


mfoeken
Active Contributor
Hi Jeanne,

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

 

Kind regards,

Martijn van Foeken | Interdobs
former_member377358
Participant
0 Kudos
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
tingchuen_thong2
Discoverer
0 Kudos
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

 
bigonnet
Advisor
Advisor


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

 

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

 

Regards,

Florence
tulikashaw
Participant
0 Kudos
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.