SAP Business Objects

SAP Crystal Server 2016 for free for 60 days

2018-08-18T08:12:00.001-07:00

Try SAP Crystal Server 2016 for free for 60 days

Crystal Server 2016 Trial Registration

SAP Crystal Reports 2016 FREE 30-Day Trial

2018-08-18T08:05:00.000-07:00

Empower your small to mid-sized business to turn any data into interactive, actionable information - easily and quickly. Download your 30-day trial today.

Crystal Reports Trial Registration

Tutorials – SAP Crystal Reports 2011 / 2013

2016-11-19T02:11:00.001-08:00

Key Concepts

Concept: What’s new in SAP Crystal Reports 2011 (2:16) video
Concept: Navigate the interface (6:46) video
Concept: Create a report (2:48) video
Concept: Share report objects with other designers (2:09) video
Concept: Describe how the semantic layer works (2:08) video
Concept: Compare Crystal Reports 2011 and Crystal Reports for enterprise interactive

Getting Started

Connect to an ODBC data source (2:13) video
Change the layout of the interface (1:06) video
View the data for a field (1:08) video
Add fields to a report (1:20) video
Preview a report (0:57) video
Refresh the data in a report (0:50) video
Save a report (1:20) video
Save a snapshot of a report (1:21) video
Save a report to the Business Intelligence platform (1:47) video
Export a report (2:24) video
Share report objects using the Repository Explorer (1:46) video

Connecting to Data Sources

Connect to an SAP BW data source (3:29) video
Connect to a universe (2:27) video
Connect to an XML data source (2:51) video
Connect to a web service (3:43) video
Link data source tables (2:03) video
Change the data source location (2:11) video
Connect to an SAP ERP data source (2:58) video
Connect to an Excel spreadsheet or a text file (1:41) video
Connect to an OLAP data source and create an OLAP grid report (4:26) video
Create a connection to SAP HANA using ODBC drivers (2:43) video

Working with Charts

Create a chart for summary data (1:37) video
Create a chart for detail data (2:19) video
Change the formatting of a chart (2:31) video

Working with Tables and Crosstabs

Create a crosstab (2:25) video
Create a crosstab using the Crosstab Wizard (2:24) video
Add a calculation to a crosstab (2:25) video
Change the formatting of a crosstab (1:53) video
Conditionally format cells in a crosstab (2:16) video

Selecting, Sorting, Grouping, and Summarizing Data

Select the data that appears in a report (1:12) video
Edit the formula for record selection (1:46) video
Sort the records in a report (0:54) video
Sort records using a sort control (2:34) video
Group records based on data (1:11) video
Group records based on a custom definition (2:28) video
Change the grouping order (1:13) video
Select groups based on a summary (1:47) video
Calculate totals and subtotals for data (02:00) video
Create a running total (2:03) video
Show the top or bottom N records in a report (1:22) video
Create a summary report (1:31) video

Setting up Interactive Elements

Prompt for a value to select records (2:20) video
Display the prompt value used to select records (1:36) video
Prompt for multiple values to select records (2:56) video
Prompt for a DateTime range to select records (3:14) video
Create a cascading prompt to select records (4:30) video
Group records based on a prompt value (4:05) video
Create an alert (2:11) video
Add a SWF file to a report (1:06) video
Create a hyperlink to open a document in the BI platform (4:48) video

Working with Formulas

Create a formula (2:54) video
Create a Boolean formula (2:04) video
Create a conditional formula (2:36) video
Create a formula to calculate numbers (2:09) video
Create a formula to calculate a time interval (2:40) video
Create a formula to change text (2:36) video
Use variables in a formula (3:19) video

Working with Subreports

Add an existing report as a subreport (1:41) video
Change the formatting of a subreport (1:46) video

Applying Formatting

Resize, move, and align fields in a report (1:30) video
Position objects using guidelines (1:45) video
Add text to a report (1:21) video
Add a graphic to a report (0:49) video
Add a dynamic graphic to a report (2:41) video
Add a hyperlink to a report (1:31) video
Add a watermark to areport (2:18) video
Add document information fields (1:41) video
Add a line or box to a report (1:18) video
Format the fields in a report (2:18) video
Copy the formatting of an object (1:40) video
Conditionally format data using the Highlighting Expert (1:30) video
Conditionally format data using the Format Editor (1:44) video
Customize an existing formatting style (2:03) video
Change the formatting for a report section (0:59) video
Conditionally format a report section (2:09) video
Create a subsection in a report (1:40) video
Embed database fields into a text object (2:12) video
Apply a report template (2:01) video
Create a report template without a data source (5:02) video

