Business Objects + Excel Spreadsheet as a Filter

c.ge.com>

At 04:50 PM 3/2/2000 -0500, Nilesh wrote:

Hi Guys,
Is it possible to have a Business Objects query / report with an Excel spreadsheet such that the spreadsheet essentially does an inner join with Business Objects & acts as a filter / selection criteria.
If possible then how do we do it?

Nilesh, if you evaluate BusinessQuery (which is a BusinessObjects add-in to Excel which runs BusinessObjects queries and returns the results into the worksheet), you’ll find that you can use Excel ranges in your in-list conditions. This is what I think you’re asking to do. However, native BusinessObjects does not have this feature.

When we attended the User Conference in October, and spoke to one of the developers, we informally requested that full-client BusinessObjects be enhanced to allow users to designate a worksheet and range as the source of an “in list”. In BusinessObjects 3.1, the in-list box had each value on a separate line, and our users could “copy” and “paste” a range from an Excel worksheet into the in list. In BusinessObjects 4.1, the in-list became comma-delimited, so the copy and paste no longer works this way, so many of our users lost a useful feature in the upgrade.

If others ask for this enhancement, perhaps it will go higher in the development queue.

Regards,
Anita Craig
Stanford University


Listserv Archives (BOB member since 2002-06-25)

Anita Craig wrote:

When we attended the User Conference in October, and spoke to one of the
developers, we informally requested that full-client BusinessObjects be
enhanced to allow users to designate a worksheet and range as the source of
an “in list”. In BusinessObjects 3.1, the in-list box had each value on a
separate line, and our users could “copy” and “paste” a range from an Excel
worksheet into the in list. In BusinessObjects 4.1, the in-list became
comma-delimited, so the copy and paste no longer works this way, so many of
our users lost a useful feature in the upgrade.

If others ask for this enhancement, perhaps it will go higher in the development queue.

We’ve been after something like this, or to be able to use a variable from an existing report in the document as a source of an “In list”.

It would certainly make the product more flexible.

Where do we sign!

Hayden Gill
The University of Queensland
Brisbane, Australia


Listserv Archives (BOB member since 2002-06-25)

I have utilized the List of Values function to insert my own data for a specific object. I believe this will assist you with what you are doing.

In designer, select Tools-List of Values, select the object desired and then select Personal Data. The screen will then guide you on how to utilize your own data for the object.

Hope this helps!
Pam

__________________________________________________ Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com


Listserv Archives (BOB member since 2002-06-25)

I tried your suggestion re using data in an Excel sheet but am coming up with “invalid definition” for the object I attempted to create. 1. Created an Excel sheet with a list of medical record numbers. 2. Created new class \ object … Patient_MRN from Excel \ MedRecNo and used the Excel sheet to define the LOV fro the object. 3. The LOV was viewable in designer at the object properties level. 3. When I selected this item in the definition window of the object the error message was returned.
4. Alternatively, when I tried to create an object an existing table and associate the LOV here BusinessObjects returned an error also. It is as if BusinessObjects is not finding a link with the Excel sheet.
Could you suggest something further?

P Zirpoli pzirp@YAHOO.COM 03/15 8:39 AM >>>
I have utilized the List of Values function to insert my own data for a specific object. I believe this will assist you with what you are doing.

In designer, select Tools-List of Values, select the object desired and then select Personal Data. The screen will then guide you on how to utilize your own data for the object.

Hope this helps!
Pam

__________________________________________________ Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com


Listserv Archives (BOB member since 2002-06-25)