March 12, 2008 at 3:46 am
Hi,
I am a brand new entrant into MDX world and am stuck up with an issue.
In SQL, you can specify the server name inside the query to do a join of tables from databases in different servers(e.g OPENDATASOURCE) . Is it possible in MDX queries? Can I use OPENDATASOURCE in MDX? If yes, then can someone please provide me some example queries or point me to some worthwhile links where I can check up the syntax. Apart from OPENDATASOURCE, is there any other way to achieve cross server MDX query capability?
Thanks for your time
Amit
March 24, 2008 at 9:41 am
It's my belief that you can't even query multiple cubes within the same server in MDX, so cross-server is probably impossible. Why not build a cube that has data from both servers in the UDM?
Rick Todd
March 24, 2008 at 9:52 am
You can introduce/query data from different cues in a single statement but I think you'd have to use the LookUpCube function (which has performance implications?). Assuming you've got the SQL BOL installed, type in MDX in the filter and then select Cube Context from the child index entries to see the details.
You would probably have to have the remote cube set up as a linked cube in the local server to use LookUpCube as i don't think it takes a server reference (this too could introduce more performance implications).
Like Rick pointed out, is there a reason why you wouldn't have multiple measure groups in the local cube to get around this?
Steve.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply