BusinessObjects Board

To create Variables that conditions measure variables

I’m very confused… Hope somebody can give me some light…

Basically, I’m just trying to create a variable, such as
Var1 = count() where <Total_Amount> >2000.

I couldn’t create such variable. So instead, I created three different data providers.

Data Provider1
Date (five days)
Account ID (100*5 days)
Total Amount (given per date and per account id)
where
Total Amount >200

Data Provider 2
Date (five days)
AccountID (70*5 days)
Total Amount (given per date and per account id)
where
Total Amount <=200

Data Provider 3
Date (five days)
Account ID (30*5 days)
Total Amount (given per date and per account_id)
where
Total Amount is null.

Variables Created:
DP1.
Total# of Accounts =count(Account ID)
Average Amount =Total Amount/<Total # of Accounts>
DP2
Total# of Accounts =count(Account ID)
Average Amount =Total Amount/<Total # of Accounts>
DP3
Total# of Accounts =count(Account ID)
Average Amount =Total Amount/<Total # of Accounts>

As you have noticed, I’m duplicating a lot of variables and data providers, just because the condition are different.

It’ll be nice if I could just create variables, such as

Count1 = count(Account ID) where Amount >2000.
But, I can’t put a measure objects in the where clausse.

Is there any way of doing this?

I’ll have to create more data providers to count total, ratio, etc.

There must be a way of doing this.

Could someone help me? :frowning:

Thumper


thumper (BOB member since 2003-03-21)

Create a local DIMENSION report variable “Flag Is greater than 2000” defined as:

=<Total_Amount> >2000

Now rewrite Var1 defined as:

Var1 = count(<Account ID>) where (<Flag Is greater than 2000> = 1)

For more details regarding how to use the WHERE clause in BO Reporter look at this FAQ, which needs to be moved by a Mod (Cindy :?: ) :wink:

Also, please avoid your accidental double-posting.


Andreas :de: (BOB member since 2002-06-20)

How’s this? :mrgreen:


Cindy Clayton :us: (BOB member since 2002-06-11)

:o :shock: :slight_smile: :smiley:


Andreas :de: (BOB member since 2002-06-20)