on 11-19-2013 4:35 AM
Hi Experts ,
I have a requirement to disply the Documents where a particular Order Quantity KF value is greater than Zero . So I created a Formula on the KF , with Exceptional Aggregation on the Order Quantity , of type Summation , Reference Char Document . Then I used this Formula in Conditions , set to Greater than Zero .
Now when the Order Quantity is less than or equal to Zero , I want that particular Document to not show up in the Report . When I remove the Document out of the Drilldown , all the Documents Order Quantity under a Company Code get summed upto greater than zero and hence report geting messed up .
Company Code | Document | Order Qty | Document Count | Order Value |
1200 | 100 | 0 | 0 | 100 |
1200 | 200 | 4 | 1 | 200 |
In the above all works good , till we have Document in drilldown , 1st record is not shown in report . But when Drilldown to Company Code , value shows up as 300 . Please let me know if there is a solution , it is pretty urgent .
Thanks and Regards
Vigneshram Selvaraj
Hi,
I think this is a normal behavior as at company code level you only have one record so it tend to aggregate the data.That is how OLAP server is meant to work.
At company code level what order value and quantity you are trying to display please let us know.
Regards,
AL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All ,
Thanks a lot for looking into this . Each and everyone's answer , has let me know about the Limitation of Conditions .
@AL
Glad to say that your solution works . But with slight modifications . When we remove Document Number from Drill Down , it was causing issue , hence had to do Exceptional Aggregation of type Summation with Reference to Sales Document and Item on each KF .
@Ganesh n Suman ,
Users are not accepting for Multiple Conditions . Also Sale order is not allowed to be a part of Drill Down , it is optional not mandatory .
Thanks and Regards
Vigneshram Selvaraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I think your document should be present in report then only your condition work.Because written condition in such way that Qty = 0.If your report does not have document then qty will 4 that will not fullfill condition correct?
Regards,
Ganesh Bothe
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I hope you made your condition with "Char Assignment as Document". In that case, your condition will only be applicable when you use Document either in drill down or in Rows pane. So this is standard behavior.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.