How to use Exception Aggregation in Key figure to fix the Number of Days
Hi BW Experts,
Currently I need to use Exception Aggregation for 3 Key figures as following:-
1. Number Of Days in Month
2. Number Of Days in Years
I have tried different combinations of Exception Aggregation to so that the Number of Days doesn't add up but its still added up.
Have anyone done this before?
Please share your thoughts.
Vincent Ong replied
Thanks for the suggestion, but I've manage to get it by creating a Characteristic as a Unique Identifier that Concatenate Company Code, Cal Year/Month, etc.
Then Use that Characteristic as Reference Characteristic in Exception Aggregation.
It works now, But the only thing is that, it causes longer data loading.