The issue here is that two cubes are trying to be blended, and that is not currently possible. A cube can be blended with a relational datasource as long as it is the primary source.
Thanks for the quick response Tracy. It was very helpful.
I will check with my admin to see what can we do to resolve that.