Skip to Content

This is just a subset of what is available.  Here is what I have documented so far:

First you see a pop-up, a GDPR-compliant popup.  How can you switch it off?

You go to the technical configuration

Search for dpp and the settings are shown above

 

Recording:

 

Source: SAP

New optimized formulas are available for “asymmetric” (sometimes known as “butterfly”?) reporting

But please note the prerequisites; I ended up applying several notes in my sandbox for this to work.  Read the SAP Notes (“don’t do as I do, do as I say”) 🙂

If your system meets the prerequisites, you can select data source for defining formulas as shown above

If your system does not meet the prerequisites, you receive a message as shown above

In my example, I selected an InfoProvider

You can see the display panel panes look different, don’t they?

You can see the flag is checked for “Use Data Source Formula-Optimized” on the components tab.

Above is an example of the SAPGetData formula

#RFR is for refresh

 

See recording:

What do you think of the new formula optimized features?

To report this post you need to login first.

9 Comments

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

  1. Jay YM

     

    Hi Tammy,  How is Formula-Optimized any different than what we can do now in AO 2.5 or 2.6?  I mean after we convert the Crosstab using “Convert to Formula”, it become what you have shown on the YouTube.  I am trying to understand in what way it is different in AO 2.7 as a new functionality/feature.  Also, in our previous Planning tools like EVDRE or EPM, after we generate a report in a block, we can override the cell value using a formula, so we have both the range block and a formula in it and formula gets priority over the range block, I still don’t think AO Crosstab can work like EVDRE or EMP.  Please help me understand this.  I have already submitted this on the Customer Influence portal.  Thanks,

    Jay

    (0) 
    1. Tammy Powlas Post author

      Hi Jay – thank you for reading.  Yes, you can convert to formula, the difference in 2.7 is you go into the workbook knowing the formula is optimized.  I am not using planning so I don’t know about EVDRE/EPM (sorry)

      (0) 
      1. Mohammed Toufiq Qureshi

        Hi

         

        I know this question is  not related to this topic.

        I have a requirement  where user requires dynamic charts based on

        the selection(Prompts which are coming from bex) provided by the user

        that to on different level

        1) on level 3 nodes line charts and 2) on level 4 nodes pia charts.

        Regards

        Mohammed

        (0) 
  2. Jay YM

    Hi Tammy,

    Thanks for your reply.  All I am looking for is if we could insert Formula “inside” a Crosstab without it getting registered in Design Rule Tab as a Formula?

    I can do what you demoed putting a SAPGETDATA function in AO 2.5 or AO 2.6 also.

     

    Thanks,

    Jay

    (0) 
  3. Dag Fischer-Nielsen

     

    Hi Tammy.

    After testing 2.7 I have an issue. In earlier Versions this was not a problem. I log on With Windows AD, an execute a Query from BW as normal, but after starting analysis again and execute the same Query from recently used list, I’m now asked for SAP system, even if I first log in With Windows AD. This did not appear in earlier Versions. It’s only happen from recent list.

    Any idea of fixing this?

    Regards

    Dag

     

    (0) 
    1. Tammy Powlas Post author

      Hello Dag – thank you for reading my blog.  I recommend creating a new question at answers.sap.com so the community can better assist; unfortunately I don’t know much about AD to help here.

      (0) 
    2. Phil Pilkington

      Thanks Dag.  Yes, I had the exact same issue while testing 2.7.  I thought perhaps it was our environment but I see we are not the only ones.  We are upgrading to 2.6 for now until 2.7 gets much further along.

      (0) 
  4. Singh Avinash Pratap

    Hi Tammy ,

    I am using formula optimized data Source to develop one of the static report.

    However, I don’t see much improvement in the performance of the report. Please find my analysis below.

    1. Time taken by HANA view to return RAW data :- 19 seconds
    2. Time taken by Report using same datasource in non- formula mode :- 38 seconds
    3. Time taken by report using formula optimized mode – 34 Sec.

    I can see only an improvement of 4 sec to return same number of objects in formula optimized mode.

    Also , I found an interesting analysis . If I am using only one SAPGetData function it is taking 34 sec , which is similar to the report refresh time with multiple SAPGetData functions.

     

    Could you please let me know if we have any other performance optimization method in AO.

     

    Thanks,

    Avinash Singh

    (0) 

Leave a Reply