I want to solve a problem that I have, by creating a dimension from a table
that is not in the datasource that the cube is from. Is this possible? If
so how? (At this time I am working exclusively in the Analysis Manager gui.
If I need to get into MDX, whatever that it, please point me in the right
direction.)

The problem I am trying to solve is that the data that I need for the
dimensions is in a sorta catch-all table with a whole bunch of irrelevant
stuff. If I had CREATE TABLE permissions for the database I would create
the table that I need from the catch-all table and use that. (This works
fine when I put the whole database on my box, where I have the permissions.)
.... so I want to create the tables that I need in another database and use
them.

Alternate solution: if I could put a WHERE clause on the table that I am
using for the dimension, that would work too. - like the Source Table Filter
property of the cube.

Thanks.

"pschuller" wrote:
I don't think there's a way to use a dimension from a different OLE DB
connection than your data.

If you had CREATE VIEW privs on your database, you can put a where clause
into a view and create a dimension from the view.

You could also try to create a database link between your local server and
the remote server. Not sure how the performance would be on that.

Regards,

Jonathan