Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Many thanks,

Vince

Tags:
replied

Hi Harish,

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.

Kind regards,

Vince

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question