I have created a query upon a multiprovider. There are 2 columns in the query, each receiving data (key figure) from different info cubes. If info object A = 1 then the data is shown in the first column, and if info object A = 2 then the data in shown in the second column. The same key figure is used for both columns.
In the query, there is a free characteristic which is available in both info cubes. The characteristic is however only identified for one of the cubes. The key figure though is identified using both cubes.
My question is what happens when I drill down on this characteristic breaking down on both columns? As I mentioned, it is only identified for 1 of the cubes even though it exists and holds values in both. Will I anyway be able to see the key figures based on the free characteristic for both columns?
Thanks in advance!
Regards F C