I have two infocubes. One of them has sales amount (0AMOUNT) and the other cube has Costs (0AMOUNT).
I intend to get these cubes in a multiprovider and I want both these key figures in it. They have the same technical name, but they mean different things.
Can I do this or does the MP stop me from assigning KFs with the same name in the MP?
in MP under KF section you will find the Identifier button, here you must flag both 0AMOUNT from the two different Cubes.
In query if you want to distinguish beetween the two different amount from the two different cubes you can create two different Restricted KF based on the InfoProvider char, that is by default in a MP.
You can use the same KF from different cubes in a MP via Restricted Key Figure also becasue MP are generally used to match data from Annual InfoCubes (logical partitioning of cubes).