May 24, 2012 at 3:21 am
Hi. I'm wondering if someone can help me with the following issue.
I have 2 data sources DS1 and DS2 which are both databases on the same server.
DS1 contains my measure group MG1
DS2 contains my 2 dimensions Dim1 and Dim2
Now when I set the realtionship on MG1 to Dim1 everything is fine.
But when I set the relationship between MG1 and Dim2 (referenced relationship through Dim 1) then I get errors. Namely that it doesn't recognise Dim1 (Invalid object name 'Dim1'.; 42S02).
I'm sure this has something to do with the measure group being on another database/datasource because if I move that measure group to the same database as the dimensions (DS2) then everything works fine. *Note that I can't have this solution on the live system due to other design constraints.
Can someone please help?
Thanks
May 24, 2012 at 5:44 am
A way I've got around this is to create a view on DS2 which looks at the MG1 on DS1. Then I use this as my measure group object within the cube view. It's a work-around but surely 2 different data sources can be used without having to do this...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply