I am excited with my interesting discovery.
When
1. the key figure A in the structure S is a calculated key figure,
2. A is calculated from two or more restricted key figure (C, & D),
3. Characteristic B is used to restricted C & D.
4. Characteristic B is also used to restricted in a selection of structure S
The number gets doubled in the [...]

BW Reporting, SAP BW | No Comments »

Yesterday, one BW load failed because the date user used in R3 is 01/01/9999, and this date let’s call it valid_from, is the source field to convert to fisical date/Calendar date and so on.  Below is a list of errors I got.
Time conversion from 0CALDAY to 0FISCPER (fiscal year ) failed with value 01019999
This happens when the BW [...]

BW Admin, BW Modeling, SAP BW | No Comments »