Hi All,

 

 

As many of you did not succeeded with Scheduling the workbook with prompt, Here I have created sample video(no audio), might helpful

 

AO Version : 1.4.10.3295

AO BIP ADD on : 1.4.10.3290

BIP Platform : 4.1 SP5

Sample scheduling of Analysis Office Document with Prompts - YouTube

 

 

I would recommend to see the blog for detailed level information

http://scn.sap.com/docs/DOC-60492

 

Best Regards,

Subhash

Hi All,

 

AO 1.4 SP10 Patch1 is available in SMP

client.PNG

 

Notes info :

http://service.sap.com/sap/support/notes/2117548

 

BIP Add-on

 

bip.PNG

 

issue while scheduling of workbook with Prompt(variable) is solved - should be working now

 

thread :http://scn.sap.com/docs/DOC-60492#comment-560174

 

Regards,
Subhash

Hi,

 

I just found Analysis Office 1.4 SP 10 in http://service.sap.com/swdc

The corresponding note is also released: http://service.sap.com/sap/support/notes/2059338

 

With SP10 is should be possible to use "Create WebApplication" again if Design Studio is installed in 64bit version.

 

Update... you will need SP11 to have Create Web Application again for combination of Design Studio 64bit

 

Dirk

Analysis Office 2.0 is now in ramp-up; the current GA version is 1.4

 

Here is the PAM and below are some key points:

1fig.PNG

Figure 1: Source: SAP

 

Figure 1 shows the preceding release is still supported for a year after the product goes GA

2fig.PNG

Figure 2: Source: SAP

 

Installer should point out what is missing and the link in the installer will point to it

 

Please note: No support of Office of versions lower than 2010

3fig.PNG

Figure 3:

 

BW is supported as before

 

SAP HANA SP9 or higher

 

New Features

4fig.jpg

Figure 4

 

Table design is an important new feature; it is also known as “Dynamic grid”

 

When you insert a cross tab, if you insert a row or color style, it would have been lost with navigation/refresh

 

Now it keeps OLAP navigation and color/structure cross tab so it is extended to layout

 

This is first step; note that inserting text and formula in empty cells after refresh is not this first release.

 

This is more for formatting and inserting lines.

 

5fig.jpg

Figure 5: Source: SAP

 

Property View is the third column in the Display panel.  It is an “Expert mode”

 

It allows users who are familiar with Analysis Office to assign several properties in one step

 

It is not introducing new properties but introduce properties in a visualization

 

It is similar to Query Designer

 

More to come – and I hope we learn more at BI 2015 next year

This was an update from BI on Excel Roadmap - ASUG BusinessObjects Conference Update but contains more details.

 

Please note the usual legal disclaimer applies that things in the future are subject to change.

1fig.png

Figure 1: Source: SAP

 

Three SAP products + a partnership with Microsoft

 

Analysis Office is one the best integrated tools in to BW and HANA

 

EPM add in is for the BPC based

 

Live Office for the old Universes (UNV)

 

SAP has partnership with PowerBI for UNX

2fig.png

Figure 2: Source: SAP

 

The plan is for a single unified Office client crossing HANA, BPC, BW

 

Plan to extend Live Office to new universes (UNX) next year (Q2)

3fig.png

Figure 3: Source: SAP

 

EPM comes from Finance business user

 

Figure 3 shows the background for EPM

 

Shared access, apply dynamic formatting

 

It is integrated in Excel, PPT & Word

 

It has an offline mode

4fig.png

Figure 4: Source: SAP

 

Analysis Office comes from pivot table approach

 

Easy drag and drop onto the crosstab

 

Ad hoc for BI professional

 

It also has PowerPoint (no Word)

 

It supports BW IP and new embedded model

 

It has a rich API to build powerful Excel Workbooks; can use that to guide functionality

 

This is today’s positioning

5fig.png

Figure 5: Source: SAP

 

Investments are protected

 

If not on BW 740, recommend Analysis Office

 

If come from BPC classic, continue EPM add-on

 

At the end will have a unified Excel client

6fig.png

Figure 6: Source: SAP

 

Figure 6 shows the strengths of Analysis Office, including its ad-hoc features

 

SAP said it handles Big Data

 

