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)

Link Dimensions

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”

Group Dimensions

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

No Display

You can define a dimension to be “no display” in the Properties panel

Workbook Protection

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

Example clipboard:
!ZY0217A
ZY0217B
!ZY0236
ZY0393
ZY0580
!ZY0589
ZY0597
!ZY0611
ZY0633A
ZY0633B
ZY1287A
<ZY1287B

Filter based on copy clipboard:

Result:

More to come, especially after the official SAP Help is released.

To report this post you need to login first.

20 Comments

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

  1. Tammy Powlas Post author

    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)
    Tammy

    (0) 
      1. Tammy Powlas Post author

        Cathy – SAP changed URLs on their help – it should be at https://help.sap.com/viewer/product/SAP_BUSINESSOBJECTS_ANALYSIS_OFFICE/2.4.1.0/en-US

         

        Tammy

        (0) 
  2. Philipp Schornberg

    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 😉
    Philipp

    (0) 
  3. Tammy Powlas Post author

    Stephen – the documentation is not updated yet, but my guess would be that that feature is dependent on an upcoming BI4x support pack

    (0) 
  4. Stephen Hobbs

    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:
    C:\ProgramData\SAP\COF\User Interface

    There is a good ‘how-to’ video created by SAP which guides you step-by-step.

    Regards,

    Stephen

    (2) 
    1. Torsten Wirth

      Hi Stephen,

      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?

      Regards,

      Torsten

      (0) 
    2. Shailendra Tandon

       

      Hi Stephen

      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.

      Thanks

      Shailendra

      (0) 
  5. Bart Verweijen

    hi Tammy

    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?

    Thanks
    Bart

    (0) 
  6. Torsten Wirth

     

    Hello Tammy,

    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.

    Regards,

    Torsten

    (0) 
  7. Torsten Wirth

    There are 4 new parameters in the config file where I have found no documentation up to now:

    • DefaultBWQueryDesigner
    • DoSelectorHierarchyExplicitSelection
    • AutoCompleteFetchMemberLimit
    • HanaHttpConnectionTimeout

    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

    (1) 
  8. Michael Hamm

    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..

    Regards,
    Michael

    (0) 

Leave a Reply