1734292 - Unable to change "Qualifier/Owner" in Multi-source data foundations-BI4.0 IDT

SAP Knowledge Base Article - Public

1734292 - Unable to change "Qualifier/Owner" in Multi-source data foundations-BI4.0 IDT

Symptom

Unable to change "Qualifier/Owner" in Multi-Source Data Foundations after changing the connection in Connections tab of data foundation.

Environment

  • Business Objects 4.0 SP02 patch 17
  • Data Base: Sql Server 2008
  • Middleware: ODBC, OLEDB
  • OS: Windows Server

Reproducing the Issue

  1. Login to IDT and create a new relational connection for sql server database using ODBC middle ware.
  2. Create a multi source data foundation and insert a table which is present in any of two databases.
  3. Right click on the table and click on change owner/qualifier, change the owner to another database in which the table is there and save it. It updates the new owner and qualifier for the table.
  4. Right click on the table and click show values, it brings up the table values.
  5. However in data foundation if we go to Data Foundation- Connection tabs –Right click and change the connection to another connection to the same database and then change the owner/qualifier, it is saying ‘no connection’ when we keep the mouse on the table.
  6. It gives an error ‘Data Source Cannot be null’ when viewing table values.
  7. The issue is with OLEDB middleware also.

Resolution

After testing in Business objects 4.0 SP04 there is no more issue by following the below workflows.

Work around 1:

  1. This works in Business Objects 4.0 SP2 Patch 17 also.
  2. Modify the existing connection(with other database name) and republish the connection overwriting the existing one(and then change the connection in data foundations tab)
  3. Now the data foundation is unable to identify the connection, when we right click on the connection name we get an option “Quick Fix”.
  4. Select Quick Fix and re-point the new connection and save.
  5. Try to change owner/qualifier and click on show values, it displays the table values.
  6. Now we are able to change owner/qualifier.

Work around 2:

  1. Create a relational connection, and create a mutli source data foundation on it.
  2. Try to change owner/qualifier and view table values, it works fine and gives table values.
  3. In data foundation, go to change connection(in ‘Connections’ tab) and change the existing connection with some new connection.
  4. Now try to change the owner/qualifier, we will get the error: “Invalid connection: connection is not registered”.
  5. Republish the new connection to repository and overwrite it.
  6. Now the data foundation is unable to identify the connection, when we right click on the connection name we get an option “Quick Fix”.
  7. Select Quick Fix and re-point the new connection and save.
  8. Try to change owner/qualifier and click on show values, it displays the table values.
  9. Now we are able to change owner/qualifier.

Keywords

KBA , BI-BIP-SL , Semantic Layer , Problem

Product

SAP BusinessObjects Dashboards 4.0