web intelligence 4.0 sp05 what's new
Post on 01-Nov-2014
136 Views
Preview:
DESCRIPTION
TRANSCRIPT
© 2012 SAP AG. All rights reserved. 2 Ramp-Up Knowledge Transfer Customer
Web Intelligence 4.0 Service Pack 5 Quality, Usability and Stability Improvements
PLANNED INNOVATIONS
Continuous improvement is our first focus. This deals with global application stability, enhancements for
most used interactions, and performance.
Web Intelligence performance on BW improvement
Query browsing
Query stripping default value
BEx Hierarchy management
Differentiate version dependent hierarchies
Level selection enhancements
Chart layout improvement
Wrap text on Pie chart data labels
© 2012 SAP AG. All rights reserved. 3 Ramp-Up Knowledge Transfer Customer
Performance
Refresh workflow improvements
Less round trip to define required variable values
Query Browsing
Reduced time to retrieve Bex queries referenced by a given connection
© 2012 SAP AG. All rights reserved. 4 Ramp-Up Knowledge Transfer Customer
Expand to Level
By default, the retrieved data for hierarchies are limited to the depth level indicated
by the “Expand to level” value in the Bex query
In BI 4.0 SP5, IT can change this behavior in the bootstrap command line of the
Adaptive Processing Server by adding a new parameter
-Dsap.sl.bics.expandToLevel=n
When set, Web Intelligence retrieves the data from the root to the nth depth level
Warning
By setting a value too high, Web Intelligence will retrieve the entire hierarchy data
which will have an important impact on the performance and stability of the system.
Recommendation
Report creator should always indicate explicitly the number of the hierarchy levels
they want to retrieve while designing their report queries
Note : n can take any number between 0 to 99
If n=0 or the command line parameter is not set, then hierarchies will take the « Expand to Level » parameter value into account
© 2012 SAP AG. All rights reserved. 5 Ramp-Up Knowledge Transfer Customer
How to set the new Parameter in the CMC
In the Central Management Console, logged
with an Administrator account.
Select the entry Servers.
Select the entry Web Intelligence Services in
the Service Categories.
Select the Adaptive Processing Server which
has been configured with the DSL Bridge
Service
In the menu item Properties.
Navigate to the Command Line Parameters
property.
Now add the additional command line:
-Dsap.sl.bics.expandToLevel=7
© 2012 SAP AG. All rights reserved. 6 Ramp-Up Knowledge Transfer Customer
Differentiate Version Dependent Hierarchies – Query Time
The query designer can differentiate the hierarchies versions.
© 2012 SAP AG. All rights reserved. 7 Ramp-Up Knowledge Transfer Customer
Differentiate Version Dependent Hierarchies – Report Time
The report displays the hierarchy version that was used at design time
© 2012 SAP AG. All rights reserved. 8 Ramp-Up Knowledge Transfer Customer
Level Selection – Ordinal (1/2)
Levels are identified by their
ordinals
Benefit: Avoid issues when
level name are translated in
different languages
Note : In this example “Level 03” is preceded by its ordinal “3”
© 2012 SAP AG. All rights reserved. 9 Ramp-Up Knowledge Transfer Customer
Level Selection – Ordinal (2/2)
The level selection now displays and uses this ordinal
© 2012 SAP AG. All rights reserved. 10 Ramp-Up Knowledge Transfer Customer
Level Selection
Members selection and levels selection can not be mixed
After selecting all members until a specified named level. It is no longer possible to
select a member which depth is deeper than the previous specified level depth
Note : In this example, after selecting “Select all Members until Named Level -> 2 – Level 02” it is not possible to select Canada or USA
© 2012 SAP AG. All rights reserved. 11 Ramp-Up Knowledge Transfer Customer
Enable Query Stripping
IN BI 4.0 SP5 , the query stripping query property is enabled by default for
BICS data sources
There is no change for already created queries on BICS
© 2012 SAP AG. All rights reserved. 12 Ramp-Up Knowledge Transfer Customer
Wrap Text on Pie Chart Data Labels
Data labels on pie chart can be wrapped
for a better layout
Without wrap text:
With wrap text:
© 2012 SAP AG. All rights reserved. 13 Ramp-Up Knowledge Transfer Customer
Web Intelligence 4.0 Service Pack 5 Developer Support
PLANNED INNOVATIONS
Provide RESTful Web services API for report consumption and scheduling
Raylight RESTful Web services
Document consumption (view, refresh, simple prompt
management)
Document scheduling
© 2012 SAP AG. All rights reserved. 14 Ramp-Up Knowledge Transfer Customer
Raylight RESTful Web Services
New RESTful Web Services
Goal to replace previous SDK
Incremental delivery with next set of APIs in BI 4.1
Technology agnostic
Can be used from any languages (Java, .Net, etc.)
Can be used from any computer or mobile device
Consistency
Plugged to CYPRESS – BOE Platform REST Web Services which offers the necessary
infrastructure to connect and authenticate user to BOE platform
Consistent with SAP strategic directions for SDK
© 2012 SAP AG. All rights reserved. 15 Ramp-Up Knowledge Transfer Customer
BI 4.0 SP5 Web Intelligence Raylight SDK High Level Workflows Description
Consume WebI document
Browse CMS to find WebI Documents
Get WebI Document details
Open, Refresh, Save, Close WebI document
Support Prompts, type Text, Numeric, Optional
Export Document, Report, Page of a report in listing or paginated mode [xls, xlsx, pdf, xml (+html for report and page)]
Get list of data providers of a WebI document
Get details of a data provider of a WebI Document
Export data (data provider) as CSV or XML
Purge document
Schedule WebI document
All possible destinations
Main recurrences (Once, Hourly, Daily, Weekly, Monthly, …)
All possible formats and options
Support of server group
Get details of a schedule
Add new schedule
© 2012 SAP AG. All rights reserved. 16 Ramp-Up Knowledge Transfer Customer
© 2012 SAP AG. All rights reserved.
No part of this publication may be reproduced or transmitted in any form or for any purpose
without the express permission of SAP AG. The information contained herein may be
changed without prior notice.
Some software products marketed by SAP AG and its distributors contain proprietary
software components of other software vendors.
Microsoft, Windows, Excel, Outlook, PowerPoint, Silverlight, and Visual Studio are
registered trademarks of Microsoft Corporation.
IBM, DB2, DB2 Universal Database, System i, System i5, System p, System p5, System x,
System z, System z10, z10, z/VM, z/OS, OS/390, zEnterprise, PowerVM, Power
Architecture, Power Systems, POWER7, POWER6+, POWER6, POWER, PowerHA,
pureScale, PowerPC, BladeCenter, System Storage, Storwize, XIV, GPFS, HACMP,
RETAIN, DB2 Connect, RACF, Redbooks, OS/2, AIX, Intelligent Miner, WebSphere, Tivoli,
Informix, and Smarter Planet are trademarks or registered trademarks of IBM Corporation.
Linux is the registered trademark of Linus Torvalds in the United States and other countries.
Adobe, the Adobe logo, Acrobat, PostScript, and Reader are trademarks or registered
trademarks of Adobe Systems Incorporated in the United States and other countries.
Oracle and Java are registered trademarks of Oracle and its affiliates.
UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open Group.
Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, and MultiWin
are trademarks or registered trademarks of Citrix Systems Inc.
HTML, XML, XHTML, and W3C are trademarks or registered trademarks of W3C®,
World Wide Web Consortium, Massachusetts Institute of Technology.
Apple, App Store, iBooks, iPad, iPhone, iPhoto, iPod, iTunes, Multi-Touch, Objective-C,
Retina, Safari, Siri, and Xcode are trademarks or registered trademarks of Apple Inc.
IOS is a registered trademark of Cisco Systems Inc.
RIM, BlackBerry, BBM, BlackBerry Curve, BlackBerry Bold, BlackBerry Pearl, BlackBerry
Torch, BlackBerry Storm, BlackBerry Storm2, BlackBerry PlayBook, and BlackBerry App
World are trademarks or registered trademarks of Research in Motion Limited.
Google App Engine, Google Apps, Google Checkout, Google Data API, Google Maps,
Google Mobile Ads, Google Mobile Updater, Google Mobile, Google Store, Google Sync,
Google Updater, Google Voice, Google Mail, Gmail, YouTube, Dalvik and Android are
trademarks or registered trademarks of Google Inc.
INTERMEC is a registered trademark of Intermec Technologies Corporation.
Wi-Fi is a registered trademark of Wi-Fi Alliance.
Bluetooth is a registered trademark of Bluetooth SIG Inc.
Motorola is a registered trademark of Motorola Trademark Holdings LLC.
Computop is a registered trademark of Computop Wirtschaftsinformatik GmbH.
SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP BusinessObjects Explorer,
StreamWork, SAP HANA, and other SAP products and services mentioned herein as well
as their respective logos are trademarks or registered trademarks of SAP AG in Germany
and other countries.
Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal
Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services
mentioned herein as well as their respective logos are trademarks or registered trademarks
of Business Objects Software Ltd. Business Objects is an SAP company.
Sybase and Adaptive Server, iAnywhere, Sybase 365, SQL Anywhere, and other Sybase
products and services mentioned herein as well as their respective logos are trademarks or
registered trademarks of Sybase Inc. Sybase is an SAP company.
Crossgate, m@gic EDDY, B2B 360°, and B2B 360° Services are registered trademarks
of Crossgate AG in Germany and other countries. Crossgate is an SAP company.
All other product and service names mentioned are the trademarks of their respective
companies. Data contained in this document serves informational purposes only. National
product specifications may vary.
The information in this document is proprietary to SAP. No part of this document may be
reproduced, copied, or transmitted in any form or for any purpose without the express prior
written permission of SAP AG.
top related