I am having an issue where data from an Infocube (C05) is available on a multiprovider (M01) but then when using this multiprovider and filtering for "Infoprovider = C05", gives an error of "The data query returns empty result set.
Here is the result of the "Output number of hits" options on the LISTCUBE transaction for the cube (C05):
So there are clearly data records in the cube. And here is the result of the "Output number of hits" options on the LISTCUBE transaction for the Multiprovider (M01), when filtered for "Infoprovider = C05":
Exactly the same amount. So it's established that 1) the data exists in the cube, and 2) the data is correctly mapped to the multiprovider from the cube. However, when creating a datasource in a model in SAC using this multiprovider and filtering for "Infoprovider = C05", I get an empty result set error:
It should be noted that another cube (C03), of which C05 is an exact copy (only difference being the data stored in each cube, but everything else is the same - C05 was created via copying C03) is also mapped to M01, and we have a number of Import Jobs built on M01 filtered for "Infoprovider = C03" which work perfectly fine.
Is there some definition at the Multiprovider level that I am not aware of that that is only making data from one infoprovider available, and not the other? What could be the cause of this issue?