We had three ASUG BI-related roadmap sessions going on at this time so I feared attendance would be low at this session.  Fortunately the ASUG Annual Conference attendees showed up at this session.  Please note the usual legal disclaimer applies that things in the future are subject to change.

1fig.gif

Figure 1: Source: SAP

 

Figure 1 shows the added value of Analysis Office, including the ease of use with the Design Panel. Some gaps that still exist with Analysis Office include broadcasting and documents.

2figroadmap.gif

Figure 2: Source: SAP

 

Figure 2 shows the latest roadmap, with a beta version coming out sometime this month.

3figunifiedplanning model.gif

Figure 3: Source: SAP

 

Figure 3 covers support for the unified planning model.  This is a "gradual convergence".  See Unifying BPC NW and BW-IP

4insertcolumn.gif

Figure 4: Source: SAP

 

Figure 4 shows a demo of the upcoming Analysis Office 2.0 with the ability to insert a column in the crosstab.

5designpanel.gif

Figure 5: Source: SAP

 

Figure 5 shows another demo example of the new design/display panel, or an enhanced side panel with the ability to change the formatting/properties.

 

The following slides were NOT covered during this session but in another session:

6planned.gif

Figure 6: Source: SAP

 

Figure 6 shows planned innovations (meaning subject to change, subject to legal disclaimer) for Analysis Office.

 

7liveoffice.gif

Figure 7: Source: SAP (Planned Innnovations)

 

A common question is when will Analysis Office support Universes?  No news here but Figure 7 shows upcoming updates for Live Office/UNX.

 

Lastly, one of the reasons I wrote this blog was to support Your mission, should you decide to accept it...Marilyn Prattmission to blog about the event.  I hope others will share their experiences as well.

Hello everyone,

 

one of the big hurdles that customers face before converting from BEx Workbooks to Analysis Workbooks is the effort needed to migrate many workbooks as the standard options only allow us to go one workbook at a time. All the repetitive tasks for each one of the converted Workbook also increases the hurdle to go for Analysis for Office. SAP Consulting has now come up with automatic tools to reduce the manual effort in migration projects.

 

One of the tools allows to to migrate all BEx Workbooks in specific roles to Analysis Workbooks:

AO_Roles.png

 

You can also configure the tool to do repetitive tasks, like saving all workbooks with a specific Prefix/Suffix, saving the Workbook to the original role or to another one, or also convert the BEx Navigation Pane to Analysis formulas:

AO2.png

 

 

I believe with all this settings the migration is less error prone and of course it reduces the amount of manual effort involved in a migration project. Why do I say "reduce" and not "eliminate"? Well because there can be very complex workbooks with VBA Code for example that require manual intervention.

Other areas of mass migration include the BEx Query Migration, which contains an application log and makes backups of your 3.5 queries, which is very handy in order to recognize problematic queries:

query2.JPG

 

And the BEx Workbook (from 3.5 to 7.X) migration, which also has a nice a detailed log of what was done:

WB.JPG

 

This tools are very interesting for customers that are still on BEx 3.5 because starting with SAP NetWeaver BW 7.4, the BEx 3.5 tools will not be supported any more.


Thanks for reading.

Victor

This is part 2 of ASUG Analysis Office Roadmap Webcast.

 

Part 1 is Analysis Roadmap Updates from ASUG Webcast Part 1

 

Everything in the future is subject to change and the usual legal disclaimer applies.

 

Beta Preview - these slides are a preview of Beta upcoming version, subject to change

1fig.png

Figure 1: Source: SAP

 

Figure 1 shows new table design, adding an Excel formula for complete row

2fig.png

Figure 2: Source: SAP

 

Figure 2 shows the planned sidepanel.  The multi select feature planned for after beta

 

Figure 2 shows how it extends the side panel

 

It is similar to the Query Designer

3fig.png

Figure 3: Source: SAP

 

Figure 3 covers new HANA access with the InA access, and the unified model.

4fig.png

Figure 4: Source: SAP

 

Figure 4 shows the ability to load ribbon without loading the complete add-in

 

Beta is planned for end of June

 

Question and Answer

