Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
TammyPowlas
Active Contributor

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:

The first type of Waterfall Chart shows up as follows:

Here is an example of a pivoted Waterfall Chart:

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

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:

Read Access Mode

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

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:

More to come.

13 Comments
Labels in this area