It offers multi-platform support

7fig.png

Figure 7: Source: SAP

 

Figure 7 shows BEx Support for 10.1

 

Important to know what does not work yet (the limitations)

 

Roadmap

10fig.png

Figure 8: Source: SAP

 

Regarding Figure 8, the plan is to use without migration effort

 

Step-wise convergence through a common layer in Excel that synchronizes and governs Excel events

11fig.png

Figure 9: Source: SAP

 

Figure 9 pictorially shows the unified client.

12fig.png

Figure 10: Source: SAP

 

Figure 10 is the convergence for the Roadmap

 

Plans include a single installer, documentation

 

It contains UX harmonization – open and save dialogs

13fig.png

Figure 11: Source: SAP

 

Figure 11 has been discussed before

 

Question & Answer

Q:  Scheduling?  Scheduling without prompts support...  Not very productive.  When will prompts be available in scheduling?

A: It is being planned (planned innovations)

________________________________________________________________

Q:  with the unification of EPM and AO, which broadcasting utility will it use -- EPM's or Business Objects?  I would prefer not Business Objects.

Q:  I would prefer the scheduling like BEx.  I don't want to have to have this in the Business Objects framework.

A:  BI platform supports, will extend to HANA.  Priority is the BI Platform for scheduling.  Looking at extending to Netweaver but not a concret time to deliver.  More customers requiring can move the priority 

________________________________________________________________

 

Q:  Will the future unified excel client support BPC 10.0 or you will need to be on version 10.1?

A:  yes it will support 10 

________________________________________________________________

Q:  sorry, maybe I missed, but he started by mentioning three current Excel interfaces, EPM/BPC, Analysis for Excel (OLAP), and Live Office -- but this last seems to have been dropped from discussion now, what is future plan for LO (or is that still coming)?

A:  He said Live Office would support new universe in Q2 2015 (planned) - it is being worked 

________________________________________________________________

 

Q:  so Live Office will continue separate as is, ie. not part of convergence currently being discussed? thanks

A:  Mid term yes

________________________________________________________________

 

Q:  Scheduling with prompts looks like it is coming!  Great!  Any work being done on publications with A4O?

A:  on the backlog with low priority for now.   

________________________________________________________________

Q:  Can current versions of EPM and AO addins work without any conflicts now?  If not, when will this happen?

A:  side by side next year 

________________________________________________________________

 

Q:  A-Office view events are not created in Audit database now. Is there any plan to have those events as part of Audit DB with the unified client ?

A:  specific to BW, HANA - look at BW for stats 

________________________________________________________________

 

Q:  Will we need to install Excel on the BI4.1 server to schedule Analysis workbooks?

A:  You need to install the Analysis add-on to BIP - available at support.sap.com/swdc  

________________________________________________________________

Q:  Are there any possible Fiori integration in the horizon?  

A:  nothing planned for designed principles.  AO designs for what is typical for use.  To be reviewed in the future 

________________________________________________________________

 

Q:  It will be good to analyse in one Excel document data  that stored in the cubes (BW/HANA) and relational database (Universe), any plans to ad Universe support for unified Excel client ?

A:  Should happen in the future - complete framework that supports Live Office - no concrete plan  

________________________________________________________________

Q:  It sounds like SAP is integrating BPC/outlook features to IP. ?

A:  yes 

________________________________________________________________

 

Q:  with BPC there are folders where EPM files can be stored in,  will this be available to AO as well?

A:  Still have to find out 

________________________________________________________________

Q:  how about SAP Portal km for storage.  :)

A:  Not sure - could use BI Platform, BW, HANA - first time KM repository for BI - open to discuss but have enough with 3 repositories 

Join us on Tuesday October 21st for the ASUG Analysis Influence Council session EA117. 

EA117.png

 

David Stocker.jpg

 

 

David Stocker is the Technical Product Manager for Analysis Office and Design Studio. He has a development background and was an Analysis Office developer for several years before moving into his product management role.

 

David Stocker will be providing an Analysis Overview along with an update on Analysis Office 2.0 and Analysis OLAP 4.1. 

We will also have time to answer your questions and to take your input and recommendations on SAP Analysis improvements and direction. 

 

