topic Re: Add Data - Location Types will not populate in ArcGIS for SharePoint Questions

Add Data - Location Types will not populate

Anonymous User — Wed, 19 Mar 2014 18:38:01 GMT

Hello,

I have a customer in our Business Objects group who is trying to add data using the ESRI Maps for BO. He creates his data from a spreadsheet within BO, selects data, binds the data and so forth...step by step according to the help via ESRI. After "add data to map" and it finds his layer, the define the location option doesn't have a list to select from. The "How is location represented in your data", (specify how locaiton is represented in the current dataset ex:lat/long, address, US City, US State, etc.) list is empty. Any suggestions on what we might be missing?
[ATTACH=CONFIG]32333[/ATTACH]

Thank You.
Allison

Re: Add Data - Location Types will not populate

ShirleyBaffoe — Fri, 21 Mar 2014 17:39:39 GMT

Hello Allison,

This error typically occurs when your firewall has been configured to block internal proxy requests. If this is the case, you will need to configure an upstream proxy. When you configure an upstream proxy, all calls from the Esri Maps for SAP BusinessObjects internal proxy are routed through the specified URL to the proxy server, which in turn routes calls to the ArcGIS platform.

The proxy configuration file (proxy.config) is located at the following path on your server: em4bobj\dashb\proxy.config.

To specify an upstream proxy, set the useUpstreamProxy element's enabled attribute to true, and specify the URL of the upstream proxy server.

For example:

<useUpstreamProxy enabled="true">
http://127.0.0.1:8888
</useUpstreamProxy>

For more information please refer Configure Upstream Proxy section on our documentation

Shirley

Re: Add Data - Location Types will not populate

ArjunKT — Mon, 16 Jun 2014 08:57:31 GMT

Hi Shirley ,
I am also facing similar problem please find a snapshot of my config file let me know if some thing wrong in it.
[ATTACH=CONFIG]34602[/ATTACH]

Re: Add Data - Location Types will not populate

ArjunKT — Tue, 17 Jun 2014 04:52:47 GMT

Hello,

I have a customer in our Business Objects group who is trying to add data using the ESRI Maps for BO. He creates his data from a spreadsheet within BO, selects data, binds the data and so forth...step by step according to the help via ESRI. After "add data to map" and it finds his layer, the define the location option doesn't have a list to select from. The "How is location represented in your data", (specify how locaiton is represented in the current dataset ex:lat/long, address, US City, US State, etc.) list is empty. Any suggestions on what we might be missing?
[ATTACH=CONFIG]32333[/ATTACH]

Thank You.
Allison

Hi were you able to resolve this issue Pls reply.If yes How?

Re: Add Data - Location Types will not populate

ShirleyBaffoe — Thu, 26 Jun 2014 12:37:57 GMT

Hello Allison,

Kindly refer to the following Knowledge Base article Problem: Location types are missing when adding data from a business system to resolve the problem.

Let me know if you still have questions.

Thank you,
Shirley

Re: Add Data - Location Types will not populate

Vara_PrasadM_S — Fri, 24 Oct 2014 07:42:26 GMT

Hi,

While adding any data, i am not getting any list of Location Types. When i checked, i found the below url is not giving any repsonse.

http://server:8080/em4bobj/dashb/proxy.jsp?http://la.arcgis.com/common/locationproviders/LocationProviders.xml

I am getting attached error.

I tried updating proxy.config file, by setting mustMatch = true and adding tag <serverUrl url="http://la.arcgis.com"/>. However, it did not help.

Could you please let me know what is UpStreamProxy and how to use it.

Thanks & Regards,

Vara Prasad.

Re: Add Data - Location Types will not populate

Vara_PrasadM_S — Tue, 28 Oct 2014 03:48:26 GMT

Hi,

Finally the issue is resolved by customizing proxy.jsp page to include code for proxy authentication. It might be required because of restricted network in my office.

Thanks & Regards,

Vara Prasad.

Re: Add Data - Location Types will not populate

SusanJones — Tue, 25 Nov 2014 04:59:42 GMT

Hi Shirley

By upstream proxy, are you referring to the proxy server for the organisation?

