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