Come join in on the discussion to drive product strategy via our forward looking discussions. 

 

learn && be heard


For more information, visit SAP TechEd 2014 Las Vegas

The usual Legal Disclaimer applies that things in the future are subject to change.  SAP presented this at yesterday’s ASUG BusinessObjects Conference.  My notes are not complete as the hotel experienced AV issues so we didn’t see any slides 25 minutes into the presentation.

2biexceltoday.png

Figure 1: Source: SAP

 

Figure 1 shows the options today with Excel and SAP data sources.

3shortterm.png

Figure 2: Source: SAP

 

SAP said it took time to work on table formatting

 

For Analysis Office, they wanted to reach the point to close the BEx gap list

 

With third party access to your data source, it is never completely right

 

SAP has decided to update Live Office

 

SAP cannot give a timeframe on Analysis Office connection to universes

4liveofficeunder.png

Figure 3: Source: SAP

 

Figure 3 shows ongoing work/updates to Live Office.

5liveofficeunxtimelines.png

Figure 4: Source: SAP

 

UNX support for Live Office will be available by end of Q2

6unifiedplanning.png

Figure 5: Source: SAP

 

Figure 5 covers the unified planning model.

7convergence.png

Figure 6: Source: SAP

 

Figure 6 shows the convergence time line

 

The speaker also mentioned the "Concept of Unified Excel client as part of Design Studio/Lumira story" and to learn more at TechEd next month.

 

Related:

Stay Ahead : Attend TechEd && d-code – Win Big SAP BI BusinessObjects HANA Hands-on Sessions

Join SAP at the end of October for Reporting & Analytics 2014 INTERACTIVE conference - register here

This was a webcast today with SAP's David Stocker.

 

The usual SAP legal disclaimer applies that things in the future are subject to change

 

New roadmaps are coming at Las Vegas SAP TechEd

1aroadmap.png

Figure 1: Source: SAP

 

BW supports of all BEx queries, calculated/restricted measures, structures, all types of variables, special OLAP functions, runtime currency conversion, variable merge and unmerge, full hierarchy support, and compact axes as of Q3 2014

 

In Q4 SAP plans to release in November Analysis Office 2.0

 

Convergence with Live Office is not in immediate timeline; SAP is working on EPM client

 

A future direction for Analysis Office to store and run on HANA and where HANA is acting as BIP/BW

2unifiedplanning.png

Figure 2: Source: SAP

 

Figure 2 covers the EPM for BPC server

 

There is a convergence strategy with Analysis Office & EPM the speaker said they are not there yet

 

There is a NetWeaver Planning model in BW 740.  The next step comes in Analysis Office 2.0 to implement a core framework with both apps installed together.

3hanamodelsaoffice.png

Figure 3: Source: SAP

 

Native means connecting to the HANA backend up until 1.4 using the ODBC connection.  Customers for security reasons can’t use ODBC.

 

With Analysis 2.0 you can do http or https connection to backend to be used for Cloud with the BICS on client on backend

4figaoffice20.png

Figure 4: Source: SAP

 

Figure 4 shows how to define a local connection in Analysis Office 2.0: Use context menu and insert host name, port

5aofficehanasupportedfeatures.png

Figure 5: Source: SAP

 

Figure 5 shows HANA /Analysis Office supported features, including scaling factor support

6featuresnotsupported.png

Figure 6: Source: SAP

 

Level based hierarchies can’t have multiple parents; this also applies to Design Studio

 

SAP note 2038663 is a general BICS on Hana limitation which also applies to Design Studio

 

The speaker said “any limitation here also applies to Design Studio”

7platformrecom.png

Figure 7: Source: SAP

 

BIP is the recommended platform

8figurea20sso.png

Figure 8: Source: SAP

 

SAML ticket is the same mechanism that Design Studio uses in the BI Platform to Hana scenario

9aofficehanabest.png

Figure 9: Source: SAP

 

The best practices are also the same for Design Studio

 

Build smaller, more dedicated calc views, easier for when user comes in contact with query

 

Part 2 is coming, focusing on Design Studio with Question & Answer

 

Related:

