Product Information
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:
SAP Help Link is here
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
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
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
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?
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.
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
K
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.
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
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?
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)
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
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