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:

http://scn.sap.com/servlet/JiveServlet/showImage/38-107201-451242/1fig.png

Source: SAP

 

 

 

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

 

1regedit.png

Figure 1

 

You need to set the TableInterface to True

2table.png

Figure 2

 

Figure 2 shows the crosstab

 

3rowafter.png

 

Figure 3

 

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

4insertrowresult.png

Figure 4

 

Figure 4 shows the results of inserting a row "after"

5insertcolumn.png

Figure 5

 

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

6result.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.

We first heard of the beta for 2.0 for Analysis Office back in March at this ASUG webcast How ASUG Members Influenced Analysis Office (and Sneak Preview)

 

Beta is not for productive use and is a first look.  Things are subject to change by the time the product is GA.

 

I applied for the program, was approved and was able to download the software last week.  First thing I noticed was that Download Microsoft .NET Framework 4.5 from Official Microsoft Download Center was prerequisite; fortunately I was able to download it from the link in the installation.

 

You can have Analysis Office 2.0 and Analysis Office 1.4 on the same machine - the installation doesn't overwrite what is in already installed.

 

First there is a third panel in the display panel - Properties:

1aproperty.png

Figure 1 Analysis Office Beta 2.0

 

You can see in Figure 1 on the right the panels where you control compact display in rows, zero suppression, and display of negative values.  These features are available in today in Analysis Office 1.4 but not as easily accessible as they are in the 2.0 Display Panel.

 

Here is how Analysis Office 1.4 looks like today:

1bproperty.png

Figure 2 Analysis Office 1.4

 

Figure 2 shows the display panel on the right of the current GA version Analysis Office 1.4.

2newsettings.png

Figure 3  Analysis Office 2.0

 

Figure 3 shows the new Analysis Settings Ribbon, About Analysis and Help ribbons.  Again these settings are available in 1.4 but a little more easily accessible in 2.0

 

3settings.png

Figure 4 Analysis 2.0

 

Figure 3 Settings ribbon shows the Settings pop-up.

4insertingrows.png

Figure 5 Analysis Office 2.0

 

Figure 5 shows a new feature of the context menu, the ability to right-click row after and row before.

 

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.

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.

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.

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

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

________________________________________________________________

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.

Over two and half years ago the ASUG Analysis Influence Council kicked off with Alexander Peter, Ian McAlpine and Joyce Butler

 

What are ASUG Influence Councils? 

 

"Influence Councils are interactive forums where members can communicate ideas and concerns about product plans and SAP services directly to SAP development and product managers."

Source: ASUG

 

The council continues today and continues to provide feedback to SAP on the products.  This blog covers where ASUG influenced the latest BusinessObjects Analysis, edition for Office 1.4 release.

 

 

The council first ranked and prioritized features.  At the top of the list was "Capability to Create/Edit Bex Query within Analysis Office.  From Bex analyzer you don't have to leave the tool to add a field.  With Office you have to leave the tool, go to query designer, add the field and then get back into Office. "

 

 

This is now available in the current 1.4 release.  See the steps below:

 

Under Settings, select Advanced Settings, and select the checkbox Show "Call Query Designer"...

1fig.jpg

 

 

The Query Designer button/ribbon is then shown:

2fig.jpg

 

Select the Launch Query Designer and the Query Designer is then launched.

3fig.jpg

 

You can make changes to your query and then return to your Analysis Office application.  In my example above I've added WBS to the rows of the Query.

 

Then when returning to Analysis Office cross tab you reset the data source and the cross tab is then updated.

4fig.jpg

For questions or more information feel free to e-mail ASUG influence at influence@asug.com

 

Consider joining the team and meet face to face at SAP TechEd Las Vegas.

 

ASUG also has a pre-conference SAP TechEd session that includes Analysis Office in the BI4.1 on October 21st:

ALL DAY | HANDS-ON: SAP BusinessObjects BI 4.1 with SAP BW and SAP ERP – Everything You Need in One Day

 

 

 

