Hello,
I still continue to solve the mystery as to how i am getting inaccurate data when i drilldown. From the investigations i have been doing, these are the inferences. Correct me if i am not right!
As the multiprovider, gets data from actual cube(A) and plan cube(B) which have couple of characteristics NOT common in both, so when i drilldown on any one of these characteristics, i am getting a JUMP in the data i.e more than the top level. I observed that in the Multiproider IDENTIFICATION screen that these NOT common characteristics are being pulled out from their corresponding master data. Not sure here. I guess i am correct!
Question 1: Will this cause a problem??
Then as i found that planning was not done on all the objects which are present in the actuals cube.
Question 2: How should i eliminate the data i.e like some materials, which are not planned from seeing in the report, as i guess are coming from the actuals cube. Can i do some kina restriction?
Please suggest what could be a possible solution.
PS: Bhanu sorry for getting back to you so late on this as i was stuck with a lotta other stuff. Appreciate your patience.
Thank you all.