Your private cache of Business Objects Tips, Tricks, Tools and Work Arounds.
Official Product Tutorials – SAP BusinessObjects Business Intelligence Platform
Official Product Tutorials – SAP BusinessObjects Business Intelligence Platform created by SAP User on Sep 17, 2010 12:00 AM, last modified by Joanna Denfordon Mar 14, 2012 11:45 PM Version 7 <:section> The following tutorials have been developed to help you get started using the Business Intelligence Suite products. New content is added as soon as it becomes available,...
Business Objects 4.0 Feature Pack 3 – Summary of Features
So with BI 4 Feature Pack 3 now in ramp-up, I thought I would pull together all my feature pack 3 blogs and provide a high level summary, based on the many webcasts I have attended.  Note as all the blogs have stated, things are subject to change and the usual disclaimer applies.  As some of these sessions dated back to August 2011, please note that not features may be there in the ramp-up versi...
Business Objects 4.0 Sneak Preview
Cannot Open Excel File by double clicking !
Solution : Goto Excel options > Advanced tab > General Section: Make sure "Ignore other applications that use DDE" is unchecked .
Outlook experienced a serious problem with the Business objects live office xi 3.1 add-in.
Are you getting "Outlook experienced a serious problem with the Business objects live office xi 3.1 add-in." after installing business objects live office 12.0 ? To resolve this issue : Navigate to C:\Program Files>Business Enterprise 12.0\Live Office 12.0 Click on “enable_addin.exe” Un Check Enable BusinessObjects Live Office XI 3.1 for MicroSoft Office Outlook Press OK.
Business Objects XI 4.0 (Aurora) – New Features !
SAP BusinessObjects BI and EIM 4.0 Overview View more presentations from SAP Analytics.
BOXI 3.1 UserList & Group Extraction
Here is the link to BOXI 3.1 UserList & Group Extraction tool which was origionally posted on BOBJ Webstie by Julian Brass. I have updated the code to get it working in 3.1. BOXI_UserListV3 3.1 Version Thanks.
Left navigation panel not getting displayed in XIR2
Click on selection for 'Left Panel' at the top under "View" in infoview.
CORBA Initialization failed. (WIS 10901) error in WebI Rich Client 3.1
To resolve "CORBA Initialization failed". (WIS 10901) error in WebI Rich Client 3.1 you will need to restart server intelligence agent .
WebI Exporting to excel error "File error : data may have been lost."
This Issue is resolved in BO XI R2 SP4 and SP5
What are the advantages of a universe?
1. Only the universe designer needs to know how to write SQL and understand the structure of the target database. 2. The interface allows you to create a universe in an easy-to-use graphical environment. 3. Data is secure. Users can see only the data exposed by the universe. Users only read data, not edit it. 4. The results are reliable and the universe is relatively easy to maintain. 5. Users...
A Good Universe !
1. Gives Access just to the data the users need for reporting and analysis. 2. Is easy to maintain. 3. Is easy to use. For Example, it does not contain too many objects and Classes and Sub-Classes. 4. Generates efficient SQL. 5. Contains no more than 500 objects and the .unv file is no bigger than 1mb in size.
How to retrieve thirteen months prior data in Web Intelligence !
Create a Web Intelligence report with [Date object], other objects, measures#etc After the report is generated define a variable #13-Months-Back# using #RelativeDate()# to approximately minus the current date with 13 months as following 13-Months-Back=RelativeDate([Date Object];-395) . Now insert a new column in the report and place #Thirteen_Months_Back# variable object. Use #13-Months-...
How to create a custom drill-down hierarchy for a Web Intelligence
In the universe Designer, on the 'Tools' menu, click Hierarchies. Choose the desired class from 'Default Hierarchies' panel. Add it to the 'Custom Hierarchies' area. Click OK. Click Save > Export. In Web Intelligence document : Add the dimension that is at the top of the hierarchy to the report. Click Drill under the 'Edit Report' tab. Save the Web Intelligence document.
How to create templates in WebIntelligence?
Currently in XI R2 there is no option of using templates in Web intelligence. Following workaround can be utilized for report templates. Create a web intelligence report with the required format that points to a universe(dummy universe) to use it as a template. While creating a new web intelligence report, use the above report and (Select query->Properties tab->Universe) re-point the r...
How to optimize Memory collection of WebI Java Panel
1. The usage of IE is about 30MB when log in infoview. 2. After edit webi report many times, the usage of IE go up to 200MB. The memory usage is up to the time that you do edit action. 3. The memory can not be released after stop editing webi report and log out of infoview. 4. If user continually open and close Java Panel IE will hang. It was caused by the poorly Memory Collection mechanism of We...
How to search any text data In Web Intelligence report.
Use Draft mode instead of view/page mode. Press Control+F > Type Text and search
To add a summary column with totals for each dimension in a crosstab in a WebIntelligence.
1. Create a Crosstab using Dimension and Measure. 2. Add a break on Dimension by clicking on the cell -> Insert -> Break 3. The crosstab will be broken down by that dimension 4. Click on measure in the body of the crosstab and click the SUM # icon
BusinessObjects Guides
BusinessObjects Products guides BusinessObjects Enterprise Administrator’s Guide BusinessObjects Enterprise™ XI. Getting Started Guide BusinessObjects Enterprise. InfoView Guide
Looking for Service Packs or Hot Fix ?
Here is the site if you are looking fora Service Packs or Hot Fix for Business Objects. SAP Software Download