Consider attending SAP TechEd && d-code .  Join ASUG for the ASUG SAP TechEd Pre-conference HANDS-ON: SAP BusinessObjects BI 4.1, SAP BW and SAP BW on SAP HANA – All in One Day, October 20th.  This includes exercises for Analysis Office and SAP BusinessObjects Design Studio. Register today

 

Also see:

Stay Ahead : Attend TechEd && d-code – Win Big SAP BI BusinessObjects HANA Hands-on Sessions

 

Next week David Stocker is presenting BI on Excel Update and Roadmap at the ASUG SAP Analytics BusinessObjects Conference. See Predictive Analysis and Analysis Sessions a ASUG SAP Analytics BusinessObjects Conference

 

Join SAP at the end of October for Reporting & Analytics 2014 INTERACTIVE conference - register here

On our “How to Guidelines” session of our “SAP BusinessObjects Analysis, edition for Microsoft Office” wiki page you can check all information to set the result size limit of your Analysis for Office. You can also check how to analyze the limit once you got a limit issue. Check it out: Analysis for Office Result Limit and Memory Consumption.

 

There you will find:

  • Front End Requirements and Memory Consumption
  • .NET Framework
  • Result size Configuration
  • Customizing table RSADMIN
  • Checking on RSTT trace

 

Thanks,

Diego Ferrary

ASUG.pngDCODE.png

 

Continuing the ASUG SAP TechEd && d-code meet the speaker series (Las Vegas), I am pleased to introduce speaker Joyce Butler

 

Joyce has been an ASUG Volunteer since 2002 and she is also anSAP Mentor

 

Joyce is presenting session EA 117 End Analysis Paralysis with the ASUG Analysis Influence Council

IngoandJoyce.png

Meet Joyce (pictured left with SAP Ingo Hilgefort) :

 

Joyce is an SEC Alabama Crimson Tide football fanatic.  She is also the lead for the ASUG Analysis Influence Council.

 

She has "led over 14 full life cycle SAP BI projects within both supply chain and finance Since 1999, implementing SAP Business Intelligence decision support applications for use in financial and supply chain reporting and analysis ASUG volunteer since 2002" according to her speaker profile.  In addition to leading this ASUG Analysis Influence Council, she also leads the Design Studio Influence Council and services as the ASUG Analtyics Special Interest Group chair.

 

I asked SAP's David Stocker to comment on Joyce and he said the following:

 

Joyce’s hard work as an ASUG leader is instrumental in connecting SAP to the heartbeat of our BI user community; and the community to SAP.

 

Joyce helps lead the council in gathering requirements, driving towards a better solution for the customer and SAP.  You can see the Council's achievements How ASUG Members Influenced Analysis Office (and Sneak Preview)

 

The council helps drive product strategy for the next major release and upcoming releases.  It is one of the best benefits of ASUG.  Here is the abstract for this session:


Influence SAP at this open and interactive session for the ASUG Influence Council for SAP BusinessObjects Analysis, editions for Microsoft Office and OLAP. SAP would like your feedback and the ASUG Influence Councils are the best form of input back to SAP. Learn how this Influence Council has already influenced SAP.

 

I asked Joyce what else she is doing at SAP TechEd && d-code and she is attending the SAP BusinessObjects BI 4.1 and SAP BW – All in One Day Pre-conference session on October 20th (see more information here)

 

Here are some great blogs by Joyce:

My opinions and take-aways ASUG2014 and SapphireNow

Be Heard - Join us for ASUG:SAP BOBJ Design Studio Influence Council Update

BI Strategy - part 1 Table of Contents

 

Get Joyce's take on TechEd from this video from last year.  She's been attending TechEd since 2002!

"You build IT Solutions for your business users"

Joyce also wants to see SAP's Ingo Hilgefort as a raccoon You would like to see me as a racoon... here is your chance....

ASUG Pre-conference Sessions

ASUG is has opened registration for pre-conferences session at SAP TechEd && d-code on Monday, October, 20th  - see Announcing ASUG SAP TechEd d-code Pre-Conference Sessions

 

See Your fast track to the SAP HANA Cloud Platform at the ASUG pre-conference posted today by Rui Nogueira

 

Appendix:

Join ASUG at SAP TechEd && d-code

OCTOBER 20-24
Venetian/Palazzo Congress Center


