Hi all
Is it possible to pass table joins as a source table
filter property in the Cube design editor?
e.g., i have
Table A with az_sk, az_id, az_date_found
Table B with gh_az_sk, gh_id, gh_user_name

In standard SQL query i need to join them using the az_sk
to get the results like
Select az_id, gh_user_name from A,B where az_sk = gh_az_sk

Is it possible to do the same in Analysis too using the
source table filter property like "A"."az_sk"
= "B"."gh_az_sk" ?

Thanks in advance

Regards
Guru

Why don't you just define a view in sql server and base your source table
on that ?

Mark

"guru" <shyam_chatty (AT) lycos (DOT) com> wrote

Thanks for the reply Mark

I've got a limitation on that. I donot have permissions to
access the database structure and moreover its an oracle
9i database.

Actually i was trying to work with alias tables and I'm
getting error messages. So I was just trying for a work
around.

My earlier post to the same news group explained my
situation "Create Dimension Problem!!" dated October 17th
2003. Please look into it and help incase.

Thanks and Regards
Guru

guru,
you might consider crreating a staging db in sqkl server.
To me that seems like the "cleanest" approach anyway,
since in this staging db you can also cleanup data if
necessary. Given the fact that you use AS I assume that
you must have SQL Server 2000 anyway, even if you did not
set it up yet.
Just transfer your data from Oracle into your staging
database and then do whatever is necessary.

HTH Lutz

That should be a fairly good idea to work around. i've got
SQL server 2000 installed.

Thanks for the advice lutz.. i'll try the option out and
get back with results.

Thanks and regards
guru