Related Links:

See how ASUG Members Influence SAP – Featuring BusinessObjects Analysis Influence Council

ASUG Annual Conference - ASUG Influence and BEx Quo Vadis

Can ASUG Members influence SAP? ASUG Influence Council Success Story, SAP Best Practices for Business Warehouse with BusinessObjects

Interested in Influencing SAP?  Join ASUG for the SAP BusinessObjects Analysis Influence Council Kick-off Webcast

We're listening! Please give product feedback by Ina Felsheim

 

For more information about Influence Councils see Karin Tillotson's Why I believe in the power of ASUG Influence Councils Part 1 and Why I believe in the power of ASUG Influence Councils Part 2 - The ASUG UI Influence Council

 

For more information about ASUG see Ingo Hilgefort's Whats the value of a ASUG membership for you as customer ?

Part 1 covered installation and some features.  Part 2 discussed more features including Waterfall Charts, Read Access Mode, and Reset Data Source.

 

Launch BEx Query Designer

First I want to cover some troubleshooting.  Some comments in the discussion forum indicate that individuals are unable to launch the BEx query designer - it is greyed out.  Note you must be on a later SP for the BEx Query Designer.  Check your version by going to Help > About in the BEx Query Designer:

querydesigner.jpg

 

 

If you are not on this version then go to Service Marketplace and download the BI Add on:

querdesignersmp.jpg

 

 

Then you should be able to click this option in the User Settings.

 

Adjusting the Member Selector

You can limit the number of members in the "member selector" by going to User > Settings:

memberselector.jpg

You can change the Maximum Number of Entries in Recent List - the default is 1000.  This may help improve performance when working with large amounts of data.

 

Filter Hierarchy in Display Panel

 

In the display panel, you have the option to filter based on hierarchy only - if you select this, your hierarchy turns into a flat presentation.

rightclickusehierarchyforfilteronly.jpg

 

When it is clicked on, the hierarchy in the cross tab is turned into a "flat presentation"

2rightclick.jpg

 

 

 

 

But then you can filter by the hierarchy or the leaves of the hierarchy:

3filter.jpg

 

 

Hands On Experience

Next week at BI 2013 in Amsterdam, SAP Mentor Ingo Hilgefort will be providing hands-on sessions for the Analysis Suite, including Analysis Office.  I attended this myself at BI2013 in Las Vegas in March and these sessions were quite popular with great feedback.  I recommend attending these sessions if you are attending.

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:

1waterfall.jpg

 

The first type of Waterfall Chart shows up as follows:

2waterfall.jpg

 

Here is an example of a pivoted Waterfall Chart:

3waterfall.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

4resetdatasource.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:

5resetdatasource.jpg

 

Read Access Mode

 

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

6readaccess.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:

7readaccess.jpg

 

 

More to come.

Last month SAP covered what is new with Analysis Office here.  Today is it generally available, according to the PAM.   This morning I was able to install it on my machine.

 

The install file is only 79.2 MB and installation is fairly easy.

1install.jpg

 

When you get to this screen you need to click the Enable 1.4 Features checkbox.

 

2installsuccess.jpg

 

Once you install you see the success.

 

Go to the Settings Tab to enable some new features:

3figenable.jpg

 

I can enable the launch query designer button and Create Web Application (launch Design Studio)

 

Note to BEx launch query designer you need to install the latest SAP Gui patch for 730; otherwise it is greyed out.

 

4querydesigner.jpg

 

After clicking "Launch Query Designer" you can then launch the BEx Query Designer:

5bexquerydesigner.jpg

 

More to come in future  - read access mode, reset data source, etc.  Watch the BusinessObjects Analysis Office space.

We had an ASUG Analysis Influence Council at ASUG Annual Conference where attendees learned how the ASUG Analysis Influence Council influenced SAP:

 

Features influenced by the ASUG Analysis Influence Council

Analysis Office

1) Converting BEx 3.5 workbooks

2) Variants

3) Launch BEx Query Designer (coming in 1.4 release)

 

1alex.jpg

Picture of SAP's Alexander Peter by Joyce Butler

 

Analysis OLAP - features where ASUG Analysis Influence Council provided input

1) new prompt dialog

2) custom grouping

3) mobility for Analysis OLAP

 

 

We also learned that the broadcasting feature will come to Analysis Office through a BI4.1 feature pack later this year.  The planned release for Analysis Office 1.4 is early June.

 

Ian McAlpine said that the ASUG Analysis Influence Council "feedback is highly prized and valued to SAP."

 

BEx Quo Vadis Community Lounge

Right after this session there was an ASUG Community Lounge session titled "BEx Quo Vadis" or "BEx where are you going".  We had a similar community lounge at last year's conference but no one showed up.  I was quite skeptical about doing it again, but Lee Lewis insisted and fortunately Joyce Butler and SAP's Eric Schemer agreed to do it.

 

 

We had a great turnout this year, and special thanks goes to Lee, Joyce and Amy Finke of ASUG Headquarters.  Amy redesigned the lounge areas, which were called "theatres", which was a huge improvement.

2pic.jpg

Photo by Danny Pancratz

 

Oftentimes people hear that "BEx is going away" - this is not the case for the BEx Query Designer.

 

An attendee asked "what are the gaps between Analysis Office and BEx Workbooks?"  Alex said he felt document integration and broadcasting were still two missing features.

 

SAP also said that "BEx query designer remains core modeling tool for BW".  "We are not replacing BEx Query Designer" says SAP in BEx Quo Vadis session. 

 

Here is a link to a vine video where Alex discusses Analysis Office.  Also Jie Deng answered questions about placing Design Studio applications on the Enterprise Portal (minimum version required is 7.3) - here is the link to the vine video.

 

Thanks to all who attended and thanks to SAP's Alex Peter, Jie Deng and Ian McAlpine for their support of ASUG.

Alexander Peter, Product Owner for Analysis Office, provided this webcast to ASUG yesterday.

 

Since the discussion covers future versions, this is subject to change.

1abex.jpg

 

 

Figure 1: Source: SAP

 

Figure 1 shows that BEx tools are in maintenance mode.  There is not an immediate need to go off BEx clients but no new innovation.

Innovation comes with the Analysis clients.

 

Content with BEx Analyzer – conversion support exists today in Analysis Office.

 

1whatsnewaoffice14.jpg

Figure 2: Source: SAP

 

Analysis 1.4 release is smaller than 1.3 as SAP focused on improving performance.  SAP launched a performance project to review performance challenges from end to end. 

 

Alex said there are two collective notes to help you identify things on backend to streamline communication between server and client.

 

Main feature was broadcasting on BI Platform, another gap for BEx Analyzer– for legal reasons can’t release GA .  SAP chose the BI platform to use the scheduling features.  Broadcasting is planned for Q3.

 

GA for 1.4 is planned for May.

 

SAP has enchanced interoperability with Design Studio – in 1.3 you could copy a data source and insert it in Design Studio.  Now it is extended to be an automatic transformation to Design Studio – crosstab, chart, and components into an iPad application.  The scenario is to have a prototyping tool in Analysis Office and can use it to prototype a dashboard.

 

Strengthen BI platform support – if you store it in Launchpad ad start it from the Launchpad – before only Excel opens.  It didn’t know about Analysis Office workbook.  SSO wasn’t honored.  Now solved in with Analysis Office 1.4 and BI4.1 platform

 

Waterfall charts not available in native Excel so they have added them to the toolbar in Analysis Office 1.4.

 

With the ASUG Influence Council, SAP prioritized features.  After broadcasting query designer was a the top. 

 

You can open the Query Designer from Analysis Office 1.4 .  You can reset data source to query designer

 

