Unable to query on a multiprovider that has Non Cumulative KFs
I have a multiprovider that has Non cumulative Key Figure such as Last valuated total stock and another key figure total Sales. I need to run a query for this on a multiprovider that has 5 Infocubes. There are 2 chars Dept and distrbn channel.
When I execute the query on the multiprovider I am getting zeroes in the key figure columns. But when I execute the query on the info cube I am getting data.
Can any one please advise what to do so that I can get data on the multiprovider also?