Skip to Content
0
Former Member
Apr 23, 2007 at 04:11 PM

Condition not Working in B.Ex.

53 Views

Hi ,

In the B.Ex Analyzer environment , I am using a "Threshhold value" in the Variable selection Screen .What I aim at doing is to Restrict the total Result set of a Query based on the Threshhold value of a given formula .

Let me give a Data Example :

Suppose there are 2 cubes

cube "A" has the fields with Data

-


-


Name Pay-in-DAY 1

-


-


A 20

B 30

cube "B" has the fields with Data

-


-


Name Pay-in-DAY 2

-


-


A 5

B 10

These come to a Multiprovider where i have the following data set arranged

Name Pay-in-DAY 1 Pay-in-Day-2 Difference-in-pay ((Pay-in-DAY 1) -

(Pay-in-DAY 2))

A 20 5 15

B 30 10 20

Now suppose if the threshold value is 17 I should see all data with (Difference-in-pay > 17)

The Difference-in-pay is a Formula calculated in the B.Ex Query but i am unable to handle this situation with a condition as the condition is the first thing calculated when the query fires .

If i make Difference-in-pay a Calculated key figure , still the condition is unable to handle it .Condition handles only figures which are in the Cube and not at the query level.

As it is evident i cannot put the difference in the cube level due to restrictions of data .And if the design is changed it will require much hassel .

Please help .

Regards ,

Devraj