Multi-source enabled universe connection issue

[Former Member]

Hi All,

I am trying to create a multi-source enabled universe in SAP BO 4.0 version. Two databases that I am using are MS access 2007 and SQL server 2008. I am able to create single source universe with two databases however when I try to create multi-source enabled universe it does not allow me to select these two data sources. It shows "this data -source is not supported in multisource enabled data foundation".

I have also published the connection to repository.

Pease help.

Regards,

Richa

[Former Member · Accepted solution]

Hi Richa,

Kindly take out the Data Federation service from the default APS server and host Data Federation service independently in a newly created APS server to test the issue.

Regards,

Nakul Mehta

[Former Member]

Hello Everyone,

Thank you for all your inputs.

My issue got resolved. I was  not connected to data federation services. Data federation server was disabled. I re-started the server and it worked.

Thanks again

Richa

[Former Member]

Hi

I haven't tried multisource yet....

--------

As per Note 1710144

Log into the Central Management Server (CMC).

Stop the AdaptiveProcessingServer.

Under Host Identifier, Select HostName.

Enter the host name and port number where the or the AdaptiveProcessingServer.

Restart Server Intelligence Agent in Central Configuration Manager.

-------

Where are you trying at server or client side?

Sandeep

[Former Member]

Please check this. Also if possible can you share the error screenshot. I hope you are going through the correct process of creating a multi source universe, if its the first time please check the product tutorial for multi source universe.

.

http://scn.sap.com/thread/2113454