Bex does not display all KFs from a multi-provider
I have this multi-provider which has 3 infocubes and 2 master data infoobjects assigned to it.
For couple of KFs in master data infoobjects, I have created calculated KF using replacement path. This works perfect with all other reports except this report which has columns from different cubes of the multi-provider. Below is clear explanation
Multi Provider has 3 infocubes cube1, cube2, cube3.
Report has KFs from cube1 and cube2, so the calculated KF using replacement path will display a value only if KF from cube1 is not empty.
Please help me resolve this issue.