Change Connection for xmla Query Window

One feature that has always irritated me greatly is how you cannot alter the connection for a xmla query window via the right click content menu. For .sql, .mdx and .dmx it is an option via the content menu, but not xmla!

Here’s some screenshots to emphsize my point.

This is from a sql window;

2014-10-16 16_05_49-SQLQuery7


this is the dmx window;2014-10-16 16_08_06-DMXQuery1.dmx

this is the mdx window;

2014-10-16 16_08_06-DMXQuery1.dmx

The option is conspicuous by its absence in the xmla context menu;

2014-10-16 16_06_23-XMLAQuery3


So what’s the problem here? I don’t understand why it’s not an option. It is possible, when in the xmla window to change it, but you have to use the Query menu:

2014-10-16 16_06_50-XMLAQuery3

I might also point out that this took me way too long to find out, not least because I was so used to using the context menu I did not even think of checking the query menu to change connection!



Author: Richie Lee

Full time computer guy, part time runner. Full time Dad, part time blogger. Knows a thing or two about Pokémon. Knows too much about SQL Agent. Writer of fractured sentences. Maker of the best damn macaroni cheese you've ever tasted.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s