How to select different database columns in a single BO Universe Object

[Former Member]

We have 'n' databases. All the databases have identical tables and views but some tables in few database have custom columns.

Ex. 'database1' has table 'sites' with the following columns

1. sitenumber

2. sitename

3. siteaddress

4. phone

5. email

6. ActivatedDate

'database2' has table 'sites' with the following columns

1. sitenumber

2. sitename

3. siteaddress

4. phone

5. email

6. ActivatedDate

7. LocalActivatedDate

The condition says that

"Local Activated date will be used if populated in the system otherwise Activated Date will be used"

How do i create a condition at the universe level which checks whether the column "LocalActivatedDate" is present in the database or not. Also, how to give a condition which select between "ActivatedDate" and "LocalActivatedDate"

A single universe needs to be created for all the databases. Only the Default Database in connection parameter changes during deployment.

Can this be achieved using BO Universe Designer only?

Thanks in Advance,

Arun

Edited by: arunkumars on Dec 2, 2009 10:00 AM

[Former Member]

Create a universe with your default connection and then while changing the universe connection you can write an SDK script using universe designer sdk do a REFRESH STRUCTURE so that all the you will get the schema same as current DB and then you can add predefined condition or object to this universe (before doing this keep a copy of the universe) .

You have to do a lot of stuff to keep your universe proper and stable to work with all the databases using designer SDK.

Can achieve this but with an overhead of writing and calling SDK scripts again and again . ...

Hope this helps...

Regards

Kunal

[amrsalem1983]

no you can NOT do this in unvierse designer

universe designer uses only one connection to create a universe.

good luck