Official Product Tutorials – SAP BusinessObjects Business Intelligence Platform

Official Product Tutorials – SAP BusinessObjects Business Intelligence Platform created by SAP User on Sep 17, 2010 12:00 AM, last modified by Joanna Denfordon Mar 14, 2012 11:45 PM Ver ...Read More

Business Objects 4.0 Feature Pack 3 – Summary of Features

So with BI 4 Feature Pack 3 now in ramp-up, I thought I would pull together all my feature pack 3 blogs and provide a high level summary, based on the many webcasts I have attended.  Note a ...Read More

Cannot Open Excel File by double clicking !

Solution : Goto Excel options > Advanced tab > General Section: Make sure "Ignore other applications that use DDE" is unchecked . ...Read More

Official Product Tutorials – SAP BusinessObjects Business Intelligence Platform

Posted By: admin on March 23, 2012 in Uncategorized - Comments: No Comments »

Official Product Tutorials – SAP BusinessObjects Business Intelligence Platform

created by SAP User on Sep 17, 2010 12:00 AM, last modified by Joanna Denfordon Mar 14, 2012 11:45 PM

<:section>

The following tutorials have been developed to help you get started using the Business Intelligence Suite products. New content is added as soon as it becomes available, so check back on a regular basis.

Are there topics we’ve missed or things we can improve? Submit new ideas or vote on existing ones to help us better address your learning needs for the BI Suite of products.

Looking for eLearning for the rest of the Business Intelligence Suite?  Go to the Official Product Tutorials – SAP BI Suite page.

Note: The process flows are interactive diagrams that show how platform components interact during common business intelligence tasks. If a diagram does not display correctly, please refresh its browser window to reload it.

 

General Platform

 

Central Management Console

 

Crystal Reports 2011 Process Flows

 

Crystal Reports for Enterprise Process Flows

 

Live Office Process Flows

 

Web Intelligence Process Flows

 

Analysis, edition for OLAP Process Flows

 

Dashboards Process Flows

 

Explorer Process Flows

 

Upgrade Management Tool

 

 

* Includes changes for the 4.0 release.

To report a technical issue with a tutorial, send an email to: BI_Suite_eLearning@sap.com.

If you liked this post, buy me a beer. (Suggested: $3 a beer or $7.5 for a pitcher)