ASUG SAP d-code Las Vegas sessions are now published - for a complete listing please see here

 


Related:

Meet ASUG SAP d-code Speaker Charles Reeves - Implementing Enterprise Master Data Management

ASUG SAP d-code SAP BW 7.4 powered by SAP HANA Speaker - Introducing Pawel Mierski

ASUG SAP d-code Sessions Are Published - Featuring SAP Mentors

Journey to Mobile BI - Meet ASUG SAP d-code Speaker Peter Chen

Did you know?

Meet ASUG SAP TechEd d-code Speaker Kumar Chidambaram - Holistic BI BW on HANA Approach

Meet ASUG SAP TechEd d-code Speaker Heiko Zuerker - Solution Manager

Meet ASUG SAP TechEd d-code Speaker Sue Keohan - Customer Connection for Workflow

Effective SAP ERP on HANA Migration Strategy - ASUG SAP TechEd d-code Speaker Rajesh Gupta

Meet ASUG SAP TechEd d-code Speaker Girish Manmadkar - SAP HANA on VMWare Best Practices

Newell Rubbermaid Mobile Story to Improve Sales - ASUG SAP TechEd d-code Speaker Mohammed Siddiqui

Meet ASUG SAP TechEd d-code Speaker Sue Keohan - Customer Connection for Workflow

ASUG SAP TechEd d-code Speaker Profile - Martin Maguth - Top 10 Tools for Workflow Administrators

Comprehensive SAP Monitoring – Recognize Problems Before Your Users Do - Meet ASUG SAP TechEd d-code Speaker Jon Friesen

Meet ASUG SAP TechEd d-code Speaker Dave Beldyk of DuPont - Learn about Wood Turning

Meet ASUG SAP TechEd d-code Speaker Jolene Jonas and Learn about Intel's Master Data Program

Meet ASUG SAP TechEd d-code Speaker Kyle Wardell - Migrating Dual Stack Systems - Jump

http://scn.sap.com/servlet/JiveServlet/showImage/38-111039-503678/asug.png

Join ASUG in October and meet Joyce in person.

Hi Customers,

 


