I'm baffled on this one; I have created a multiprovider that contains A) COPA Cube and B) S900 Sales Cube.
The multiprovider has selections from each cube but when I run a query I can not get any key figure values from the COPA cube. They always come across as ZERO. I know I am probably missing something stupid. If I make the query extremely minimal and simply select one characteristic and one key figure from the COPA Cube I get ZERO records. Any suggestions as to what I might be missing or what to look for? I know it's difficult to help not being able to see what I'm doing....
Thanks.