Business Objects 4.0 Feature Pack 3 – Summary of Features

Posted By: admin on March 22, 2012 in business objects, Business Objects 4.0 - Comments: 2 Comments »

So with BI 4 Feature Pack 3 now in ramp-up, I thought I would pull together all my feature pack 3 blogs and provide a high level summary, based on the many webcasts I have attended.  Note as all the blogs have stated, things are subject to change and the usual disclaimer applies.  As some of these sessions dated back to August 2011, please note that not features may be there in the ramp-up version.

BusinessObjects Explorer:

1fp3explorer.jpg

Figure 1: Source: SAP

Figure 1 shows high level summary features for BusinessObjects Explorer.  The biggest buzz is on Exploration Views and geospatial analysis.

 

BI Launch Pad and Workspaces

2fp3bilaunchpad.jpg

Figure 2: Source: SAP

Figure 2 shows the StreamWork integration with the BI launch pad.

Crystal Reports for Enterprise

3figfp3.jpg

Figure 3: Source: SAP

Figure 3 covers Crystal for Enterprise and one key new feature is the Report to Report Interface.

Dashboards

 

4fp3dashboard.jpg

Figure 4: Source: SAP

Figure 4 shows Feature Pack 3 enhancements for Dashboards, featuring the unified query support.  SAP says “Insight to Action” allows closing the loop on a business process from a BI client to an external target.  This feature is available for Crystal and Dashboards in Feature Pack 3.

Web Intelligence

5fp3webi.jpg

Figure 5: Source: SAP

Figure 5 shows Feature Pack 3 enhancements for Web Intelligence, including improved hierarchy support and Web Intelligence Rich Client Quick launch.

Analysis, Edition for OLAP

6figfp3aolap.jpg

Figure 6: Source: SAP

Figure 6 shows improvements for Analysis OLAP, including improved support for BW and focused analysis feature.

I am skipping Analysis Office, as it is platform independent and not reliant on a BI platform.

Semantic Layer

7figfp3.jpg

Figure 7: Source: SAP

Figure 7 shows HANA optimization, and probably the best feature for ERP customers is the ability to access ECC via the semantic layer.

BI Platform

9figfp3biplat.jpg

Figure 9: Source: SAP

Figure 9 shows BI Platform improvements, including a better upgrade experience.

10figbiplat.jpg

Figure 10: Source: SAP

Figure 10 shows improvements in Life Cycle Management and monitoring.  ASUG has an upcoming webcast to cover these Feature Pack 3 enhancements in more detail.

 

11figbiplat.jpg

Figure 11: Source SAP

Figure 11 shows improvements in SDK.  This was discussed at BI 2012 and ASUG has an upcoming webcast on this to cover this in more detail.

SAP Integration

8figfp3.jpg

Figure 8: Source: SAP

Figure 8 shows SAP Integration improvements with Feature Pack 3.  My favorite “fix” is the enhanced scaling factor support.

Multi-source universe access to SAP ECC should be interesting.

12figoem.jpg

Figure 12: Source: SAP

Figure 12 shows OEM enablement.

As all the webcasts stated, things were subject to change, and many of these took place last year.

If you are interested in more future directions past enhancement package 3, I encourage you to attend ASUG Annual Conference, where SAP is giving an ASUG session titled “The Future of Business Intelligence”, with SAP’s Ty Miller. 

For more details on Feature Pack 3, I highly recommend Ingo Hilgefort‘s SAP Press books:

Integrating SAP BusinessObjects BI Platform 4.x with SAP NetWeaver

  – a review by Gary Hooker says “It is a no-brainer – just get it. It will save you heaps of time and effort!” – I completely agree!

Reporting and Analysis with SAP BusinessObjects (2nd Edition)

Also, Ingo will be giving a full day hands on session on the BI 4 Feature Pack 3 tools on May 13 at an ASUG Annual Conference pre-conference session.  See here for more information and register today!

 

Related Blog Links:

Analysis Feature Pack 3
Dashboard Feature Pack 3
SAP Integration
Web Intelligence Feature Pack 3
BI Platform Feature Pack 3
BusinessObjects Explorer Feature Pack 3
SAP HANA with BI4 Feature Pack 3
General Summary
Semantic Layer / HANA

 

I thank all the SAP speakers for sharing their time and information.

 

 

 
 

If you liked this post, buy me a beer. (Suggested: $3 a beer or $7.5 for a pitcher)

Business Objects 4.0 Sneak Preview

Posted By: admin on January 21, 2011 in business objects, Business Objects 4.0, Uncategorized - Comments: No Comments »

Cannot Open Excel File by double clicking !

Posted By: admin on December 13, 2010 in Excel - Comments: No Comments »

Solution :

Goto Excel options > Advanced tab > General Section:
Make sure “Ignore other applications that use DDE” is unchecked .

If you liked this post, buy me a beer. (Suggested: $3 a beer or $7.5 for a pitcher)

Outlook experienced a serious problem with the Business objects live office xi 3.1 add-in.

Posted By: admin on May 18, 2010 in Business Objects Live Office - Comments: 1 Comment »

Are you getting “Outlook experienced a serious problem with the Business objects live office xi 3.1 add-in.” after installing business objects live office 12.0 ?

To resolve this issue :

  1. Navigate to C:\Program Files>Business Enterprise 12.0\Live Office 12.0
  2. Click on “enable_addin.exe”
  3. Un Check Enable BusinessObjects Live Office XI 3.1 for MicroSoft Office Outlook
  4. Press OK.

Live Office

If you liked this post, buy me a beer. (Suggested: $3 a beer or $7.5 for a pitcher)

Business Objects XI 4.0 (Aurora) – New Features !

Posted By: admin on May 17, 2010 in business objects - Comments: 8 Comments »

BOXI 3.1 UserList & Group Extraction

Posted By: admin on March 12, 2010 in CMC - Comments: 3 Comments »

Here is the link to BOXI 3.1 UserList & Group Extraction tool which was origionally posted on BOBJ Webstie by Julian Brass. I have updated the code to get it working in 3.1.

BOXI_UserListV3 3.1 Version

Thanks.

If you liked this post, buy me a beer. (Suggested: $3 a beer or $7.5 for a pitcher)

Left navigation panel not getting displayed in XIR2

Posted By: admin on November 7, 2009 in business objects - Comments: No Comments »

Click on selection for ‘Left Panel’ at the top under “View” in infoview.

A

If you liked this post, buy me a beer. (Suggested: $3 a beer or $7.5 for a pitcher)

CORBA Initialization failed. (WIS 10901) error in WebI Rich Client 3.1

Posted By: admin on November 4, 2009 in Web Intelligence - Comments: 9 Comments »

To resolve “CORBA Initialization failed”. (WIS 10901) error in WebI Rich Client 3.1 you will need to restart server intelligence agent .

If you liked this post, buy me a beer. (Suggested: $3 a beer or $7.5 for a pitcher)

WebI Exporting to excel error "File error : data may have been lost."

Posted By: admin on August 25, 2009 in business objects - Comments: No Comments »

What are the advantages of a universe?

Posted By: admin on August 22, 2009 in business objects - Comments: No Comments »

1. Only the universe designer needs to know how to write SQL and understand the structure of the target database.

2. The interface allows you to create a universe in an easy-to-use graphical environment.

3. Data is secure. Users can see only the data exposed by the universe. Users only read data, not edit it.

4. The results are reliable and the universe is relatively easy to maintain.

5. Users can use a simple interface to create reports.

6. All users work with consistent business terminology.

7. Users can analyze data locally.

If you liked this post, buy me a beer. (Suggested: $3 a beer or $7.5 for a pitcher)

A Good Universe !

Posted By: admin on in business objects - Comments: No Comments »

1. Gives Access just to the data the users need for reporting and analysis.

2. Is easy to maintain.

3. Is easy to use. For Example, it does not contain too many objects and Classes and Sub-Classes.

4. Generates efficient SQL.

5. Contains no more than 500 objects and the .unv file is no bigger than 1mb in size.

If you liked this post, buy me a beer. (Suggested: $3 a beer or $7.5 for a pitcher)

How to retrieve thirteen months prior data in Web Intelligence !

Posted By: admin on in business objects - Comments: 1 Comment »

  1. Create a Web Intelligence report with [Date object], other objects, measures#etc
  2. After the report is generated define a variable #13-Months-Back# using #RelativeDate()# to approximately minus the current date with 13 months as following
  3. 13-Months-Back=RelativeDate([Date Object];-395) .
  4. Now insert a new column in the report and place #Thirteen_Months_Back# variable object.
  5. Use #13-Months-Back# variable in the graph,#etc

If you liked this post, buy me a beer. (Suggested: $3 a beer or $7.5 for a pitcher)

How to create a custom drill-down hierarchy for a Web Intelligence

Posted By: admin on August 19, 2009 in business objects - Comments: 2 Comments »

  1. In the universe Designer, on the ‘Tools’ menu, click Hierarchies.
  2. Choose the desired class from ‘Default Hierarchies’ panel. Add it to the ‘Custom Hierarchies’ area.
  3. Click OK.
  4. Click SaveExport.

In Web Intelligence document :

  1. Add the dimension that is at the top of the hierarchy to the report.
  2. Click Drill under the ‘Edit Report’ tab.
  3. Save the Web Intelligence document.

If you liked this post, buy me a beer. (Suggested: $3 a beer or $7.5 for a pitcher)

How to create templates in WebIntelligence?

Posted By: admin on in business objects - Comments: No Comments »

Currently in XI R2 there is no option of using templates in Web intelligence.

Following workaround can be utilized for report templates.

  1. Create a web intelligence report with the required format that points to a universe(dummy universe) to use it as a template.
  2. While creating a new web intelligence report, use the above report and (Select query->Properties tab->Universe) re-point the report to the required universe.

If you liked this post, buy me a beer. (Suggested: $3 a beer or $7.5 for a pitcher)

How to optimize Memory collection of WebI Java Panel

Posted By: admin on in business objects - Comments: No Comments »

1. The usage of IE is about 30MB when log in infoview.
2. After edit webi report many times, the usage of IE go up to 200MB. The memory usage is up to the time that you do edit action.
3. The memory can not be released after stop editing webi report and log out of infoview.
4. If user continually open and close Java Panel IE will hang.

It was caused by the poorly Memory Collection mechanism of WebI Java Panel. JVM also impact WebI Memory Collection.
Resolution

1. Upgrade BOE to SP5. SP5 has improve WebI Memory collection.

2. Add “-Xincgc” to Java RunTime Paramenter. It is a very important setting for this issue. It means “enable incremental garbage collection”.

Here is how to add this parameter in Java Console.

–Java 1.4 or 1.5:

Go to “Controle Panel”

Open “Java Plug-in”, then go to “Advanced” tag

put “-Xincgc” into “Java RunTime Paramenter”

–Java 1.6

Go to “Controle Panel”

Open “Java”, then click “Java” tag on the pop window

Click “View” button in “Java Applet RunTime Setting” section

put “-Xincgc” into “Java RunTime Paramenter”

Note: Must apply both above two steps to get better performance.

If you liked this post, buy me a beer. (Suggested: $3 a beer or $7.5 for a pitcher)

How to search any text data In Web Intelligence report.

Posted By: admin on in business objects - Comments: No Comments »

  1. Use Draft mode instead of view/page mode.
  2. Press Control+F > Type Text and search

If you liked this post, buy me a beer. (Suggested: $3 a beer or $7.5 for a pitcher)

To add a summary column with totals for each dimension in a crosstab in a WebIntelligence.

Posted By: admin on in business objects - Comments: No Comments »

1. Create a Crosstab using Dimension and Measure.

2. Add a break on Dimension by clicking on the cell -> Insert -> Break

3. The crosstab will be broken down by that dimension

4. Click on measure in the body of the crosstab and click the SUM # icon

If you liked this post, buy me a beer. (Suggested: $3 a beer or $7.5 for a pitcher)

BusinessObjects Guides

Posted By: admin on May 16, 2009 in business objects - Comments: No Comments »

Looking for Service Packs or Hot Fix ?

Posted By: admin on in Infoview - Comments: No Comments »

Here is the site if you are looking fora Service Packs or Hot Fix for Business Objects.
SAP Software Download

If you liked this post, buy me a beer. (Suggested: $3 a beer or $7.5 for a pitcher)

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 4 other subscribers

Contact

Email: KapilMalik@yahoo.com Phone: +1 778.865.2745

Categories

RSS WebI Articles

  • Web Intelligence Extension Points June 24, 2011
    Kevin McManus and his team from Mcmanus Software recently had the opportunity to start building with Web Intelligence Extension Points and came away impressed. Read more to find out what they found had improved greatly since the first release. […]
  • Query Pane Riddles June 24, 2011
    Sometimes you may think that what you need in your WebI Report will be so complex that there won't be a way to achieve it at report level so you rush to find a way modifying the Universe. However sometimes you just need to look at the Query Pane in the report. […]
  • Embedding an Xcelsius visualization in a Web Intelligence Report June 24, 2011
    This blog post shows you how to embed an Xcelsius widget into a Web Intelligence report and also add interactivity using input controls. […]
  • Web Intelligence Year in Review: A Sort of Homecoming April 18, 2011
    In the XI 3.0 release last summer, we announced Web Intelligence Rich Client, which enables BI content to be taken offline. For Web Intelligence customers, this provides them an unparalleled capability: Identical workflows whether using the dHTML, Java or Rich Client deployment options, whether working while connected to the BOE platform or working disconnec […]
  • Web Intelligence XI - Demos of Key Features April 18, 2011
    These shockwave (.swf) files demonstrate the key features of Web Intelligence XI, including how to automatically accessing the metadata of a report, track data changes, load personal data, create a report, and filter data. View the complete list of available demos. […]
  • Introducing the Xcelsius Web Intelligence Integration Suite April 18, 2011
    The Xcelsius Web Intelligence Integration Suite from Antivia enables organizations to power their Xcelsius Dashboards through seamless integration with the wealth of information contained in their library of Web Intelligence reports. […]
  • Web Intelligence XI Release 3.0 with SAP NetWeaver BI April 18, 2011
    The document outlines some basic steps on how you can use BusinessObjects Web Intelligence XI on top of SAP NetWeaver BI. […]

RSS BO Products in Testing

  • SAP BusinessObjects Experience
    Measuring performance and analyzing the competition is a key to success in business and in the world of sports. The SAP BusinessObjects Experience mobile app for iPad provides instant insight into the winning strategies of your favorite athletes and professional sports teams. Combining the extreme speed of in-memory data exploration with engaging, interactiv […]
  • Exploration Views prototype
    The Exploration Views prototype helps business users create their own view of the business without the help of IT experts and the need for training. Leveraging in-memory technology, it delivers a simplified experience for creating dynamic views of information that can be quickly organized for any business need. […]
  • SAP BusinessObjects Explorer Augmented
    Mobile phones are becoming "universal pointing devices": by leveraging the phone's GPS location and compass, applications know where you are, and what you're looking at. SAP BusinessObjects Augmented Explorer prototypes lets business people browse geo-localized business information. Each Points of Interest (POIs) has an assigned location […]
Copyright - All Rights Reserved