SAP just delivered Analysis for Office 1.4 SP8 that contains the following SAP corrections:

 

  • 2041930 Convert To Formula does not work for dimension members with spaces
  • 2041133 Analysis Office dumps when importing text files into MS Excel with drag and drop
  • 2038901 Analysis Office prevents Excel from closing
  • 2038664 Log file contains API errors for SAPGetDimensionStaticFilter
  • 2037259 Analysis Office: Error at undo operation after workbook has been closed
  • 2034227 Text: 'Insert System.Reflection.Missing' in statistic step when inserting a query of query view
  • 2032253 Precalculation fails for workbooks with named ranges including special characters
  • 2032238 Enabled NCo tracing for BiPrecalculation
  • 2032085 AO: Timeout when trying to display list of data source from BIP
  • 2032069 AO on Office 2013: Inserting a data source from the backstage menu results in a exception
  • 2031598 Launcher does not create new Excel 2013 process
  • 2031244 Launcher fails when using Excel 2003
  • 2029946 Poor performance with large filters on Analysis tab
  • 2029886 AO 1.4: Excel 2013 - Performance issues when switching the context and when working with several workbooks
  • 2029832 Filter by Measure with Measure in Filter and Structure in the rows
  • 2028809 Exception when clicking in crosstab
  • 2028695 Using an apostrophe within a sheet name leads to an exception
  • 2027858 Bad performance during grid rendering in case of huge amount of columns
  • 2027119 Analysis Office: drag and drop / expanding hierarchy nodes not working using Excel 2013
  • 2027085 Adding the flat presentation of a dimension to the background filter does not work
  • 2026682 Reset Data Source and cancelling Prompts results in exception
  • 2025501 Filter Dialog and Value Help set and activate hierarchy for characteristic
  • 2025417 Removed Attributes / Access Mode menu entries for Mass Data Filter Dialog
  • 2023668 Missing translations in case of context menu for Execute Planning Function, Planning Sequence and Add Member tooltip
  • 2023432 Analysis Office: Exception if inserting a workbook from BW server after inserting a workbook from BIP server
  • 2023003 Missing alternative location for 'sapaocache' used for temporarily saved documents locally when opening Analysis workbooks from server
  • 2022924 Performance issue when pasting members from clipboard into Filter Dialog or Value Help
  • 2021910 Default value of setting CompressMetadata changed to true
  • 2021646 Workbook Logon User is not available when opening a workbook from the BIP Launchpad
  • 2020833 Analysis Office: filter information not displayed with correct member presentation
  • 2020434 Logging of AO launcher
  • 2020351 Propagate selection in hierarchically displayed keyfigures
  • 2019598 Poor performance when clicking on the information tab
  • 2019160 Exception Invalid Program Status\: No result set available when Pause Refresh is active
  • 2018409 SAPCallMemberSelector ignores parameter Selector Type if hierarchy is assigned to characteristic
  • 2018358 Analysis Office: Saving new document to the name and path of an existing document does not display a warning popup
  • 2017718 Formulas show error #N/A when cancelling prompts dialog
  • 2017317 AO 1.4: Wrong message "Data was saved (BRAIN-242)"
  • 2017284 Open workbook from backend several times may result in exception in case of OSS connection
  • 2016959 Formulas SAPListOfEffectiveFilters and SAPListOfStaticFilters only contains dimensions in drilldown
  • 2016735 AO cannot be used with Turkish regional settings
  • 2015452 AO 1.4: Hierarchy date is wrong for 9999/12/31
  • 2015441 Mass Data Filter dialog throws Out of Memory exception when too many data is pasted from clipboard
  • 2013551 User stylesets are missing after upgrade of Analysis Office
  • 2011200 AO: Undo history always contains the same decription text when changing the member access mode
  • 2011170 Emphasized formats does not occur correctly on planning cells
  • 2011111 Empty columns get rendered with maximum width
  • 2010638 Presentation doesn't get saved back to server on save
  • 2009865 Filter Dialog : Wrong data for member access mode
  • 2009468 Possible COMException with code 0x800A03EC when opening an Analysis workbook from server
  • 2008793 When launching variable prompts screen possible long messages are not available in message window
  • 2008055 Wrong node selection after change of time dependent master data object with enabled hierarchy in prompts dialog
  • 2007114 Translation not applied after copy of cross tab in components tab
  • 2006943 ArgumentException in some cases occuring if there are multiple sheets with same name in the workbook
  • 2005454 Searching for a Analysis workbook or presentation by description on BIP not possible
  • 2005434 Filter Dialog: Single value selection isn't applied
  • 2005278 Search in Filter Dialog on characteristic with hierarchy enables paste button
  • 2004759 Save Dialog: Entering a workbook name using IME
  • 2004021 SAP Formula is not calculated correctly when entered into a blank workbook
  • 2003968 Save Analysis workbook to BIP Folders view does not work
  • 2003401 Validating a variable value in the prompt dialog
  • 2003354 AO: Excel 2013 - Taskpane is still shown after closing a workbook
  • 2003278 Analysis chart is losing swap state of rows and columns after refresh
  • 2002592 Filter Dialog : Missing Access Mode switch for calendar view
  • 2002573 Formula shows result twice
  • 2001286 Analysis Office: nodes without text in Design Panel
  • 2000392 Server Type "Group" feature for Analysis Precalculation
  • 1994876 Value help does not display correct data
  • 1983668 Analysis Office: BEx Conditions and condition states in UI
  • 1976283 Error saving workbooks to BIP with relational connection to HANA system
  • 1962934 Performance: Pause Screen Update for Hidden Crosstabs
  • 1954665 Presentation doesn't get saved back to server on close
  • 1518359 SAP BusinessObjects Analysis Office & BIP Add On Release schedule


To download the Analysis for Office Client's support package 8 please click here.

To download the Analysis for Office BIP Add on support package 8 please click here.

 

You can also check SAP note 1910505 - Analysis Office 1.4: Release Note for SP8.


Thanks,

Diego Ferrary

Support Team, NW Technology, AGS Primary Support

SAP Labs Latin America

 

For more Analysis for Office tool please check:
http://help.sap.com/boao
http://wiki.scn.sap.com/wiki/x/-gCYE

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.

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

Actions

Filter Blog

By author:
By date:
By tag: