Trainer's Talk

At Data Management Group, our trainers are certified, enthusiastic and supportive. We want you to be successful in the business intelligence solutions you employ. Data Management Group is pleased to introduce Trainer's Talk. Each month, our knowledgeable trainers will provide you with tips and tricks to help you stay ahead of the competition. We'll highlight new software offerings and what that means for you, tips to help you use reporting software more efficiently, helpful insight into business intelligence topics, and much more! You can also email our trainers with specific questions that may be highlighted in one of our newsletters!

Data Management Group knows how important it is to be well-informed and plugged-in to the latest software and business intelligence issues. Look for Trainer's Talk in upcoming issues of BI Advantage!

Excel File Size Limit in Xcelsius

Is there an Excel file size limit in Xcelsius?
Continue>>

How do You Manually Fill In a Prompt without Respecting the Case Sensitivity Constraint?

A report has been created with a prompt in the query panel.

You enter values in the prompt in either lower case, or a mix of upper and lower case, and you receive the message "No Data to Fetch".

Cause: All values in the database are stored in upper case and the Oracle database is case-sensitive.
Continue>>

Error: Cannot create query on repository… when attempting to refresh a metric or group of metrics

In BusinessObjects Performance Manager XI, when attempting to refresh a metric or group of metrics, the following error message appears:

"Error: Cannot create query on repository for probe : [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid object name ''".
Continue>>

Unable to Select a Corporate Dashboard as the Initial View in InfoView

In BusinessObjects Enterprise XI InfoView, after clicking Select next to Corporate Dashboard on the General tab of the Preferences window, the Select screen appears blank.
Continue>>

Some Performance Manager Analytic Folders or Documents are not Published to the CMS

When installing Performance Manager XI Release 2 on Windows, not all the analytics are published to the CMS. The Infoview folder Public Folders > Performance Manager > TimeSeries and others are missing.
Continue>>

How to Display Max and Min Date Range Values in Web Intelligence XI

How can you display the maximum and minimum values used in a date range prompt on a Web Intelligence report?
Continue>>

Boolean order of precedence in Crystal Reports In Crystal Reports, you can build complex formulas using the Boolean operators AND, OR, and NOT.

In Crystal Reports, you can build complex formulas using the Boolean operators AND, OR, and NOT.

When two or more Boolean operators are present in a formula, the order in which they are processed is known as precedence.

What is the Boolean order of precedence in Crystal Reports?
Continue>>

Creating a variable similar to an IF-THEN-ELSE statement in Web Intelligence

In Web Intelligence, you want to create a variable whose output is similar to an IF-THEN-ELSE statement. For example, if a field has a value of 'Canada', the variable should show 'North America'. If the field shows 'Brazil', the variable should show 'South America'.

How can you create a variable whose output is similar to an IF-THEN-ELSE statement?
Continue>>

Error: "Null value (INF)" when refreshing metric analytics

After an initial install of BusinessObjects Performance Manager XI, if you open any of the metric analytics and click 'refresh', the following error message appears:

"Prompt
Error: null value (INF)"

Why does this error message appear and how do you resolve it?
Continue>>

Images do not appear or are corrupted when saved from Webi to Excel

When you save a Web Intelligence XI report with an image to Excel format, the image is corrupted.
Why does this issue occur?
Continue>>

Desktop Intelligence XI Release 2 compared to BusinessObjects 5.x and 6.x

What are the main differences between a 2-tier and a 3-tier Desktop Intelligence deployment? How do you apply security when migrating reports and users from BusinessObjects 6.5.x to BusinessObjects Enterprise XI?
Continue>>

Migrating report and user security from BusinessObjects 6.5.x to Enterprise XI

BusinessObjects 6.5.x security was applied through Supervisor, which does not exist in the Enterprise XI releases. How do you apply security when migrating reports and users from BusinessObjects 6.5.x to BusinessObjects Enterprise XI?
Continue>>

No 'Print Settings' option when scheduling Reporter document or Crystal report

When scheduling a Web Intelligence document, why does the 'Print Settings' option not exist as it does when scheduling Crystal Reports and Reporter documents?
Continue>>

Error: "(Error: INF)" opening or refreshing Desk Intelligence document

After migrating from BusinessObjects 6.x to BusinessObjects Enterprise XI, opening or refreshing Desk Intelligence document with prompts in InfoView causes the following error message to appear: "(Error: INF)". Why does this error message to appear and how do you resolve it?
Continue>>

How To Share Subreport Data with the Main Report

A report contains a subreport. Data from the subreport is required for calculations in the main report. How can you share subreport data with the main report in version 7 (or higher) of the Crystal Reports Designer?
Continue>>

Using dynamic prompts when connected to a Universe in Crystal Reports XI

When connected to a BusinessObjects Universe, can you create a parameter that uses a dynamic prompt in Crystal Reports XI?
Continue>>

How to configure the Crystal Reports XI startup page to access your intranet

Crystal Reports XI makes HTTP requests to www.businessobjects.com for online resources at the startup page. Such requests can trigger web proxy prompts in some companies. How can you configure the startup page to access your internal network (intranet) to avoid the web proxy prompts?
Continue>>

Error: "Data source name not found and no default driver specified"

When attempting to create a BusinessObjects Web Intelligence document from the imported Universe, the following error message appears:

"Database error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. Contact your administrator or database supplier for more information. (Error: WIS 10901)" Why does this error message appear and how do you resolve it?
Continue>>

Error Message: "An error occurred during the processing of a configuration file..."

When launching InfoView in BusinessObjects Enterprise XI the following error message appears:

"An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately."
Continue>>

How to manually uninstall Crystal Reports XI

After reinstalling Crystal Reports XI you discover application is not functioning properly. You need to manually uninstall Crystal Reports XI.
Continue>>

Looking for the client sample tools in BusinessObjects Enterprise XI?

Where are the client sample tools in BusinessObjects Enterprise XI?
Continue>>

What Versions of Crystal Reports are Compatible with XI?

Can you open a report created with Crystal Reports^® XI in previous versions of Crystal Reports?
Continue>>

Troubleshooting the Installation of the Report Viewer for ActiveX

Attempting to view a report via Crystal Enterprise or Seagate Info but you all seem to get are red Xs for every bitmap within the viewer. The solution may be as simple as unregistering a few DLLs
Continue>>

Crystal Reports Secrets

20 free shortcuts and workarounds for report designers and developers
Learn to power through tricky design and development tasks - and create reports that will amaze your boss and coworkers. Our secret tips and tricks are based on the questions most frequently asked of our experts. Now, these secrets can be yours for free. No strings attached. No obligation.
Continue>>

Limiting Records per Page

Having difficulty formatting information within your crystal reports? Maybe you need to limit your records being display per page.
Continue>>

IsNull Function

The Isnull function is used in a formula such as the following:

If {database.field} = somevalue or
Isnull({database.field}) then
"Yes"
Else
"No"

However, the fields that are null are completing the action after the "Else" statement rather than the "Then" statement.
Continue>>