Part 1 is A First Look at SAP BusinessObjects Analysis Edition for Office – Beta 2.0 and on this blog covers table design improvements available in beta version 2.0 for Analysis Office.

Now you can insert rows and columns in the crosstab.  Some background is shown below:

/wp-content/uploads/2014/07/1fig_451242.png

Source: SAP

To do this you need to edit the registry as shown below:

/wp-content/uploads/2014/07/1regedit_502602.png

Figure 1

You need to set the TableInterface to True

/wp-content/uploads/2014/07/2table_502603.png

Figure 2

Figure 2 shows the crosstab

/wp-content/uploads/2014/07/3rowafter_502628.png

Figure 3

Figure 3 shows when I right click on a row I have the option to insert the row before or after.

/wp-content/uploads/2014/07/4insertrowresult_502629.png

Figure 4

Figure 4 shows the results of inserting a row “after”

/wp-content/uploads/2014/07/5insertcolumn_502630.png

Figure 5

Figure 5 shows the option of inserting a column.when selecting the “title” dimension, in this case, “Project”.

/wp-content/uploads/2014/07/6result_502631.png

Figure 6

Figure 6 shows the results of inserting a column.

More to come and learn more about Analysis Office at SAP TechEd && d-code:

EA265 Hands-on:

SAP TechEd && d-code Las Vegas | October 20–24, 2014 | Home

EA117 ASUG Analysis Influence Council:

SAP TechEd && d-code Las Vegas | October 20–24, 2014 | Home

Monday, October 20th, ASUG will host a hands-on BI session – more to come soon.

To report this post you need to login first.

11 Comments

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

  1. Peter Chen

    Thanks, Tammy.

    This capability is a big step forward bringing us closer to BPC/EssBase realm. Hence an important prerequisite towards the dream of merging AO with EPM add-on…

    can’t wait.

    Thanks again.

    (0) 
  2. Stephen Hobbs

    Why do so many settings in Analysis require register setting changes? It’s not something that we actively encourage in our company and I doubt if some of the users have the capability to make these changes? Can they be set in a master deployment package? We wouldn’t expect the user to make these changes and couldn’t make the changes on their behalf. Can they not be built into the front-end?

    Thanks,

    Stephen

    (0) 
    1. Tammy Powlas Post author

      I am not an expert in installation – maybe it will be changed by GA version.

      This is an explanation of how it works in Beta.

      (0) 
      1. Stephen Hobbs

        Hi, I appreciate that Beta to GA may change, but even in the current 1.4 GA version there are many options that need to be set in the Registry and I just wonder why this is. When I speak to our Infrastructure team about this there is always a lot of sucking of teeth and shaking of heads…

        (0) 
        1. Patrik Maag

          Hi Stephen,

          Thank you for your feedback! We are already working on simplifying and improving the settings framework of AO 2.0.

          I can’t make any promises yet, but chances are good that 2.0 (GA) won’t need to access the registry anymore (for settings).

          Best regards,

          Patrik

          (0) 
  3. Vasu Mullapudi

    Hi Tammy,

    That’s a great option. Is this available only for AO 2.0 (beta). Pl let me know if there is a work around to get this for any versions of 1.4. Thanks.

    (0) 
    1. Tammy Powlas Post author

      It is only available in 2.0

      I am not aware of any work arounds in 1.4 – you may want to create a new discussion thread in the forum to see if the community has any ideas

      (0) 
  4. Uchenna O. Obiji

    Hi Tammy,

    Do you know if the issue of not being able to protect workbooks is resolved in 2.0 ?

    In the correct release 1.4, protecting any sheet in a workbook disables all BO functionalities.

    (0) 
    1. Tammy Powlas Post author

      Uchenna – I am sorry for the delay in replying

      I tried it; some functions are disabled but I think it depends on what you want protected in the worksheet.  For example, I protected the worksheet but I was still able to do a Smart Copy to Design Studio

      (0) 

Leave a Reply