Product Information

Tammy Powlas

December 3, 2019 2 minute read

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

12 Comments

You must be Logged on to comment or reply to a post.

Shruthi Srinivas

February 4, 2020 at 9:00 pm

Hi Tammy,

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

Thanks

Shruthi

Tammy Powlas

Blog Post Author

February 5, 2020 at 9:08 am

Hello Shruthi -

Thank you for reading this.

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

Zaheeruddin Mohammed

February 7, 2020 at 6:16 pm

Hi Shruthi,

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

https://help.sap.com/viewer/7dc219dcd5ac483682a57e1cf9f2369c/2.8.0.0/en-US/f0ae048d75a6424e97865b5a6480dee9.html

Nishil Samani

February 5, 2020 at 2:52 pm

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?

Tammy Powlas

Blog Post Author

February 5, 2020 at 2:54 pm

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

Karan Sehjpal

February 8, 2020 at 6:41 am

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.

Thanks

Dagva Baidaev

May 6, 2020 at 7:45 am

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.

Tammy Powlas

Blog Post Author

May 6, 2020 at 8:09 am

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

Thank you for reading my blog

Renato Silva

July 9, 2020 at 5:55 pm

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?

Tammy Powlas

Blog Post Author

July 9, 2020 at 6:00 pm

Hi Renato - thank you for reading

I recommend checking the platform availability matrix at https://support.sap.com/content/dam/launchpad/en_us/pam/pam-essentials/AO_28_PAM_Additional_Info.pdf (s-user logon required) and see if your HANA is in "maintenance" - page 8

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

Arpan Gupta

August 4, 2020 at 5:57 am

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?

Regards,

Arpan

Tammy Powlas

Blog Post Author

August 4, 2020 at 7:58 am

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

Product Information

Trying the Updates on SAP Analysis Office – 2.8

Assigned Tags