loading from data targets
I have calculated KFs whose calculation components are found in cube A.
I have another report that is based on cube B.
But it also requires these calculated KFs (dynamic results depending on selection) values as selection is made in this report of cube B.
How can this kind of data be supplied to a report (query) of cube B? Or how can a filter selection in this report be smart enough to know that it needs to call the calculated KF of cube A?