Universe on top of SAP BW

[arijit_das]

Hi Experts,

I need help in creating a universe on top of BPC Cubes.

While creating Universe connection, I have followed the steps below:

1. Connection type:

SAP BusinessObjects > Business Planning and Consolidation > OLE DB for OLAP Providers

2. Username: DOMAIN\USERNAME

3. Server: BPC Server IP Address (tried with port as well)

Then I am getting the following error:

DBD: An error has occurred while attempting to connect to the OLAP server. Failed to initialize (returned server error (Returned DB_SEC_E_AUTH_FAILED (0x80040e4d)))

Any Idea where I am going wrong ?

Product Versions:

SAP BPC 7.5 SP 07

BO XI 3.1 SP2 FP 2.9

Thanks and Regards,

PASG

[arijit_das]

solved by adding a host file entry

[Former Member]

I appreciate that you take the time to post your solution.

Best Regards

[phuong_luu]

Hello.

Please advise which instance the host entry is added??? is a host entry add in BPC or BOBJ server???

Thanks,

Phuong.

[Former Member]

Hi,

Could you give more details around what host file you are refering to? As I have the same error message.

Thanks

[arijit_das]

host entry for BPC server in the host file of BOBJ Client system.

[Former Member]

Thank you for the feedback.