We have this enabled, restarted Tomcat and still not able to add from the table.

We have ESRI Maps for Business Objects and it is is falling down at the point where an excel data source does not show up in the panel on the left when it is added to the ESRI Control in dashboard.

ArcGIS Server 10,2

Portal 10.2

em4bo v2

Susan

Re: Add Data - Location Types will not populate

ShirleyBaffoe — Tue, 25 Nov 2014 14:05:59 GMT

Hello Susan,

The scenario you mentioned is not as a result of a proxy configuration. You will have to bind your excel data to the map. Follow the following steps to do that:

Click the Esri map component to display its Properties panel. On the General tab, in the Data Sources section, click the + (plus sign) icon.
In the Source Name field, type a new name for the data source.
Click the Binding Selector icon beside the Source Data field, and select Spreadsheet.
Select the cells of data that you want to bind to the map and click Ok in the Select a Range dialog box.

For more information on how to bind data to your map, refer to the build a map enabled dashboard section of the documentation,

Hope this helps.

Shirley

Re: Add Data - Location Types will not populate

SusanJones — Tue, 25 Nov 2014 17:30:58 GMT

Hi Shirley,

many thanks. You are too awesome.

I'll pass it on to the BO Developer this morning. We will get some testing done and report back shortly, in the next 2-3 hours.

Do we still have to have the proxy configs set up if we are in the same corporate network?

Re: Add Data - Location Types will not populate

SusanJones — Tue, 25 Nov 2014 21:51:18 GMT

Hi Shirley

The issue is still that the Location Types will not populate. I was ambiguous when I said that the Developer was not able to add the excel data source. This should have been Spreadsheet data source.

The data source creates and is binded no problem.

From there Launch ESRI Map Designerdoesn't populate the data source.

Susan

Re: Add Data - Location Types will not populate

ShirleyBaffoe — Wed, 26 Nov 2014 13:27:07 GMT

Hello Susan,

The location types problem has been fixed in EM4BOBJv2.0. Verify that versions of both server and client components installed are version 2.0. To check the version of the server component installed:

navigate to the <SAP BOBJ Install Dir>\webapps\em4bobj\em4bobj\
open the version.txt file.
The version number should be 2.0

To check the version of the add-on in SAP Dashboard:

Launch SAP Dashboards
Create a new blank dashboard
Click on File, then select Manage Add-Ons
Select the Esri Maps for SAP BusinessObjects Add-On
In the Add-on Details, the version should be 2.0

If any of the versions is not you can obtain the EM4BOBJv2.0 download from the product page.

If both versions are 2.0, then clear your IE browser cache, re-launch SAP Dashboards. The location types should be visible.

Thank you

Shirley

Re: Add Data - Location Types will not populate

SusanJones — Wed, 26 Nov 2014 19:35:34 GMT

not very good at problem reporting. I see we got the version 1 installed.

Re: Add Data - Location Types will not populate

ShirleyBaffoe — Wed, 26 Nov 2014 21:14:57 GMT

Hello Susan,

At this point you have 2 options:

Upgrade to EM4BOBJ2.0 and take advantage of the new features in the software. As I mentioned earlier you can download the Esri Maps for SAP BusinessObjects from esri.com. Follow the steps described in the Upgrade Esri Maps for SAP BusinessObjects section of the online help to upgrade from EM4BOBJ1.0 to EM4BOBJ2.0.
Configure the proxy by doing the following:
1. Verify that you can route and HTTP request through the internal proxy. For example http://<mySAPBIPlatformServer>/em4bobj/dashb/proxy.jsp?http://www.arcgis.com/sharing?f=pjson should return the ArcGIS online version. If this is successful, proceed to the next step
2. Refer to the knowledge base article Problem: Location types are missing when adding data from a business system to resolve the problem.

Hope this helps.

Shirley

Re: Add Data - Location Types will not populate

SusanJones — Thu, 27 Nov 2014 22:46:32 GMT

Hi Shirley

Seems like the demo portal license for 10.3 timed out last month and this is preventing access.

Back to the ESRI Reseller to fix up.

Many thanks for your help.

Susan