Hi,
I am having a problem figureing out how to go about promoting my OLAP
databases from devlopment->test->production. I just switched to using
oracle as a data source for the cubes, everything is fine except for
the fact that AS appends the oracle schema name to the fact and
dimension tables (oracle_dev.facttable) and (oracle_test.facttable).
So, when I am done with devlopment work and want to promote the cubes
to the test envoronment I cannot simply switch the datasource to point
to the test database because the table names no longer match due to the
schema name (oracle_dev vs. oracle_test). I have to go in and replace
all the tables. Usinf aliases won't work becasue that only changes the
display name not the name that's stored in the back end. I cannot have
the same schema name for both databases because they are both on the
same server.
Does anyone have any ideas of how I can work around this, aside from
having to put all three databases on different servers so I can name
the schemas the same.

Thanks,
Tom

have you try to use views?
Like:
OLAPSchema.View_FactTable1 (which is a select * from schema1.FactTable1)

this "OLAPSchema" can be created on "any" server

"TK" <tomkardaras (AT) hotmail (DOT) com> wrote

Jeje,
Thank you for your response. I did think of this as an option. The only
problem with this is that since I am limited to one server for
development and testing environments, I would not be able to develop
and have users test at the same time becasue the view woudl be pointing
to one or the other at any given time.

ok
and what if you create the views with a version in the label like
vw_FactTable1_v2
then create your cubes (or new cubes) based on these views?

this doesn't change anything to the end user and provide a version control.
When you are satisfied, you can delete the AS database and copy/paste the
new one to replace the old version.



"TK" <tomkardaras (AT) hotmail (DOT) com> wrote