(note there were several questions, can't vouch for 100% accuracy in answers (typing)

 

Q: When can we expect to see scheduling "query prompt support" in Analysis for Office?

A: cannot confirm 100%, but we're currently looking for resources to deliver it by end of the year.

________________________________________________________________

 

Q: When will SSO to HANA data sources with Analysis for Office be added? Right now, we have to input the password manually or configure  BOBJ to handle the HANA credentials.

A: Coming in planned innovations

________________________________________________________________

 

Q: Is Analysis edition for Microsoft Office being deprictated like LiveOffice is due to the new Microsoft product and partnership?

A: No - Analysis Office is still for BW/BEx Data Query sources and SAP is planning to provide .UNX support for Live Office -

A: see Q&A for roadmap here SAP BI Roadmap Future Direction - ASUG Webcast Part 3

________________________________________________________________

Q: When will the support for universes be available on Analysis for MS Office?

A: Not listed on this roadmap; .UNX support is planned for Live Office - see Q&A SAP BI Roadmap Future Direction - ASUG Webcast Part 3

________________________________________________________________

Q: When are planned innovations (slide 14) being looked at for having the deployment completed?

A: Standard SAP answer for roadmaps is 6-18 months for planned innovations

________________________________________________________________

 

Q: What about Excel 2013 support ? Are there any plans to provide integration between PowerQuery/PowerPivot and BW Queries as datasource ?

A: Excel 2013 is supported now per the PAM at service.sap.com/PAM

No plans to provide integration for PowerQuery/PowerPivot

________________________________________________________________

Q: One of slides says that you can transform Analysis Office Apps to iPad Apps using Design Studio (DS). We can export to Design Studio but it does not seem to use the iPad template in DS but just a normal web template in DS. Am I missing something?

A: No, you are not - have you tried Smart Copy Paste to Design Studio to see if it can use the template?

________________________________________________________________

Q: Will Analysis Office have the same functionality that BPC has today for planning?

A: AO does not take the place of BPC.  The EPM Excel client that can now be used to visualize BPC data and AO will start merging functionality

________________________________________________________________

 

Q: If you add the empty row / columns will they stay there if you save the workbook and refresh later?

A: Yes the Beta version functionality enhancing the table crosstab structure that allows the empty row/columns to be used for formula and save the formulas with the workbook

________________________________________________________________

 

Q: Is the scheduling feature available in the Analysis, edition for OLAP as well?

A: No, and it is not planned.  Look to Design Studio for the future

________________________________________________________________

 

Q: Are there any SAP "Best Practice" documents for hosting BW-based Analysis for Office content within the SAP BO-BI 4.1 Launchpad interface..? (eg. Add-On Server/Services, User Rights & Preferences, Desktop settings & config).

A: Direct this to the SAP BI Platform team...

________________________________________________________________

 

Q: is there any documention on security using Analysis Office against HANA Calculation views

A: Nothing specific for Analysis Office - security for HANA - similar to BW  - leverage BW security infrastructure

________________________________________________________________

 

Q: Did you say that there is a required BI 4.1 add-on install in order to use the new scheduling feature within Advanced Analysis 1.4?

A: yes

________________________________________________________________

Q: Follow-up to my question: Install on the server or client machine?

A: On the server

________________________________________________________________

Q: Does Analysis Edition for OLAP get additional formatting options, Similar to Webi 4.0?

A: Only limited developments going on for A-OLAP - with AO enhancements - if clients could allow - could expose features and - not working yet

________________________________________________________________

 

Q: Does Analysis for Office support HANA unbalanced hierarchies?

A: Yes

________________________________________________________________

 

 

Q: Can you clarify the filtering limitation on the new scheduling feature?

A: It doesn't support prompts

________________________________________________________________

 

 

Q: Any plans to restore 'missing' BEx workbook functionality? (e.g. Back to Start, Drill Across Sheets)

A: In some ways already there - reset data source ; Undo button several; if others - use idea place at ideas.sap.com

 

Related:

SAP BusinessObjects BI 4.1, SAP BW, and SAP BW on HANA - All in One Day Hands on Full Day- see

Jump Start ASUG Annual Conference SAPPHIRE with a Pre-Conference Session - Back and Better than Ever

Preview of ASUG Annual Conference 2014: Focus on Analysis Office/OLAP/Predictive

 

ASUG at SAP d-code:

If you have an  Analysis story to share, ASUG invites you to submit an abstract for SAP dcode for Las Vegas (aka SAP TechEd) - call for sessions is open now through May 25th - follow this link to create a speaker account where you can formally submit your proposal, review important deadlines, and other general information about SAP d-code.

ASUG had a webcast on the Analysis clients today, mostly about BusinessObjects Analysis, MS Edition for Office.

 

Please note the usual legal disclaimer applies that anything in the future and discussed here is subject to change.

 

Overview

1fig.png

Figure 1: Source: SAP

 

Figure 1 shows the Analysis "Family"

 

Analysis Office is integrated with MS office family – Excel & PowerPoint

 

Design Studio  is the web application for dashboards.

 

Analysis OLAP Web Client, Edition for OLAP > the development is mostly complete

2fig.png

Figure 2: Source: SAP

 

Design Studio can consume universes as shown in Figure 2.

3fig.png

Figure 3: Source: SAP

 

Figure 3 shows a Power User – a controller to create his own calculations

 

You can use Analysis Office as a design environment for creating interactive workbooks to share with a business user – create buttons, etc.

 

You can also use it to provide guided navigation for a business user

 

You can use it for creating PPT presentations.  It also supports BW Integrated Planning.

 

3fig.png

 

Figure 4: Source: SAP

 

Figure 4 shows there are no changes to the BEx queries.

 

Conversion from BEx Web is planned for Design Studio.

 

BEx tools are in maintenance mode per Figure 4.

 

 

Analysis Office

Been on the market for a few years

4fig.png

Figure 5: Source: SAP

 

Latest release of Analysis Office 1.4 was released last year

 

It included a minor release for LCM and SSO

 

It added interoperability with Design Studio

5fig.png

Figure 6: Source: SAP

 

Figure 6 shows scheduling.  It does not support prompts – when will this occur – SAP is trying to get resources to do this in the short term.

5fig.png

Figure 7: Source: SAP

 

Figure 7 shows it is very complex project now – on the right side

 

They are changing access to HANA.  Today use ODBC approach via SQL to HANA and this has limitations

 

They decided to directly access HANA engine

 

This new approach will have SSO to HANA

 

It includes catching up with BW – regarding unified planning model

 

Table design – add empty rows, columns, change styles for specific cells

 

Comments API are coming in future direction

 

Lumira work – for Lumira Server – store Analysis workbooks on Lumira Server

8fig.png

Figure 8: Source: SAP

 

Figure 8 shows the combined planning model

 

Unified Excel Client is superset of Analysis & EPM Excel client, with move to single Excel w/ 2 ribbons to feel like the same client

 

To be continued..

Related:

SAP BusinessObjects BI 4.1, SAP BW, and SAP BW on HANA - All in One Day Hands on Full Day- see

Jump Start ASUG Annual Conference SAPPHIRE with a Pre-Conference Session - Back and Better than Ever

Preview of ASUG Annual Conference 2014: Focus on Analysis Office/OLAP/Predictive

 

ASUG at SAP d-code:

If you have an  Analysis story to share, ASUG invites you to submit an abstract for SAP dcode for Las Vegas (aka SAP TechEd) - call for sessions is open now through May 25th - follow this link to create a speaker account where you can formally submit your proposal, review important deadlines, and other general information about SAP d-code.

Summary

  • BEx Analyzer widely used as the MS Office integration tool to analyse multidimensional data from SAP BW.
  • SAP have clearly positioned Analysis, edition for Office (AfO) as the "premium alternative" and eventual replacement to BEx Analyzer.


Purpose

  • Understand if there are any gaps in functionality.
  • Understand what benefits could be gained by adopting now.

 

Image01.jpg

 

Note: At point of comparison, the following versions of the tools were evaluated.

  • Analysis, edition for Office 1.4 SP6 (14.6.2960)
  • BEx Analyzer 7.30 SP3 Revision 1906

 

Findings

Intuitive UI (larger buttons, contextual information, visual cues).

Current feature set is comprehensive and provides good coverage for typical BEx Analyzer users.

There are some features from BEx that are still lacking from Analysis. Those identified are planned for future releases (e.g. variable personalisation, variable history).

In addition to the improved UI, there are many features that are only available in Analysis that could enable faster and smarter ways of working.

 

 

Comparison: Select a Data Source

Recently used queries are immediately visible.

Ability to leverage OLAP connections defined in SAP BO (e.g. HANA)

Interoperability across BI platform via Analysis Views.

Support for multiple data sources.

Image02.jpg


Comparison: Prompts

Toggle display of all optional prompts at once via [Display] button.

Toggle display of specific optional prompts via pins.

Variable Personalization.

Variable History.

Image03.jpg


Comparison: BEx Text Elements (Information)

Not constrained where/how information displayed.

Drag and drop dynamic text elements directly into worksheet.

Info Field can be used for quick access to common elements.

Image04.jpg


Comparison: Filters

Improved UI enables users to identify filters at a glance.

Image05.jpg


Comparison: Navigational State

Improved UI facilitates faster workflows (no need to right click and access "query properties").

Quick access to attributes by expanding [+] sign.

Analysis pane visible by default and can be toggled via a single click.

Intuitive Columns, Rows & Background consistent with Analysis, edition for OLAP.

Image06.jpg


Comparison: Undo/Redo

Multi-step undo/redo.

No longer need to undo one navigation step at a time, able to jump to a particular state.

Image07.jpg


Other Benefits

Toggle automatic refresh.

Image08.jpg

Schedule (broadcast) via BI platform.

Image09.jpg

PowerPoint publishing.

Image10.jpg

Conditional Formatting.

Image11.jpg

Save workbooks to BI platform.

Image12.jpg

 

Unified "Design Mode" - no need to switch between consumption and design.

Support for multiple data source (e.g. multiple BEx queries in a single worksheet, combination of BW & HANA, etc)

Interoperability with Design Studio (e.g. prototype a web application).

 


Conclusion

  • Existing users who are familiar with BEx Analyzer will find the transition to Analysis relatively smooth. With a familiar MS Office UI, comprehensive feature set and overall improved design, unlocking value out of your enterprise DWH should be made even easier.

 

  • Analysis specific features such as interoperability with Analysis Views, interactions with the BI platform and access to more data sources will further support our ability to leverage existing investments (BW, HANA, BO) and promote cross collaboration across the wider BI community.

 

  • The intuitive design will attract new users who may have required BEx in the past but were intimidated by the non friendly UI, ultimately driving broader adoption.

 

  • Analysis is inline with SAP’s strategic focus and will be the target for future innovations. The tool appears to be sufficiently mature (1.4 SP6) to start being used today as the replacement for BEx Analyzer.

Hi All,

 

I just received an interesting question about Analysis for Office settings tab and I will share with you the tip to make it appears.

 

Situation: You upgraded the Analysis for Office from version 1.2.x or 1.3.x to Analysis version 1.4.x and on the settings screen you remains with 2 tabs (User Settings | Support Settings) as the screenshot below:

setting 0.png

 

As we know on the after version 1.4.x Analysis comes with more 2 settings tab (User Settings |  Advanced Settings | Plataform Settings | Support Settings) as below:

 

setting 1.png

 

On this particular case you will need to uninstall the entire Analysis for Office 1.2x or 1.3x and install the Analysis version 1.4.x that will contain the entire package of new features that will enclose the 2 new tabs.

 

Thanks,

Diego Ferrary

Support Team, NW Technology, AGS Primary Support

SAP Labs Latin America

 

Also check Analysis for Office’s blog: http://scn.sap.com/people/filipe.zeuch/blog

For more Analysis for Office tool please check:

Hi All,

 

There is some situations where you have to manually activate the Analysis for Office Add-In.

 

Situation #1:

 

You cannot find the Analysis Add-In tab in your MS Excel or MS Powerpoint.

 

Situation #2:

 

You try to launch Analysis for Office and you are getting some errors like the messages below:

  • "Unable to launch Analysis Add-in"
  • "The launcher was not able to connect Analysis Add-In. Make sure that Analysis Add-In is not disabled by Office Application"

 

In these cases, Analysis Add-In may have been disabled by the Microsoft application after some crash. So you have to re-enable the Analysis Add-In in MS Excel or MS PowerPoint. This is very simple to solve and this post will show you how to do it.

 

 

1 – Open Excel Options.

 

picture 1.png

 

2 – Click on “Add-Ins” tab and select “Disabled Items” in Manage box. Then click “Go”.

 

picture 2.png

 

3 – If the Analysis Office Add-In is listed here select it and click on Enable.

 

picture 3.png

 

4 – If Analysis Add-In is not listed, like in the screenshot above, go back to Step #2 and select “COM AddIn” in the Manage box. Then click “Go”.

 

picture 4.png

 

5 – Make sure to have the Analysis Add-In checked and click “Ok”

 

picture 5.png

 

You can also check the SAP note 1672606 and the AO Admin Guide (Chapter 9 - Troubleshooting).

 

Cheers,

 

Filipe Zeuch
SAP Active Global Support
**************************************
Also check Analysis for Office’s blog: http://scn.sap.com/people/diego.ferrary/blog

 

For more Analysis for Office tool please check:

http://help.sap.com/boao
http://scn.sap.com/community/businessobjects-analysis-ms-office
http://scn.sap.com/docs/DOC-7679
http://www.sap.com

Hi AO users,


We received some incidents related with installations where Analysis for Office got a message error when finishes the installation. We received also some incidents where Analysis for Office finishes the installation and do not appears at the excel tab.


Here I will describe some information about installation and troubleshooting.

 

== Requisites

When you are installing an Analysis for Office you have some requisites and to check those you will need to check the SAP note:


  • 1466118 Analysis Office hardware & software requirments


You also may need to check the PAM (Product Availability Matrix) for Analysis for Office so you will need to follow the below link:


You can also check the Admin Guide of Analysis for Office located on the Analysis for Office official page: http://help.sap.com/boaolap41.

 


== Installation

Analysis for Office is easy and friendly to install.

SAP always suggests to install the latest delivered version as it contains delivered new features.

I already described the path to find the latest support package but for those that needed I will describe below:


  1. http://service.sap.com/swdc
  2. Download
  3. Support Packages & Patches
  4. Browse Our Download Catalog
  5. Analytics Solutions
  6. SBOP ANALYSIS MS OFFICE
  7. SBOP ANALYSIS MS OFFICE 1.4
  8. Comprised Software Component Versions
  9. ANALYSIS OFFICE CLIENT 1.4

 

Win32 (for 32 bit Office) or Windows 64bit (for 64 bit Office)

 

You will execute the file and you will easily install with few next buttons.


At the first installation screen you will receive a message if you didn’t fulfill the requirements otherwise you will just click next.

install.png

 

At the second installation screen you will select the features to be installed.

install1.png

At the end of the installation, if your installation has some issue, you will receive a message error and an inconsistent report that you can check by the installation screen clicking on Error Report.

install3.png

 

== Installation Check

If you receive a message error you can check the installation log file by the installation check as described below:


  1. Press Start - Run
  2. Enter nwcheckworkstation
  3. Continue the appearing wizard
  4. Before clicking Finish make sure Checkbox "Collect diagnostic
  5. information for SAP Support" is checked
  6. Press Finish

 

On this file you have much information and to find the specific one you will check at the error folder. On the folder you will be able to see the below error:

install4.png

 

== Settings

After the installation you have a specific setting that I would like to highlight. At the Admin guide you can see the setting “LoadBehavior” that you can define as 1,2 and 3.


  1. (value 1)The Add-In is enabled. This temporary activation means that the Add-In is disabled again when Microsoft Excel is closed.
  2. (value 2)The Add-In is disabled. Users can enable it in the COM Add-In dialog box. This sets the value to 3.
  3. (value 3)The Add-In is enabled. If required, users can disable it in the COM Add-In dialog box. This sets the value to 2.

 

 

== Common issues

We had received some incidents related with installation and the solution is simple. Sometimes we received some screenshots of “control panel/ install remove programs” with more than one version of Excel / Power Point and office packages. The same situation with the .net installation.


The Analysis for Office will work only with the Office package and not stand alone so the situation got solved removing all related installation and reinstalling from the entire Office package.


You cannot have a mixed office version installation.

 

== Silent Installation

For silent install you can proceed with the steps described at the KBA below:


  • 1929396 - Silent Install Analysis Office

 

If you have some suggestion about a specific topic, please describe on the comments that I will write a post about it.

 

Thanks,

Diego Ferrary

Support Team, NW Technology, AGS Primary Support

SAP Labs Latin America

 

Also check Analysis for Office’s blog: http://scn.sap.com/people/filipe.zeuch/blog

For more Analysis for Office tool please check:

There are scenarios where there's a need to trigger a process chain from an Analysis for Office. For example, you might need to allow a user to click a button in your Analysis for Office workbook which triggers a disaggregation of gross margin in the background based on percentages that a user have just entered. To enable this functionality, simply follow these steps:

 

1. Create a InfoObject of type Characteristic. Name the characteristic ZPCCHAIN and configure it to be of type CHAR with length 25 (the maximum length of process chain technical IDs).

 

ZPCCHAIN.png

 

2. Create a real-time InfoCube named YCX_R01 that contains characteristic ZPCCHAIN and a key figure of your choice. The key figure is not really used to store any real values. We simply need it to be there in order to be able to build a MultiProvider on top of our cube (a MultiProvider needs at least one key figure). For this how-to blog, I've chosen to use 0AMOUNT. I've set the description of 0AMOUNT in my InfoCube to be "Dummy/unused Key Figure" to imply that it does not serve any function but to enable as to build a MultiProvider on top of it.

 

InfoCube YCX_R01.png

 

 

3. Create a MultiProvider named YCX_M01 on top of your InfoCube and map InfoObject ZPCCHAIN and your chosem key figure. Note that the MultiProvider is not mandatory (i.e. you can build an aggregation level directly on top of InfoCube YCX_C01) but I recommend creating one to follow best practice.

 

YCX_M01.png

 

 

4. Create an aggregation level named YCX_A01 on top of MultiProvider YCX_M01 (or directly on top of InfoCube YCX_C01 if you've chosen to skip step #3). Ensure that you use InfoObject ZPCCHAIN and your chosen key figure to be part of your aggregation level.

 

YCX_A01.png

 

5. Enable function model RSPC_API_CHAIN_START to be called in a FOX formula by creating an entry in table RSPLF_DIR.

 

Table RSPLF_FDIR.png

 

6.  Create a BeX query variable named ZCUP_PCCHAIN_001 with the following configuration:

 

Variable 1.png

Variable 2.png

 

7.  Create a BeX query filter named YCX_A01_FI001 with the following configuration:

 

YCX_A01_FI001.png

 

8. Create a planning function named YCX_A01_PF01 of type FOX formula with following characteristics configuration and FOX code:

 

YCX_A01_PF001 1.png

YCX_A01_PF001 Formula.png

 

9.  Create a planning sequence named YCX_A01_PS001 that makes use of planning function YCX_A01_PF001 and filter YCX_A01_FI001.

 

YCX_A01_PS001.png

 

10. In InfoCube YCX_C01, add an entry for the process chain that needs to be triggered. You do can this using transaction RSINPUT or through a data load. Ensure that your dummy key figure is non-zero.

 

RSINPUT YCX_R01.png

 

11. In an Analysis for Excel workbook that already contains an input ready query, insert planning sequence YCX_A01_PS001 in the components tab. In this example, we will leave the alias to PS_1.

 

12. In your workbook, specify parameters for planning sequence YCX_A01_PS001. You need to either hardcode a value for variable ZCUP_PCCHAIN_001 or specify the value using a cell reference. Ensure that the value your specify as the parameter is contained in InfoCube YCX_R01 (see step 10)

 

13. Execute the planning sequence when a button is pressed by linking the button into a VBA subroutine with the following code. Note that if you change the name of your planning sequence to other than PS_1, you should use that name instead.

 

Dim lResult As Long

lResult= Application.Run("SAPExecutePlanningSequence","PS_1")

 

That't all to it! When you click the button, your planning sequence should now execute and the relevant process chain should be triggered.

Yesterday ASUG had a webcast where SAP's Alex Peter and ASUG volunteer Joyce Butler reported the results of the ASUG Analysis Influence Council.

 

Alex said the ASUG Analysis Influence Council was very helpful.  Please note that anything for the future is subject to change and the usual legal disclaimer applies.

 

The current council has 12 companies covering different companies and industries.

1fig.PNG

Figure 1: Source: ASUG Analysis Influence Council

 

Figure 1 shows the purpose of ASUG Influence Councils.

 

This webcast covered where ASUG members influenced SAP:and future roadmap.

 

BW Workspace

BW Workspaces, which is the technical name for mashing up local data with BW data.  You can add your own classification of items that are not already in the BW model.

 

BEx Workbooks

Another area where the ASUG Influence Council influenced SAP was conversion of BEx Workbooks.   At first SAP only focused on BEx 7.0 workbook conversion but the influence council clearly indicated that BEx 3.5 workbooks are needed.  Adding additional pressure was BEx 3.5 recently went out of maintenance; hence the need of offering a BEx 3.5 workbook conversion to Analysis Office

 

Variants

Variants was a gap with BEx Analyzer and the council asked for variants to be done as soon as possible.

2fig.PNG

Figure 2: Source: SAP

 

Figure 2 shows a new prompt dialog for Analysis OLAP, you can save the prompt values and create public and private variants.  You can also merge and unmerge variables.

3fig.PNG

Figure 3: Source: SAP

 

Figure 3 feature is only available for MSAS allowing for custom groupings, resulting from a discussion from this ASUG Influence Council.

 

This is not for BW yet.

4fig.PNG

Figure 4: Source: SAP

 

Create Analysis application from Analysis OLAP client you can take over the current datasources and directly post in Design Studio application.

Then you can change with Design Studio and change the interactivity features to filter items.

 

BEx Query Designer

If you are on a datasource and access Query Designer and redeploy to workbook was highly prioritized by the Influence Council

5fig.PNG

Figure 5: Source: SAP

 

Figure 5 shows that scheduling Analysis Office is available on the BI Platform.  SAP decided to do it on the BI Platform as it offers more than the BEx Broadcaster

 

There are a few things to catch up such as query prompt support; if a query has a prompt that is not supported. You can filter by exit or authorization variables.

Figure 5 covers the requirements.

6fig.PNG

Figure 6: Source: SAP

 

Figure 6 shows the left column today

 

The next release will be called “2.0” and will be a big effort

 

Beta will be Q2 and RTC will be end of year.

 

The big effort is rebuilding the platform of add-in because SAP plans to let SAP run add-ins side by side such as EPM.  Today the add-ins do not work side-by side

 

SAP wants to have them run side by side and clear vision for one single BI related add-in at SAP.

 

Analysis Office/EPM are planned to be brought together and SAP wants a smooth transition.

 

Configuration of workbooks is when you have several plug-ins available you would like to have a custom ribbons/context menu and combine in one single ribbon

 

Table formatting means you can only handle table as big block; can’t add empty lines or rows in a specific format.   The idea is to add some specific style elements in the table that continues to exist after refresh or navigation.  This also includes Excel-based formulas and expect it to “survive” any navigation. Analysis Office has to translate it into semantics to get this to work.

 

Complex scenarios include conditional formatting.  Hichert has some rules (planned values in light grey and actual in black and use color for positive trends) for cross tabs and charts and this could be used.

 

First release will start with simple inserting formatting of rows.

 

For BW, SAP is extending the unified BPC planning which is the evolution of BW-IP

 

On the BW side they are introducing the multi-select if you would like to change some specific settings, you can do that only one by one today.

 

In 2.0 (planned innovations) they will introduce storing workbooks in HANA.

 

Future directions include comments stored and work on PowerPoint .and scheduling.

 

Lumira integration:  the idea is to have visualizations from Lumira in Excel or PowerPoint and integrate vice-versa.  Native HANA means Analysis Office talks directly to HANA platform instead of today’s ODBC connection.

7fig.PNG

Figure 7: Source: SAP

 

In the future includes improved currency conversion support.

 

Planned innovations includes source related.

 

It has good interoperability with Design Studio and Analysis OLAP will stay as a good Analysis adhoc OLAP client.

 

 

Related:

Analysis Office will have sessions at BI 2014

Jump Start ASUG Annual Conference SAPPHIRE with a Pre-Conference Session - Back and Better than Ever includes hands-on Analysis Office with BW on HANA

It doesn't make sense, I suppose, to move a single attribute from Rows to Columns (leaving the rest of the dimension, and it's attributes, on Rows), but Analysis let's you attempt the operation, spends some time churning, and then reports a large number of invalid combinations, and an exception requiring a Restart of the workbook.

I suppose the same exception would occur if you tried to move an attribute from Columns to Rows.

 

Analysis should either prevent the movement of atttributes, or handle the errors if you try. Anything that causes an exception or requires a Restart should be trapped.

On an ASUG webcast today SAP reviewed scenarios covered by BEx, and now covered by other products.

 

BEx development has been ramped down.

 

If look at BEx scenarios, recommend invest in two product areas to replace BEx: one is Analysis Office and OLAP and Design Studio.

 

Please note that future items are subject to change and any forward looking statements are subject to the disclaimer (no commitment).

 

1afig

Figure 1: Source: SAP

 

BEx came with the idea of IT providing workbooks and analytics, and not so much self-service or agile visualization.

 

Suggested customer recommendations for SAP BW customers is to lead with Analysis.  For others, look at Lumira and BusinessObjects Explorer

1bfig

Figure 2: Source: SAP

 

As Figure 2 shows, Web Intelligence has some limitations for BW as it was built for relational data sources and not BW. It does not rely on underlying OLAP engine but the Web Intelligence microcube.  Do not expect more improvements for Web Intelligence on BW.

 

Customer recommendations:

  • SAP BW customers: Depends on use case, but Analysis Office is optimized for BW.
  • BusinessObjects customers or those with any data source: Use Web Intelligence
  • Reporting / OEM - use Crystal Reports

1cfig

Figure 3: Source: SAP

 

Analysis OLAP and Design Studio – looking for functionality from A-OLAP into Design Studio

 

1fig

Figure 4: Source: SAP

 

BEx analyzer and the suite of SAP BEx tools are in maintenance mode

 

They will still be delivered with the next releases of SAP NetWeaver BW

 

They follow the same life cycle and release strategy as BW - for example, BEx analyzer is shipped with BW 7.3 will be supported for the next 7+2 years

 

BEx queries are consumed directly by BI4 front-ends

 

BEx Query Designer remains in place to create and maintain BEx queries (common question)

 

Analysis, edition for MS Office is the alternative to BEx analyzer with enhanced premium functionality

 

For customer-specific maintenance of Bex 3.5: See Note 1767068

 

4fig

Figure 5: Source: SAP

 

Figure 5 shows what is supported today including full support of BEx queries.  Also see what is planned in the future (subject to change)

 

6fig

Figure 6: Source: SAP

 

SAP wants Analysis Office to be more usable and be close to Excel and they wanted to focus on business user (see Figure 6).

7fig

Figure 7: Source: SAP

 

Figure 7 shows the Design Panel usability – like pivot tables

8fig

Figure 8: Source: SAP

 

Only local comments now; planning more global in the future

10fig

Figure 9: Source: SAP

 

Scheduling (which requires the BI platform) was recently released.

 

 

Subset of Question & Answer

We had 57 questions in total, and I will try to include most of them in the upcoming blogs.

Q:  Will Analysis have scheduling ability in the future

A:  We have added it to Analysis Office recently - and it is planned for Design Studio in a future release.

A:  Analysis Office has scheduling capability now with a service pack that was released a few weeks ago - 1.4

________________________________________________________________

Q:  when does SAP support end on BW querries(Bex) 3.5 & 7.0 ?

A:  See http://scn.sap.com/community/business-explorer for BEx maintenance - note that BEx 3.5 is no longer shipped with the SAP Gui any more 

A:  Eric will talk briefly about it. Bex 3.5 extended support has ended in Q2 2013, BE 7 will definitely be supported as long as BW 7.x, i.e. at least until 2020

________________________________________________________________

 

Q:  We still need to use BEx queries to act as a semantic  layer with Web Intelligence and Crystal Reports, correct?

A:  Yes, the BEx query is the semantic layer for Web Intelligence and Crystal.

________________________________________________________________

Q:  Does that include support for 3rd party OLAP?

A:  Analysis OLAP supports 3rd party OLAP sources such as SSAS, ORACLE OLAP, Essbase, Teradata ..

________________________________________________________________

Q:  What SAP product will have the ability to let users enter data into a BW cube similar to capability that currently exists with BEx Planning?

A:  Analysis Office already supports BW-IP/PAK as of today, Design Studio plans to support it with the next release in Q2 2014

 

Q:  For the new recommended options, is Business Objects or HANA required?  What version of BW is recommended for these?

A:  BW or HANA can be used as data sources - please check the PAM for versions - service.sap.com/PAM

A:  Analysis Office and Design Studio can be deployed on BusinessObjects BI platform - but can also be deployed without it

________________________________________________________________

 

 

Q:  Can you tell us what SAP Gui release the 3.5 tools are no longer shipped? 7.3?

A:  BEx 3.5 query / analyzer is not shipped with SAP Gui 730

________________________________________________________________

 

 

Q:  What is the future of BEx Query Designer?

A:  Will stay the main tool for defining semantic models on BW

________________________________________________________________

 

 

Q:  If we want to switch Bex to any BO Tools, Is there aternative solutions on using Bookmarks, RRI(report to report Interfact) and BAPI's in new BO tools ?

A:  Analysis Office/OLAP support RRI (sender only)

________________________________________________________________

Q:  Does input ready queries work with Analysis for office?

A:  yes

________________________________________________________________

 

 

Q:  Can you provide a link from where to download the Analysis client that comes with Scheduding features?

A:  Go to service.sap.com/swdc and under "A" Analysis Office - BI platform add-on

________________________________________________________________

 

 

Q:  SAP PBF uses BEx queries for input in forms. Can we continue using BEx for new forms that we build or should we choose between analysis office and design studio?

A:  not sure if I got the question, but Analysis Office already supports planning (i.e. input-ready queries) and Design Studio plans to do it in Q2 2014

________________________________________________________________

 

 

Q:  What is the expected release for use of current BEX reports with 64-bit Excel?

A:  Analysis Office already works in a 64-bit environment

________________________________________________________________

 

 

Q:  Does the 7+2 years start in 2013? What does the +2 mean?

A:  7 years standard maintenance and 2 years extended maintenance

________________________________________________________________

Q:  What is the semantic layer strategy for BW? As of today we rely on BEX as reporting interface for BOBJ tools.

A:  query designer stays strategic modeling environment on BW

________________________________________________________________

 

Q:  Is that 7 years beginning in 2013, so until 2020 for maintenance?

A:  Please check SAP's maintenance side. Statement is that NetWeaver 7.x is supported until 2020 at least.

________________________________________________________________

Q:  Can we use the Analysis Office on top of BW with stand alone ( wit out Bw) and how? we are BW 7.0

A:  You can use Analysis Office with BW without the BI Platform (does that answer your question)? It will work with BW 7.0

________________________________________________________________

 

 

Q:  Is Analysis Office available to all current BEx users at no additional cost?

A:  There is a separate license connected to Analysis and Design Studio

________________________________________________________________

 

 

Q:  with out BO

A:  Yes, Analysis Office works without BI platform (but then no scheduling)

________________________________________________________________

Q:  Plans to add missing BEx Analyzer functionality to Analysis for Office (Excel)?

Specifically:

- Re-ordering of Structure elements (rows/columns) at the workbook level

- Tools – Copy Sheet

- Drill Across Sheets

- Display Scaling Factors correctly

A:  lots of plans ... please use Idea Place for voting for missing or new feature requests

________________________________________________________________

 

 

Q:  Which BO tools support RRI(report to report interface) both Sender and receiver ?

A:  Design Studio does not support yet. It's planned for next releases. AOLAP and AOffice support RSBBS. For other tools in BI Clients please refer to Ingo Hilgefort's blog and book. He has a very detailed information in his blog.

________________________________________________________________

 

 

Q:  I see that there is a separate license connected to Analysis and Design Studio. Is this part of the BusonessObjects licencing agreement or are they stand-alone licences (similar to Lumira)?

A:  This one you may want to ask SAP Account exec; SAP offers a suite license and a-la-carte

________________________________________________________________

 

 

Q:  Analysis Office is part of BO lincence or standalone product like lumira? to use on top of BW 7.0?

A:  See previous answer to contact your SAP Account Executive - SAP has difference license offerings and some are a la carte

________________________________________________________________

Hello All,

 

AO Precalculation and scheduling features are now bundled as feature pack with BIP add-on.

 

What does it contain?

1. Precalculation enablement via BIP.

2. Scheduling (Broadcasting) via BIP.

 

Note that BW precalculation and broadcasting is still not possible.

This may be something planned for future?

 

Here is the SMP link to add-on installer -:https://smpdl.sap-ag.de/~swdc/012002523100020426492013D/BIPADDON04_0-10013163.ZIP?_ACTION=DL_DIRECT

 

Regards,

Bharath

 

Here is the documentation relevant to precalculation and Scheduling - http://help.sap.com/businessobject/product_guides/AMS14/en/14SP5_aaoffice_user_en.pdf   Section 10 - Scheduling

In Excel 2007 it's possible to add controls, referenced by a qualified ID (idQ attribute), to the Quick Access Toolbar, and in Excel 2010, to add controls to the Quick Acces Toolbar, or the ribbon. Furthermore, it is possible to add and/or position custom controls on or next to the Analysis tab, or groups on the Analysis tab, by using attributes like insertBeforeQ and insertAfterQ. The approaches for configuring the Ribbon are beyond the scope of this article - See here and here for an overview.

 

This article provides a summary of the qualified control IDs (idQ attributes) for the Analysis tab, and the groups on the Analysis tab. They're qualified by namespace: "SBO", but you can use a namespace of your own choosing.

 

The Analysis Tab

idQ="SBO:com.sap.ip.bi.analysis.menu"

 

The Analysis Groups

Data Source:

idQ="SBO:com.sap.ip.bi.newpioneer.excel.dataconnections"

 

Undo:

idQ="SBO:com.sap.ip.bi.newpioneer.excel.backandforward"

 

Data Analysis:

idQ="SBO:com.sap.ip.bi.newpioneer.excel.dataanalysis"

 

Display:

idQ="SBO:com.sap.ip.bi.newpioneer.excel.display"

 

Insert Component:

idQ="SBO:com.sap.ip.bi.newpioneer.excel.insertGroup"

 

Tools:

idQ="SBO:com.sap.ip.bi.newpioneer.excel.tools"

 

Planning:

idQ="SBO:com.sap.ip.bi.newpioneer.excel.planning"

 

Design Panel:

idQ="SBO:com.sap.ip.bi.newpioneer.excel.Taskpanel"

 

Settings:

idQ="SBO:com.sap.ip.bi.newpioneer.excel.setting"

Part of the sharing the knowledge at SAP TechEd, we learned that the one a new feature coming soon to Analysis Office is scheduling.  Scheduling Analysis Office workbooks will come via the BI Platform, and will be available as an add-on to the BI Platform.  The planned release date is sometime in November.  SAP's Alexander Peter demonstrated this feature at the ASUG Analysis Influence Council this week. 

 

Analysis OLAP

Also reviewed as BI4.1 features already available in Analysis OLAP.  BI4.1 offers custom grouping features against certain data sources, except BW. 

 

Other features reviewed include Focused Analysis, allowing you to link a table to a chart.

 

Analysis OLAP offers "Pivot with" – filter with

 

It has Report to Report Interface as a  valid sender

 

Also new in BI4.1 is the ability to resize panels, waterfall charts with hierarchies

 

An interesting exercise is the abilit to go from Analysis OLAP to Design Studio with a single click.  You skip step of starting Design Studio

 

Some Question & Answer regarding Analysis OLAP

 

Q: Is planning supported?

A: No; Analysis Office supports planning but has no custom grouping, no focus panel

 

Q: Does A-OLAP have a scheduling capability?

A: Not yet; not sure if will develop; may do in Design Studio

 

Special thanks to Joyce Butler, Ian McAlpine, and Alexander Peter for running this session and sharing the news with us.  ASUG Influence Council sessions are not to be missed at events, as this is where you learn what is coming with the products.

Actions

Filter Blog

By author:
By date:
By tag: