Reviewing what is new in BusinessObjects Analysis Office 2.4
I do not see where the official SAP Help has been updated yet but I did notice the software was available for download this morning:
So I will only cover what I have observed so far.
Table Rule Design Editor
The table rule design editor now has a copy button (far left)
You can link dimensions across crosstabs, and this means when you filter on the main cross tab it will also filter and navigate across the linked cross tabs. They should share common dimensions
You can see the above icon indicates they are “linked”
You can group dimensions to “dependent” cross tabs. One cross tab becomes the “main”.
The common dimension appears only once after grouping
You can see crosstab 1 is main, crosstab 2 is dependent
You can ungroup in the dependent cross tab or from the ribbon:
You can only navigate in the “master” cross tab
You can define a dimension to be “no display” in the Properties panel
You can select operations allowed while protecting workbook
Exclude Copy & Paste from Clipboard or File
You can explicitly exclude members from a file or a range
Filter based on copy clipboard:
More to come, especially after the official SAP Help is released.
Tammy, as always great summary!
Any update on new/changed EPM features in AO2.4?
Hi Aaron -
Thank you for reading and commenting.
I believe there is quite a lot planned for EPM but since I don't use it and I didn't try it out, I will defer to SAP documentation (which isn't updated yet for 2.4)
Is the documentation available now? I do not see much info on SAP help
Cathy - SAP changed URLs on their help - it should be at https://help.sap.com/viewer/product/SAP_BUSINESSOBJECTS_ANALYSIS_OFFICE/188.8.131.52/en-US
Thank you Tammy
Will there be any BOP ANALYSIS FOR OFFICE 2.4 training course coming up ?
Thanks Tammy. It's a very good abstract view for AO 2.4 features.
Waiting for the more updates on AO 2.4 🙂
Hi Tammy, thanks for the summary.
The display option for a dimension with "no display" seems already available at 2.3 SP2 (which I'm using now). I didn't notice it before though 😉
Thanks Tammy, really great that you already did this reveiw. There is a What's New on Af0 2.4 going on as we speak. The recording will be availableshortly
Any information on the Comments option? It's grayed out even when connected to the BIP...
Stephen - the documentation is not updated yet, but my guess would be that that feature is dependent on an upcoming BI4x support pack
A good blog as ever! I had a play with the customize user interface option which is also new in 2.4.
We have an Excel Add-In that inserts product images into an Analysis workbook. Previously this was called from the standard Add-Ins tab so I wondered if this would be a good use case.
The config screen is easy to use and allows you to create custom Analysis Ribbons by either removing options you don’t want or adding new (non-Analysis) ones.
Once you have created and saved your new ribbon you need to make it your default. The original is not changed. The next time you start Analysis, your new custom ribbon will be active.
In our case, once we have run our Analysis report we can add the product images by clicking the new ‘Product Images’ button within the ‘Insert’ group.
The profiles you create are stored at the following location by default:
C:\Users\[user]\AppData\Roaming\SAP \Cof\User Interface
As an administrator, you can define a specific profile for your company and provide it to your end-users by copying the profile at the following location:
There is a good ‘how-to’ video created by SAP which guides you step-by-step.
thank you for this Information.
I don't think that this is a really good approach from SAP in case of planning button group. In 2.3 it was possible to show / hide planning buttons via a setting in AO without restart. That was possible per user because only some users need planning and most don't.
Now we have to set profiles per user (which means deploying per user) depending on the tasks of the user. The alternative is that the user has to do this settings byself. Which is - in case of planning group - much more complicated than before. Create a new name for a profile, make settings, save profile, make it to the default profile, restart AO.
In case of excel macros this macros are connected to an excel file normally which means it makes more sense that one use buttons in excel files where the macros are stored per file. Maybe I miss the point of this new approach. It think it would make more sense to store this data in combination with the Excel file instead of a general profile if there is this highly customizable approach. Furthermore there should be general settings like planning group on or of which are more important than the settings in the file.
Has anyone an idea what "Arbeitsstatus" "Work Status" in the planning group is for? I have not installed the BPC part. This look like the workflow feature of BPC. This should not be available, should it?
Thanks for sharing this cool feature you have enabled in AO to display product images. We too have a similar need and the way I was going about it was to store product images as documents on master data by enabling the document property flag on the Infoobject and then uploading the images.
However I am not sure how your custom button is able to pull the images into your report and would appreciate if you could share some more insight into this.
I'm not seeing the option to group crosstabs in my right click menu. I'm on AO 2.4. Are there any backend prerequisites for this?
Bart - grouping requires BW 7.5 SP06
I am surprised the Official SAP Help is not there yet...
you wrote (I miss the reply / quote button for your original post):
“You can link dimensions across crosstabs, and this means when you filter on the main cross tab it will also filter and navigate the linked cross tabs.”
What do you mean with navigate?
I have tried the filter feature and it works. But if I move a linked dimension to rows / columns this has no effect to the linked crosstab.
The Group table feature is very nice. This is a kind of a virtual MultiProvider / HCPR in AO based on choosen dimensions.
I have not found the unlink option for the dimensions in two grouped tables up to now (this seems to be not possible up to now – maybe this is a bug). Separate does work if link is used without group feature but in combination I don’t find the separate button for a single dimension. If you ungroup and group again the links which are set before are kept.
Hi Torsten - I meant filter - and you are right, it works. I am sorry for the delay in replying, as I was traveling last week
There are 4 new parameters in the config file where I have found no documentation up to now:
And there is another one which I have found in the notes (2.4 SP1):
2398492 - AO 2.x: Enforcing Datepicker for calendar day variables
Does anybody know how to hide or deactivate the Customize User Interface button?
I could not find any parameter related to this, so i would i assume this is not possible..
I think we have to wait until the admin guides are published; the ones at help.sap.com point to the earlier 2.3 version
Does anyone know how to set the Company Profile as Standard Profile for users? I tried to set the path in the C:\ProgramData\SAP\Cof\Cof_app.config file but it did not work.
Thanks and best regards
Hi Astrid - would you please post this question at answers.sap.com so the community can reply/see it? Thank you
Its really awsome Tammy
Thanks for sharing. I was looking for such described information about the latest version as we are planning to upgrade to this.
what is the resolution for the below note ??????????????????????????????????
Using a planning function of type upload leads to an error message like “File doesn’t exist”.
You are unclear which tools currently support this type of planning function.
BW, File Upload, Planning Function, “File doesn’t exist”
Reason and Prerequisites
In general Analysis Office supports all types of planning functions provided by BPC Embedded or BW Integrated Planning. This covers the concept of variables and filters. The provisioning of an upload file is not available. As a consequence this planning function of type upload is not supported.
We are aiming at supporting this planning function type in the future. Please check the “What’s New” section of Analysis Office or similar sources for an update.
Hi Sanjay - I'm sorry to hear about the error you are experiencing.
I don't work for SAP and I am not that familiar with planning since I do not use it
If you have question about it please create a new discussion/question at answers.sap.com
Could you explain how Exclude member filter values works step by step? I am following below approach but it doesn't work for us and we are using AO 2.4
i would like to exclude several members in the range selection over "not equal to".
Do you know a way without having to put an exclamation mark in front of the number?
If i paste it from the clipboard without an exclamation mark, it becomes too "equal to", although i
chose "not equal to"
Hi Christoph - thank you for reading/replying
Off the top of my head, I don't know; I recommend asking this question at answers.sap.com so others in the community might see...they may have a better answer.
thank you for your answer.