Skip to Content
Product Information
Author's profile photo Tammy Powlas

Trying the Updates on SAP Analysis Office – 2.8

Analysis Office 2.8 was released on Thanksgiving Day, November 28; see Jeanne Bigonnet’s blog here. Where possible, I tried them out below.

Source: SAP

Analysis – Integration into SAP Analytics Cloud – – now supports access to online SAP BW and SAP HANA sources (live connection)

Source: SAP

You need to select “Enable Live Data Connections”


Display Grouped Dimensions in Design Panel:

Source: SAP

Notice you can view the grouped dimensions by technical names

Highlight used dimensions on the cross tab; so in screen shot above Calendar Year/Month and Sales Organization are highlighted as they are on the crosstab.

Select Access Mode in Property View

Note this is only available if you set AllowChangingAccessMode checkbox on in the Technical Configuration (File > Analysis > Technical Configuration):



SAP Analytics Cloud Planning feature:

-if a new master data is created in SAP Analytics Cloud , it’s possible to plan on it from Analysis Office

Prompts for Variants:

Variants are now alphabetical

Stricter handling on unsecure connections:

In this release, SAP Analysis Office is attempting to enforce secure connection with a warning as shown above.

Clear Prompts

You can see in lower left part of the screen you can clear all prompts button


Information from release note 2679473:

Number Title
2796364 ALL: Metadata refresh does not reconnect reports
1518359 SAP BusinessObjects Analysis Office & BIP Add On Release schedule
2844304 ALL: Insert Member inconsistency
2849398 All : Context dimensions in vertical pane disappear
2848359 ALL: Unable to filter member selection using the “Like” operator
2860695 BPCNW: Serverinfo in connectioninfo should not be null when using SSO
2837403 ALL: Error message when performing refresh worksheet if the worksheet has an Excel Sorting
2821516 ALL: Workbook Context Prompt not shown from web
2839218 ALL:Cannot delete filled out comments or data
2812820 ALL:Always show Member Selector as Flat List when filtered
2766548 ALL: Report data incorrect when back to online
2768722 ALL: Duplicated members in page axis when several members selected
2734922 ALL: Check Syntax in Custom Member Editor
2728867 ALL: Limited set of EPM Excel functions in Ukrainian interface

SAP Help Link is here


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Shruthi Srinivas
      Shruthi Srinivas

      Hi Tammy,

      How do we make sure the secure connection pop up does not come up each time - Stricter handling on unsecure connections:




      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hello Shruthi -

      Thank you for reading this.

      You have a good question; I don't know the answer - I recommend asking this at

      Author's profile photo Zaheeruddin Mohammed
      Zaheeruddin Mohammed

      Hi Shruthi,

      You can refer below to fix the insecure pop-up.

      Author's profile photo Nishil Samani
      Nishil Samani

      Hi Tammy,

      Do you know if the repeat headers on the cross tab has been fixed?

      I see the posted vs sap bw master data is now there.

      Does that mean finally for composite providers that are using hana views, we will finally get to see only posted values in the prompts rather than the full suite of master data?

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi - thank you for reading & commenting - I am not using HANA views right now; I recommend posting this as a question at so the community may respond.

      Author's profile photo Karan Sehjpal
      Karan Sehjpal

      HI Tammy Powlas


      can you share an example stating how to use grouped dimension & only values with posted data. It will be helpful because here in the picture its simply a feature which is showing. I have installed and could not figure out the way to use these.




      Author's profile photo Dagva Baidaev
      Dagva Baidaev

      Hi Tammy,

      There is a capability in Hana Studio to group Measures in Composite Provider.

      Could you please clarify,

      this new feature about dimension grouping can group Measures

      if we use Local Hana connection?


      Thank you in advance!


      Best regards,

      Dagva Baidaev.

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hello Dagva - I haven't used Analysis Office against HANA views, so I don't know; I recommend asking this at

      Thank you for reading my blog

      Author's profile photo Renato Silva
      Renato Silva

      Hey Tammy, hope you are doing fine.


      I'm currently using Analysis for excel 2.8. I created a SAC connection and made sure to check the live connection checkbox. But I still can't see any SAC model that utilizes the HANA Live connection. I'm currently using hana 1.0. Do you think this might be the reason?

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi Renato - thank you for reading

      I recommend checking the platform availability matrix at (s-user logon required) and see if your HANA is in "maintenance"  - page 8

      If it is I recommend posting something at with your details (e.g. HANA 1.0 SPS12)

      Author's profile photo Arpan Gupta
      Arpan Gupta

      Hi Tammy,

      I am using AO2.8 SP3. I am able to connect SAC via it. We want to now roll it out to all users, So that they need not to configure it in the connection list manually. How should I proceed? which config file should contain this entry?



      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hello Arpan  I am not sure; I recommend asking this as a question at to see if the community has some ideas