Query not working ! Why ?

33 Views

Hello Experts,

I have a query problem, its not giving me the correct result..can anybody point me out the problem ?

I have a MultiProvider created on 2 Cubes. There is one Z infoobject which gets filled up properly, But the problem is, that Z Info Object is only available in cube 1. So in MP i have assigned to that cube only.

Now, when i run the query, i do get result, That means, query should get data from both the cubes.

the Z IO is in Free char. list, when pull that Z IO to the query, it shows NOt assign. I checked that Data in Cube 1 and i could see Data with that Z filed.

What is the problem here? Is my query not pulling data from cube 1 at ALL ?? Should i delete data of cube 2 and try to run the query ? to see if at all it shows Z IO ?

please help..Thanks