Skip to Content
Author's profile photo Tammy Powlas

SAP BusinessObjects Analysis, Edition for Office 1.4 Now GA, Part 2

In my blog last Friday, I discussed installation steps and briefly just some of the new features.  In this blog, I will review some of the other new features that came with this release, which was GA last Friday.

We have seen many questions regarding Analysis Office 1.4 – please review the Product Availability Matrix. Analysis Office 1.4 32 bit and 64 bit supports MS Office 2013.

Waterfall Charts

In the past, Analysis Office supported charts in Excel.  Now it is offering two types of Waterfall Charts:

/wp-content/uploads/2013/06/1waterfall_225972.jpg

The first type of Waterfall Chart shows up as follows:

/wp-content/uploads/2013/06/2waterfall_225973.jpg

Here is an example of a pivoted Waterfall Chart:

/wp-content/uploads/2013/06/3waterfall_226064.jpg

Reset Data Source

In the previous blog, you saw you can launch the BEx Query Designer.

If you make some changes to the crosstab using the Display Panel, you can use Reset Data Source to set the query back to the initial state of the BEx query.

This is a right-click from the context menu, and select Reset Data Source

/wp-content/uploads/2013/06/4resetdatasource_226067.jpg

Selecting Reset Data Source will reset it back to the initial navigation state of the BEx Query.

Note you can also make this setting to reset on opening from the Display panel:

/wp-content/uploads/2013/06/5resetdatasource_226068.jpg

Read Access Mode

Select a characteristic (“aka Member”) and select Members > Access Mode

/wp-content/uploads/2013/06/6readaccess_226069.jpg

You can select only those values with posted data as shown above.

If you show values in Master Data you will see everything, even those without any transactions posted against them.

Note in the User Settings the “Allow Access Mode to be Changed” option must be turned on:

/wp-content/uploads/2013/06/7readaccess_226073.jpg

More to come.

Assigned Tags

      13 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Good one Tammy.

      Regards,

      Rakesh

      Author's profile photo John Baron
      John Baron

      Thanks, Great info.

      Looking forward to your next group of tips.

      Regards,

      John B

      Author's profile photo Gajesh Nagesh
      Gajesh Nagesh

      Hello Tammy,

      An updates on the SSO for analysis for Excel

      Regards

      Gajesh

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hello Gajesh,

      I am not an expert in that area - so please post this in the discussion forum.

      Regards,

      Tammy

      Author's profile photo David Stocker
      David Stocker

      SSO with respect to which platform?

      Author's profile photo Mark Cooper
      Mark Cooper

      Hi

      In case it is of interest - we found that SSO does not work when launching workbook directly from Launchpad (with or without Portal in front).

      Analysis Office  - OSS 1064576/2013 - Failed to Launch with specific file

      Known issue - resolutions:


      1894386 - Analysis Office launcher transactions do not work Found here

      https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F7361706E6F7465735F6E756D6265723D3138393433383626

      Since this is probably not viable for us (upgrade to SP11 for BW7.3) down the bottom of the note it says there is an alternative note:

      1668882 - Note Assistant: Important notes for SAP_BASIS 730,731,740 found here https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F7361706E6F7465735F6E756D6265723D3136363838383226

      Author's profile photo Former Member
      Former Member

      Thank you Tammy, great post!

      I had implemented SAP BusinessObjects Analysis, Edition for Office 1.4 for Planning with IP BW 7.31. You was my inspiration 😀 .

      Thank you again,

      Diego Torres Luyo.

      Author's profile photo Former Member
      Former Member

      Hi Tammy,

      Do you know if it is possible to include result line  in waterfall chart?

      Regards

      Dariusz Lewandowski

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      I am not seeing where that is an option; if you would like to have that I recommend adding it to Idea Place at ideas.sap.com

      Author's profile photo Former Member
      Former Member

      Hi all,

      Is there any way to create a drill down report of analysis office from design studio using a button?like we drill down bex reports from xelsius. tried several ways, couldn't succeed.pls help me out if anyone has implemented.

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi - Design Studio doesn't have this capability - see What is new in Design Studio 1.3 ASUG Webcast roadmap slide for RRI.  It is a planned innovation.

      If you have more questions please create a discussion

      Author's profile photo Former Member
      Former Member

      Hi tammy,

      I was asking if there is any possibility with new features in analysis for office.like we use document link of the file created in analysis for OLAP ,used in design studio component such as button, so as to reflect the filter values on publishing, where as the filtered values doesn't reflect in analysis for office on following the same procedure.

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      ASUG has a webcast today on this topic, so hopefully we'll learn more about the new features later today.