Problem to access BPC from excel

[former_member269849]

Hello everybody,

I'm new in SAP BPC, Please I have a problem to acces into it from excel because we have the ERP and BW installed in the same machine but not the same client ERP in client 300 and BW in client  100 , the default client is  the one of ERP, what should I change ?

for the URL server it's like http://[URL]/sap/bpc/web/. for the acces from the web the link that works is like this http://http://[URL]/sap/bpc/web?re=1&sap-client=100.

Thank you

[Former Member · Accepted solution]

Hi Fatima,

    Make sure if you had installed EPM client . To check whether it is installed or not you will see "EPM" & "Data Manager" 2 Extra tabs in your excel like below screen

After that you need to click on "Logon" which is at the beginning & There you need to create a new connection adding your URL link as below screen

Click on the yellow marked area

After clicking connect enter your credentials (BPC User ID & Password).

After this step you will find your "Environments" & "Models" in the Drop down box which is located below "Connect".

Note:- Make sure if your model has any "Secure Dimensions" then your user must have "Data Access Profile" to that particular Dimension then only you can see that model here .

Thanks & Regards,

Aravind

[former_member269849 · Accepted solution]

Hi Aravind,

Thank you for you help but EPM addin is well installed , the problem is when we connect from the web http://192.168.1.5:9912/sap/bpc/web

it took the default client which is the ERP one  not the BW one , if i want to connect in the BW one i should do this URL( specify the client)   http://192.168.1.5:9912/sap/bpc/web?re=1&sap-client=100

so when i want to connet from excel it took automatically the client by default whis the ERO one .

[Former Member · Accepted solution]

Hi Fatima,

If you want to change the client permanently please contact your "BASIS Team"  They have to change this in the back end.

Kindly logon into your required client(100) & Goto T-code "SICF" & then Execute the "Services" (Click F8 in keyboard) . There you should configure your required path "sap\bpc\web" . This job has to be done by your Basis Team kindly request them to do so.....

Thanks & Regards

Aravind

[former_member269849 · Accepted solution]

Thank you so much, Problem resolved.

Regards.

Fatima

[Former Member · Accepted solution]

That's great to hear Fatima....

[Former Member]

If the EPM is installed correctly, make sure to give yourself the required security rights (task, data access) in the BPC admin (from web).

Then, to access your BPC model from excel, make sure to use the same URL as the web (which is working), but without the "/web" at the end.

If all this is ok, please share the error message. You can also have a look in SLG1 to check on errors.

[former_member269849]

Thank you for your help

[former_member181999]

Hello.

It looks like you did not install the EPM Client.

Please install the EPM client. Check with your Basis team or you can also download from www.service.sap.com ( search for  "Excel EPM ").

Setting the client is secondary. Once the EPM Add in installed you can access any client.

In case if any issue in installation. Follow the below help.

Hope this helps. Thank you

[former_member269849]

Hi Ashok,

Thank you for you help but EPM addin is well installed , the problem is when we connect from the web http://192.168.1.5:9912/sap/bpc/web

it took the default client which is the ERP one  not the BW one , if i want to connect in the BW one i should do this URL( specify the client)   http://192.168.1.5:9912/sap/bpc/web?re=1&sap-client=100

so when i want to connet from excel it took automatically the client by default whis the ERP one .

[former_member269849]

Thank you for your help.