Skip to Content

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.

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