How to get custom columns from Database in BO Universe

[Former Member]

Hi,

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

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

1. sitenumber

2. sitename

3. siteaddress

4. phone

5. email

6. IsDepot

The condition says that

"If IsDepot field is present in the site table then list sites where IsDepot equals 0 or null otherwise list all sites"

How do i create a condition at the universe level which checks whether the object 'IsDepot" is present in the database or not.

A single universe needs to be created for this purpose

[fvan]

Hi

This is the perfect use case for Data Federator which manages connections to multiple sources and let you define you own schema and the mappings (called mapping rules) between the sources and this schema.

In the mapping rules, you can implement your own business logic including case statements.

If the isDepot field is not available in the source, DF will generate a null.

You can find more details about Data Federator on our [Blog|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/u/251908199] [original link is broken] [original link is broken];.

Hope this helps,

Fred

[Former Member]

Hi Fred,

Thank You for the quick reply.

Can this problem be solved using Bo Universe Designer alone?

Thanks In Advance,

Arun

[fvan]

Arun

Unfortunately not as your use case requires multiple connections to your sources.

The multiple connections and data modeling are part of the DF features.

Once the connections and the data model is in place you can use the Universe to create your business layer.

Hope this helps,

Fred

[amrsalem1983]

whenever there is a requirement for getting data from different datasources or different databases, then you can not do this by a universe designer.

as an alternative you could go for the Data Federator option, which require to buy a new lisence and a new software.

good luck

Amr

[Former Member]

Hi,

We have implemented a solution for the IsDepot problem as mentioned above.

It is not done at the BO Universe level but at the SQL Server database level.

Steps Followed:

1. Created a stored procedure which checks the 'syscolumns' table for available fields

2. The SP creates a temp table with a value list based on previously mentioned conditions

3. This temp table can be used in the universe or a condition can be used to filter data based on this temp table.

Thanks,

Arun