Help with the WHERE Statement!

[Hodged]

Hi there,

I'm trying to create the following where statement:

= <Sales Target> Where (<Excel Rep code> = <Rep Code>)

<sales Target> is a column imported excel from a spreadsheet

<excel rep code> is a column imported from an excel spreadsheet

<rep code> is a object from a universe (which is created
from a user prompt)

It all works fine if you do this:

= <Sales Target> Where (<Excel Rep code> = "PF")

(Where PF is a value in the excel spreadsheet)

But I want the result of the query to be based upon the rep code the user has selected.

How do I do this?!

Many thanks for any help.

And I'm using business objects full client (version 6.5)

 

[blom0344]

BO Where operator takes only 'fixed' conditions. What may work is:

=If(<Excel Rep code> = <Rep Code>) Then <Sales Target> Else 0

However you need to synchronize data from the 2 dataproviders over a common dimension for this to work..

Ties Blom

 

[Hodged]

Oh ok, thanks. Guess that makes sense then.

I don't know if I dare ask..but how would I synchronize the data from the dataproviders?

Thanks for your help!

 

[skrandel]

You need to do some reading.

You do this from the data viewer. This is where you link data providers. Basically, you tell the tool what columns are from DP1 match columns from DP2.

Steve Krandel
Symantec