How Tables coming from Schemas should dynamically pick the Owner depending on the user logs in.

[Former Member]

Hi,

I just need a help in SAP BO BI4. I have one common schema S. I have multiple Product information and each Product information is associated with a unique Schema. All Schemas are having same structure tables/views etc.

Ex: Product---Schema

===================

India-----X1

Usa------X2

Uk--------X3

Now In IDT the Tables coming from Schemas are having Owner as X1 and like that.

Can I do something when User A logs in, he should see data from Associated Schema. I mean the Tables coming from Schemas should dynamically pick the Owner depending on the user logs in.

Thanks in advance.

[former_member182521]

Hi Mahesh,

This is exactly what you require.

http://www.trustedbi.com/2012/12/19/dynamic-data-connection/

Regards,

Mani

[Former Member]

Few things you need to take care if you are following the above post is: -

1) In Data Foundation, right click the table and select "Edit", change the table name as "@prompt('Select DB:','K',{'DB1','DB2'},mono,constrained).dbo.Customer"

2) In Data Foundation, right click the table and set "DELIMIT" to "NO"

3) In Data Foundation, right click the table and remove any value for "Qualifier" and "Owner" and uncheck "DELIMIT" check-box.

Thanks,

Vivek