Product versions: Desktop Intelligence , WebIntelligence 6.5, XIr2, XIr2 SP2, XI3.0, XI3.1, XI3.1 SP2
Important: details collected through the community. Not validated or endorsed by SAP Product management.
Web Intelligence features that Desktop Intelligence does not have
| Interactive Viewing Over the Web (sort, filter, formula & variable creation, etc.. All editing 40+ features related to the edition of the report benefiting to all of interactive users) |
| Track Data Changes |
| Server Side Ranking as a Query Filter |
| Synchronized Data Providers is much easier to use |
| Drill over the Web |
| Significant Performance Benefits |
| Improved Prompting |
| Support for SAP data sources |
| Format Painter |
| Extended function set (interpolation, relativeValue, query&prompt&filter summary functions) |
| Input Controls (from XI3.1 SP2) |
Features covered in Convincing Reasons to Move to Web Intelligence
| Query prompt sequence |
| Query prompt properties |
| Optional Prompt |
| Duplicate query |
| Report filters |
| Complex report filters |
| Custom sorts |
| Ranking |
| Alerters |
| Functions |
| Change query universe |
| Synchronized drill-down |
| Interactivity over the web (HTML and dHTML (Interactive Viewer)) |
Additional resources
Desktop Intelligence features added to WebIntelligence
the feature exists
the feature exists partially or has workarounds
the feature does not exist
Each of the feature should be pondered by the frequency of use and the type of users.
Deski Features | 6.5 | XIr2 | XIr2 SP2 | XI3.0 | XI3.1 | XI3.1 SP2 |
|---|---|---|---|---|---|---|
Synchronized Data Providers |
|
|
|
|
|
|
Edit SQL |
|
|
|
|
|
|
Offline Capability |
|
|
|
|
|
|
Embedded images |
|
|
|
|
|
|
Server Value function |
|
|
|
|
|
|
Query on Query |
|
|
|
|
|
|
Non-Universe Data Providers |
|
|
|
|
|
|
Stored Procedures |
|
|
|
|
|
|
XML Data Provider |
|
|
|
|
|
|
Personal Data Providers |
|
|
|
|
|
|
Free-hand SQL |
|
|
|
|
|
|
Visual Basic Data Provider |
|
|
|
|
|
|
Interactivity |
|
|
|
|
|
|
Fold/Unfold Horizontal |
|
|
|
|
|
|
Fold/Unfold Vertical |
|
|
|
|
|
|
Complex Block Filters |
|
|
|
|
|
|
Value-based breaks |
|
|
|
|
|
|
Multiple level breaks |
|
|
|
|
|
|
Hide/Show Object |
|
|
|
|
|
|
Multicube() function |
|
|
|
|
|
|
NoFilter() function |
|
|
|
|
|
|
Formatting |
|
|
|
|
|
|
Custom Grouping |
|
|
|
|
|
|
Data Ranking Support (Top N) |
|
|
|
|
|
|
User Defined Hierarchies |
|
|
|
|
|
|
Find within a Report |
|
|
|
|
|
|
Export as XML |
|
|
|
|
|
|
Add-Ons |
|
|
|
|
|
|
VB Customization |
|
|
|
|
|
|
Multiple VBA Macros |
|
|
|
|
|
|
Templates |
|
|
|
|
|
|
Find within a Universe |
|
|
|
|
|
|
Series Charts |
|
|
|
|
|
|
Custom function |
|
|
|
|
|
|
Note 1: The new report wizard option "Others->Free-hand SQL" is not available in WebI but you can overcome this by editing the SQL of a dummy universe object and / or using a derived table. The details of this workaround are discussed on this forum post : http://www.forumtopics.com/busobj/viewtopic.php?t=126518&highlight=fhs.
Note 2: This can be achived by using the Custom Data Provider Plug-in which provides a framework to develop your own data provider, therefore allows you to consume potentially any data provider into Web Intelligence. The Developer Guide posted at http://help.sap.com/businessobject/product_guides/boexir31SP2/en/xi31_sp2_cdp_dev_en.pdf goes in more details. Essentially this should allow Visual Basic Data Providers developed for Deski to be re-used in Webi.
1 Comment
Andreas J.A. Schneider
This list is not up-to-date (SAP BI 4.1 SP5 missing), I kindly suggest updating this or maybe even removing this