How to setup default database for universe?

[Jcatcat]

[Background]
DB: sql server 2000
There are two databases: ABC-production, ABC-test, whose database structures are same.

When I insert a table into my universe:
1)if I set owner=dbo and qualifier=ABC-test, I can fetch the data from ABC-test.
2)if I leave owner and qualifier empty, I will fetch the data from ABC-production.

[Question]
I want to switch between ABC-production and ABC-test, but I don’t hope to change table config one by one every time.
Is there some place I can config this generally?

I have try to set default-database=ABC-test in datasource configuration, but it doesn’t work. ABC-production is always the default database when I leave owner and qualifier empty.

 

[blom0344]

Create an BO account for each database. Now specify 2 BO connections (one for test, one for production).
Assign the correct connection for the combination of account-universe in supervisor and you can switch by using the proper account.

Ties Blom

 

[Jcatcat]

Got it, thanks.