Distributing Output

Create a project in the Workbench (1:39) video
Publish an object package to the BI platform (1:54) video

Tutorials – SAP BusinessObjects Web Intelligence 4.x

2016-11-19T01:35:00.000-08:00

Key Concepts

What’s new in Web Intelligence 4.1 SP6 (5:49) video
What’s new in Web Intelligence 4.1 SP5 (1:40) video
What’s new in Web Intelligence 4.1 SP4 (1:10) video
What’s new in Web Intelligence 4.1 SP3 (1:37) video
What’s new in Web Intelligence 4.1 SP2 (3:02) video
What’s new in Web Intelligence 4.1 (5:27) video
What’s new in Web Intelligence 4.0 SP5 (2:04) video
What’s new in Web Intelligence 4.0 Feature Pack 3 (4:20) video
What’s new in Web Intelligence 4.0 (6:25) video
Navigate the interface (6:24) video
Concept: Describe how the semantic layer works (1:35) video

Getting Started

NEW for 4.1 SP5 Scenario: Creating reports with tables, charts and images* (9:35) video
Create a query (1:24) video
Run and save a query (1:30) video
Edit a query (0:59) video
View or change the properties for a query (1:06) video
View the SQL or MDX script for a query (1:00) video
Set up preferences for the Web Intelligence Rich Client interface (1:01) video
View the properties of a document (1:20) video
Drag and drop objects to create a report (1:33) video
Duplicate a report object (1:19) video
Add a report to a document (0:40) video
Add a row or column in a table (0:56) video
View the metadata for objects (0:32) video
Publish a document to the repository (1:22) video
Save a document as other formats (1:51) video
Copy and paste content in Web Intelligence and other documents (2:01) video

Connecting to Data Sources

Add another query to a document (1:22) video
Change the data source on which a query is based (1:27) video
Create a query based on an Excel file (0:58) video
Combine multiple queries (2:20) video
Create a query within a query (1:48) video
Merge dimensions from different universes (1:47) video
Connect to a web service (2:15) video
Create a query based on an OLAP universe (1:45) video
Connect to a BEx query with hierarchical data (1:32) video
Connect to an Analysis view (1:11) video
4.0 FP3 Work with scaled values in BEx queries (1:59) video
4.0 FP3 Perform level or prompt member selection on hierarchical data (2:30) video
4.1 Work with hierarchy and hierarchy node variables in BEx queries (3:11) video
4.1 Set up query stripping for an SAP HANA data source (2:40) video

Working with Tables and Crosstabs

Create a table (2:07) video
Change the layout of a table (1:24) video
Delete columns and rows from a table (1:05) video

Working with Charts

Create a chart (1:51) video
Turn a table into a chart (1:12) video
Create a chart for hierarchical data (1:22) video
4.0 FP3 Create charts with hierarchical dimensions (1:31) video
4.1 Set default chart series colors (1:34) video
4.1 SP2 Format a data series in a chart (1:03) video

Setting up Elements

Add a hyperlink to a document (1:03) video
Create a link between documents (DHTML client) (1:33) video
Drill down into a table (2:48) video
Drill down into a chart (2:11) video
Fold and unfold sections in a document (1:09) video
Create an input control for a document (1:46) video
4.0 FP3 Create an input control on a hierarchy (1:58) video

Selecting, Sorting, Grouping, and Summarizing Data

Select a subset of data based on a predefined filter (1:00) video
Select a subset of data based on a custom filter (1:16) video
Remove a filter from a document (0:45) video
Create a prompt to select a subset of data (1:31) video
Select a subset of data based on multiple filters (2:17) video
Define the order in which multiple filters are applied (2:07) video
Create breaks between groups of data (0:55) video
Calculate totals and subtotals for data (1:10) video
Sort the data in a document (2:05) video
Change the order and format of breaks between groups of data (1:53) video
Select a subset of data in a report (0:59) video
Add a ranking to data (1:01) video
Divide a report into sections (1:22) video
Calculate totals and subtotals for sections in a report (1:08) video
Navigate a document using the Report Map pane (0:51) video
Set a filter on a section or a block in a document (1:53) video
Sort the sections in a document (0:56) video
Create a prompt for hierarchical data (1:24) video
Divide a report with hierarchical data into sections (1:01) video
4.0 FP3 Apply simple and complex sorting (1:44) video
4.1 SP2 Group the values of a dimension (1:43) video

Working with Formulas

Create a formula to display a filter selection (1:48) video
Create a formula to calculate a value (1:22) video
Create a variable based on a formula (0:59) video

Applying Formatting

Add text to a document (0:59) video
Change the format of text or numbers in a document (0:54) video
Track changes to data (1:28) video
Conditionally format data based on defined thresholds (1:37) video
Add a background to a document (1:22) video
Add page numbers to a document (0:50) video
Change the formatting for a table (1:50) video
Change the formatting for a cell (2:21) video
Change the formatting for sections (1:59) video
Change the formatting for a chart (5:04) video
4.0 FP3 Modify the default style sheet (2:30) video
4.0 FP3 Format charts (2:11) video
4.1 Freeze header rows or columns (0:56) video
4.1 Create a custom color palette (1:27) video
4.1 Change the locale settings for right-to-left document or interface layout (2:25) video

Creating Documents for SAP BusinessObjects Mobile

Save documents for access in SAP BusinessObjects Mobile (2:09) video
Format sparkline charts to display in SAP BusinessObjects Mobile (2:05) video
Format trend or status icons to display in SAP BusinessObjects Mobile (3:48) video
Format blank cells and images for SAP BusinessObjects Mobile (3:50) video
4.0 SP4 Select charts for display in SAP BusinessObjects Mobile (3:09) video
4.0 SP4 Link report elements using input controls (1:58) video
4.0 SP4 Format microcharts to display in SAP BusinessObjects Mobile (2:23) video
4.0 SP4 Format bullet charts to display in SAP BusinessObjects Mobile (3:05) video
4.0 SP4 Format geomaps to display in SAP BusinessObjects Mobile (3:15) video
4.1 SP3 Format geomap documents to display measure colors or conditional formatting in SAP BusinessObjects Mobile (2:43) video
4.1 SP3 Set a default view for a geomap document in SAP BusinessObjects Mobile (1:41) video

SAP BusinessObjects WIKI

2013-06-19T10:33:00.000-07:00

Administration

Universe Design - Advanced join property

2012-07-19T08:45:00.000-07:00

Advanced join property in universe is present , when you click a join between any two tables and click on Advance button.

You need to have ANSI92, set to “Yes”, to enable this feature.

So, the question is, what exactly this feature do?

First of all let’s look what is the execution order of a SQL statement:

When a query is submitted to the database, it is executed in the following order:

FROM clause

WHERE clause

GROUP BY clause

HAVING clause

SELECT clause

ORDER BY clause

So if I use my conditions in FROM Clause instead of WHERE Clause, it will be calculated first and can help in performance improvement.

Take for example in my universe:

If I select c_name object from customer table and sale_value from sales table and use c_name as a filter, the query will be:

It can be seen that the filter condition is coming in WHERE clause.

The Advanced Join Property allows to the conditions to be used in “FROM” clause.

Again as I said previously, you need to have ANSI92=”Yes” in your universe parameters for this to work.

Now we will set the advanced join conditions.

Click on the join between the two tables:

The drop down option says it what kind of behavior you want from objects selected in query filter.

Lets say I selected “Selected objects in FROM” in drop down and checked on C Name dimension object.

Now I will create the query again:

See how the filter which was coming in WHERE clause is coming in FROM clause.

Although both types (i.e. filters in FROM clause and filters in where clause) generate the same results but there are scenarios specially when you use Left Outer joins in your query, that can lead to difference in results, which needs to be taken into consideration while using this option in your universe.

Universe Documentor

2011-06-25T09:45:00.000-07:00

Dwayne's Universe Documentor

http://www.ziddu.com/download/15483843/BOXIUniverseDocumentorv4.xls.html

SAP Support Portal links

2010-08-28T12:11:00.000-07:00

SAP BusinessObjects Support Home Page:

https://service.sap.com/bosap-support

New Message Creation:

http://service.sap.com/message

SAP Help Portal:

http://help.sap.com

SAP BusinessObjects Community:

http://sdn.sap.com/irj/boc

SAP BusinessObjects Notes:

https://sdn.sap.com/irj/boc/notes

SAP BusinessObjects Articles:

https://sdn.sap.com/irj/boc/articles

SAP BusinessObjects Forums:

https://sdn.sap.com/irj/scn/forums

SAP BusinessObjects Patches:

https://service.sap.com/patches

SAP BusinessObjects Full Builds:

https://service.sap.com/installations

License Keys:

http://service.sap.com/licensekeys

SAP BusinessObjects Product LifeCycle (EOL Dates)

https://service.sap.com/bosap-lifecycle

SAP Support Portal user creation

2010-08-28T11:37:00.001-07:00

SAP Support Portal SSO

2010-08-28T11:34:00.000-07:00

Configure Single Sign On (SSO) on the SAP Support Portal so that we don't have to enter the username password again and again :)

How to request license keys from the SAP Support Portal

2010-08-28T11:25:00.000-07:00

Differences between BusinessObjects EDGE and Enterprise

2010-08-28T11:09:00.000-07:00

- BusinessObjects Edge 3.0/3.1 is a single server deployment while BusinessObjects Enterprise can be deployed on multiple servers.

- Profiles and Publications (also referred to as Publishing) are disabled in BusinessObjects Edge 3.0. This is enabled in BusinessObjects Edge 3.1, with a limitation of sending to 100 recipients at a time. The option to send to additional recipients can be purchased as add-on functionality.

- Federation is disabled in BusinessObjects Edge 3.0/3.1. Note this feature remains visible in the CMC for the BusinessObjects Edge 3.0 release, however it is not operational.

- BI Widget is supported in BusinessObjects Edge Edge 3.0/3.1 Polestar is supported in BusinessObjects Edge Edge 3.1.

- BusinessObjects Edge 3.0/3.1 does not have native .NET IIS support.

- Tomcat is the only web application service supported in BusinessObjects Edge 3.0. BusinessObjects Edge 3.1 has an internal hosted application server which services all its web-based applications. This is no need to purchase a separate application server. Should you wish to deploy on a separate application server, Tomcat is supported.

Kill BOXI 3.1 user login sessions

2010-06-12T11:08:00.001-07:00

http://www.ziddu.com/download/10263054/killsession.zip.html
Download, Unzip and put the folder KillSession into the webapps folder under tomcat.

Before you can use it, copy the all library files from CmcAppActions (C:\Program Files\Business Objects\Tomcat55\webapps\CmcAppActions\WEB-INF\lib) to the C:\Program Files\Business Objects\Tomcat55\webapps\KillSession\WEB-INF\lib

You might need to restart Tomcat.

http://yourserver:8080/KillSession

Schedule Manager in BOXI 3.1

2010-02-13T00:30:00.000-08:00

In XI3.x, Schedule Manager is a separate download as a zip/war file. It can be downloaded from
https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/80af7965-8bdf-2b10-fa94-bb21833f3db8

Once downloaded, here are the steps to deploy it :

Copy the zip file to c:\Program Files\Business Objects\deployment\workdir\tomcat55\application and rename it to ScheduleManager.war
Create a XML file ScheduleManager.xml at \Tomcat55\conf\Catalina\localhost with the line from the example below
Now open a browser and access Schedule Manager from http://servername:[port]/ScheduleManager

Download BusinessObjects Enterprise XI 3.1 SP2

2009-07-27T12:04:00.000-07:00

BusinessObjects Enterprise XI 3.1 SP2 is now available for download

http://service.sap.com/bosap-support > downloads > Support Packages> Support Packages and Patches - Entry by Application Group> SAP BusinessObjects packages and products> SBOP ENTERPRISE> BOBJ ENTERPRISE XI 3.1 > BOBJ ENTERPRISE XI 3.1> Windows Server on IA32 32bit

SAP BusinessObjects (Documentation,Downloads, Search SAP Notes,Forums)

2009-07-23T12:29:00.000-07:00

Url to access SAP BusinessObjects (Documentation,Downloads, Search SAP Notes,Forums)

https://websmp101.sap-ag.de/bosap-support

Free trials of SAP BusinessObjects solutions

2009-05-07T15:13:00.000-07:00

Free trials of SAP BusinessObjects solutions

http://www.sap.com/solutions/sapbusinessobjects/sme/freetrials/index.epx

Maintance Roadmap of XI R2, XI 3.0 & XI 3.1

2009-01-15T13:38:00.000-08:00

Maintance Roadmap of XI R2, XI 3.0 & XI 3.1

Support Life Cycle information

2008-12-05T14:53:00.000-08:00

You can find support life cycle information at SAP support portal.
Go to https://websmp106.sap-ag.de/bosap-lifecycle then click "View End of Life Dates by Product" link, which is in the right side of the page under "Related Topics". Check BusinessObjects Enterprise in the list.

Error 1718. File was rejected by digital signature policy

2008-11-11T11:40:00.000-08:00

When trying to install BOXI 3.1 or other BO version which have large Microsoft Windows Installer (.msi) package or a large Microsoft Windows Installer patch (.msp) package we get the error "Error 1718. File was rejected by digital signature policy"

CAUSE
This problem occurs if the Windows Installer process has insufficient contiguous virtual memory to verify that the .msi package or the .msp package is correctly signed.
RESOLUTION
Apply the fix for Windows Server 2003

Download the Update for Windows Server 2003 (KB925336) .

Reference
http://support.microsoft.com/kb/925336

Unable to connect to the repository. (DX0035)

2008-09-19T16:58:00.000-07:00

In BusinessObjects Enterprise XI Release 2, when logging on to Desktop Intelligence, the following error message appears:

“Unable to connect to Repository. (DX0035)”.

This often affects only one or few enterprise accounts.

To resolve the error message, delete and create a new enterprise account for the specific user.

Please note that any recurring scheduled objects would then become owned by the administrator account. Reports in user folders, Personal Categories, and Inboxes are removed.

sessions and licenses are not released after the session timeout is reached

2008-08-27T17:11:00.000-07:00

For Infoview, in addition to setting the timeout parameter, users need to uncomment the following line in web.xml to make a listener explicitly log off the session objects when they are invalidated:

'

'com.businessobjects.sdk.ceutils.SessionCleanupListener

'

For the CMC, users need to set the timeout parameter in the web.xml file

Changing the default session timeout value for .NET CMC or InfoView

2008-08-27T16:57:00.000-07:00

To change the default session timeout value for licenses for the CMC and InfoView, perform the following steps:

1. Search for the web.config file.

• To modify the default session timeout value in the CMC, search for web.config in the C:\Program Files\Business Objects\BusinessObjects Enterprise 11\Web Content folder.

• To modify the default session timeout value in InfoView, search for web.config in the C:\Program Files\Business Objects\BusinessObjects Enterprise 11\Web Content\Enterprise11\InfoView folder.

2. Open web.config in a text editor like Notepad and search for the following 'sessionState' section.

mode="InProc"

stateConnectionString="tcpip=127.0.0.1:42424"

sqlConnectionString="data source=127.0.0.1;user id=sa;password="

cookieless="false"

timeout="20"

/>

3. Change the 'timeout' attribute to set a new default session timeout value (in minutes).

Upon completing these steps, the default session timeout value in the CMC and InfoView is updated.

How to install the ActiveX viewer manually

2008-08-27T16:51:00.000-07:00

How to install the ActiveX viewer manually in BusinessObjects Enterprise XI Release 2

Here are the steps:

1. Navigate to the ActivexViewer.cab located in the \Business Objects\common\3.5\crystalreportviewers115\ActiveXControls folder.

2. Extract the following .dll files:

CRViewer.dll
sviewhlp.dll
swebrs.dll
reportparameterdialog.dll

3.Copy the files to a folder on the client computer (for example, C:\Temp).

4. Register the .dll files from the command prompt using regsvr32 as follows:

regsvr32 C:\Temp\CRViewer.dll
regsvr32 C:\Temp\sviewhlp.dll
regsvr32 C:\Temp\swebrs.dll
regsvr32 C:\Temp\reportparameterdialog.dll

Desktop Intelligence Permission Problem

2008-08-21T16:38:00.001-07:00

Platform:
Desktop Intelligence
BusinessObjects XI, XI Release 2

A
common problem is when you delete a report from the repository and then
realises that it was a mistake removing it. Even though you have a
local copy of the report you can't open it. This is because BOE is
validating the rights against the repository and when the report does
not exist there it can't be opened.

If you try to open that report in Desktop Intelligence you will get an error stating: You are not authorized to use this document. (FRM00008).

There
are a number of possible workarounds for this problem, one being that
you create a dummy report in the repository with the same name as the
report you just deleted. Then you find out the path and file name
through Central Management Console. Browse to the report folder in
Input File Repositry Server and delete the file (remember the file
name). Add the original report to the same place and change it's name
to the same as the deleted file. Now you are able to import it into
Desktop Intelligence.

This solution doesn't work in all
situations and it's not a supported method. Manually deleting files
from FRS is NOT a good idea in most cases. With this particual problem
there exist a different solution that will solve this.

Open Desktop Intelligence - check the Use in Offline Mode checkbox when logging in.
Open the report.
Save your report - check the Save for all users

checkbox.
Close Desktop Intelligence.
Open Desktop Intelligence - login to your repository, not in offline mode.
It should now be possible to open the report and publish it to the repository.

And, yes, a backup is also one way out of this...