on 05-21-2015 7:40 AM
Hi All,
I got stuck with one issue may be anyone of you can help :
I have a formula key figure and a selection key figure.
Now in the query the selection key figure value comes from another query where it is planned.
The user wants the Formula key figure values getting distributed according to the selection key figure values.
Suppose I have the data in the first query as:
DEV location | formula KF | selection KF |
A | 100 | 80 |
B | 10 | 90 |
C | 30 | 70 |
D | 40 | 20 |
E | 50 | 100 |
and the second query as :
DEV location | selection KF |
A | 80 |
B | 90 |
C | 70 |
D | 20 |
E | 100 |
Now I change the value of Selection KF value of DEV location B to 30 .
And the value in the formula KF should get distributed according to the reference of Selection KF.
Automatically it should happen , we should not have the logic of disaggregation.
Thanks ,
Ayushi
Hi Ayushi,
I am assuming that that formula key figure is getting calculated based on input from selection key figure. In this case value will change as soon as you make any adjustment in selection key figure.
If you are changing value at aggregated level for selection KF, you need to define a disaggregation logic(proportional or copy value) to propagate the value at base level and same can be taken as input to formula key figure which will be further aggregated at request level based on aggregation mode(sum, avg etc).
Thanks,
Rohit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
4 | |
3 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.