With the read mode feature you can change from reading from the cube or the master data.

 

Time-dependent hierarchy at the given key date is now available in 1.4.

 

Data refresh – before 1.4, when press refresh, render cross tabs but not show the latest data – re-rendered data – had to leave Excel and open it again.  With 1.4 have a real data refresh.

 

They have added a member selector for mass data

 

 

2aofficeroadmap.jpg

Figure 3: Source: SAP

 

Figure 3 was not covered during the webcast, but it gives you an overall direction.  Today is version 1.3, planned innovation is Analysis Office 1.4.

 

 

Subset of Q&A:

________________________________________________________________

Q: Will AA 1.4 allow us to create or design Queries in BW?

A: The Query Designer remains the tool to create queries in BW.‑

________________________________________________________________

Q: Will AA 1.4 finally have LogOn / LogOff button?

A: No plan for a logoff button... but I am aware that AA can hold onto connections for an extended period so this issue is being investigated.‑

________________________________________________________________

Q: is it possible to connect to Essbase cubes directly?

A: Not from Analysis Office‑

A: ... but Yes with Analysis OLAP‑

Q: is AA 1.4 compatible with BOBJ 4 SP5?

A: It is platform independent‑

________________________________________________________________

 

Q: What is the comparability of AA 1.4? We are on BI 7.0 and BOBJ XI3.1 sp 3.

A: It is platform independent - there are some features dependent on BW version but overall it is platform independent.‑

________________________________

 

 

ASUG Annual Conference

Alex is presenting at ASUG Annual Conference regarding the ASUG Influence Council.  Below is a list of other ASUG Analysis-related sessions for the conference:

 

Session IDTitle
301Deep-dive into Analysis for OLAP, the next generation tool for web-based multidimensional analysis.
305What’s new with Analysis Office & OLAP?
308Customize the Look and Feel of BW Reports in SAP BusinessObjects Analysis (Office) by Using API Calls
4210Influence SAP - ASUG SAP BusinessObjects Analysis Office/OLAP Influence Council
      CL32BEx Quo Vadis - "Where is BEx Going"
312Moving Beyond BEx: Strategies for Unlocking the Value in Your BW Data with BI 4

The ASUG BI Analysis Special Interest Group launched an ASUG Influence Council for the BusinessObjects Analysis Suite two years ago, initially focusing on BusinessObjects Analysis, Edition for Office, as BusinessObjects Analysis, Edition for OLAP shipped with BI4 platform.

 

SAP’s Alexander Peter has served as our SAP Point of Contact to this council and ASUG Volunteer Joyce Butler leads the council. 

 

The Influence Council was promoted during an ASUG kick-off webcast two years ago. Interest was high as Analysis Office is the “premium successor” to BEx Analyzer.


 

How did ASUG council members influence SAP?  See below on features that are generally available that ASUG influence council members influenced:


 

BEx Workbook Conversions:

 

Analysis menu in File ribbon > Convert BEx workbook

1convert.png


Not just BEx 7.x workbooks but also ASUG members influenced the decision to look at converting BEx 3.5 workbooks.

 


 

 

BW Workspaces:

 

ASUG Influence Council members influenced BW workspaces as well.  What are workspaces?  SAP describes them asBW Workspace is a dedicated area in SAP BW for a specific department to upload local data and combine it with central data"

2workspaces.png

Source: SAP

 

For more details watch Alex’s TechEd online session at http://www.sapvirtualevents.com/teched/sessiondetails.aspx?sId=3420

 

Prompting/Variants

 

Council members gave feedback into features such as prompting and variants, which became part of the 1.3 latest release:

3promptsvariants.png

Council members also influenced prompting features such cutting and pasting from the clipboard into the prompts.

 

 

Additional improvements include better PowerPoint integration for Analysis Office with SAP teams visiting council member customer sites.

 

Questions about ASUG Influence?  Email influence@asug.com


Actions

Filter Blog

By author: By date:
By tag: