Dear Focal Pointers,

Summit 2010 is fast approaching!! This is the Premier Educational Event in Business Intelligence and Integration!

Information Builders Summit User Conference empowers you to reach your peak professional development by taking advantage of the benefits of data quality management, advanced information access, personalized reporting, and dashboards.

Summit 2010 is the most comprehensive training available on Information Builders WebFOCUS, FOCUS, and iWay Software solutions. Devoted to our customers, developers, and executives worldwide, Summit provides the most innovative coaching, the best networking, and the enhanced skills for handling today's critical business issues.

Summit 2010 is the only conference that offers:
• Over 35 customer presentations – to give you great ideas on how to put your information to work
• Top industry analyst presentations – for thought leadership on where BI and integration are headed
• One-on-one consultations with our solutions experts – for instant analysis of your projects
• More than 44 Hands-On Labs – so you can put our latest features to the test
• 130 education sessions
• A special viewing of our innovative new software release WebFOCUS 8, which provides cutting-edge data integrity, performance management, BI, and advanced analytics to help everyone in your business make smarter decisions

Putting your information to work. That’s what Information Builders Summit is all about. Don’t miss out!

New Promotion!!When you pay for a Summit registration, you will get five subscriptions to our online eLearning Reference Library ... a $1,250 value!

The eLearning Reference Library is a vital resource of tips, techniques, and training that includes over 20 Product Training Modules, recorded live meetings, and reference guides. Up to two attendees per company (with paid registrations) are eligible for this offer. That’s a $2,500 bonus of 10 subscriptions that virtually pays for the cost of the trip. And yes, you can still take advantage of the Early Bird Special.

Agenda | ROI Justification Kit | FAQ's | Video: Gerald Cohen talks about Summit! | Early Bird Special and Hotel Rates Expires May 22nd

****************************************************
Tuesday, June 8th
Off to see the wizards: A FOCWIZARDS/Focal Pointers Meeting – Focal Point Session at Summit!

We are excited to announce that we will have a dedicated session for Focal Point at Summit 2010. This session will feature two parts. In part one, we will answer questions from support calls that start with: "How can I...?" or "It's a shame that FOCUS/WebFOCUS doesn't...?" We will show how FOCUS can do whatever you need and often easier than you thought.

Part two is your chance to stump the experts! Visit Focal Point today and send your “How To” question or challenge you faced in building your WebFOCUS/iWay application, via email to kerry_zhan@ibi.com by May 10th. All questions will then be posted by May 12th and you will have a chance to send in your answers by May 30th. The most challenging “how to” questions and “innovative” solutions will win a token from the FocWizard himself, Gerry Cohen, CEO of Information Builders!


We look forward to seeing you at Summit 2010!!

Sincerely,

Kathleen Butler
Customer Care and Communications Manager
Information Builders
Kathleen_Butler@ibi.com

This message has been edited. Last edited by: Kerry,

Hi all Focal Pointers,

Thanks for everyone's attention on this Off to see the wizards session for all Focal Pointers at Summit. Below are the questions we have collected. Please feel free to submit your solutions to any of the questions, either post it here, or send to me at kerry_zhan@ibi.com.

***********************************************************************************

#1. We use Webfocus mostly in creating financial reports. We had to have your support group create an SQL for use to write our main Financial reports. We are now at the step where we would like to create some of the nonconforming financial statements and we would like to set up our own hierarchies using the attached GUI screen (or something else). I think it should be pretty simple, but we cannot figure it out.

I would like the hierarchy to end up as :

CATEGORY
GAC_MX_VALUE
GCS_ACCOUNT_DESC

***********************************************************************************

#2. How do I password protect an Excel report and send it using secure email?

***********************************************************************************

#3. I was wondering if anyone had any quick-and-dirty solutions for taking several numeric fields and reworking them such that they were one field spread out over several rows. The following code shows my current solution, but I’m sure you can see where it can become cumbersome if I have a dozen or more fields that I need to unify. Thanks in advance!
DEFINE FILE CAR
DEALDESC/A20 = 'Dealer Cost';
RETADESC/A20 = 'Retail Cost';
END
MATCH FILE CAR
BY COUNTRY
BY MODEL
BY CAR
BY DEALDESC AS DESCRIPTION
BY DEALER_COST AS THECOST
RUN
FILE CAR
BY COUNTRY
BY MODEL
BY CAR
BY RETADESC AS DESCRIPTION
BY RETAIL_COST AS THECOST
AFTER MATCH HOLD AS SUMMARY_DATA OLD-OR-NEW
END
TABLE FILE SUMMARY_DATA
PRINT
COUNTRY
MODEL
CAR
DESCRIPTION
THECOST
END

***********************************************************************************

#4. How to concatenate two HOLD (similar to using the MORE function) but without MORE. Recently, we found out that MORE is not supported in ReportCaster so my reports that use MORE will not to be re-written.

************************************************************************************

#5. How to combine 5 or more data sources most efficiently (with the least amount of resources used).

*************************************************************************************

#6. Lisa Moroz, lmoroz@oxfordproperties.com; Will attend Summit
We have a text comment field in a SQL table. When presented in a report, all “carriage return” characters are ignored. How do I make Web Focus to show the test as it’s been entered by a user?
Please find the fex file attached.

*************************************************************************************

C__DOCUME~1_KZ11095_LOCALS~1_TEMPOR~1_CONTEN~1.WOR_comment[1].fex (4 Kb, 3 downloads) fex for Q.6