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.