Virtual Characteristic on multi provider

Hello all,

I have two basic cubes, CUBE-1 and CUBE-2 both of them have almost similar data except couple of fields, one of them is an indicator (Y or N).I have three infoobjects named 0Competitor 1 , 0Competitor 2 and 0Competitor 3 in both the cubes.

Report Requirement on Multi Provider is I want to run the report where I am checking for a competitor for example "ORACLE" in either 0competitor1,2 and 3 info objects.

I cannot chage the current design, so I have to handle this only through query.

any input is really appreciated,

thank you much.

k.