Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Select Customer in rows and Measures in columns. From Calculated members section select Customer latitude and Customer longitude underunder Customer properties. These measures should be the first selected measures in precisely this order - latitude, longitude.

If these calculated members are missing, you can create them, by clicking on Define new and using the following code:

  1.  Customer latitude:

    Code Block
    [Customer].CurrentMember.getProperty('Lat')


  2. Customer longitude :

    Code Block
    [Customer].CurrentMember.getProperty('Lng')

    OR

  1. Supplier latitude:

    Code Block
    [Supplier].CurrentMember.getProperty('Lat')


  2. Supplier longitude:

    Code Block
    [Supplier].CurrentMember.getProperty('Lng')



5. Select Measures To Be Shown Your Map Chart

...

  • No geocoding data is stored for this customer/supplier in properties Customer latitude and Customer longitude (or Supplier latitude and Supplier longitude);
  • The customer/supplier it is marked using Geocoding needed property value -1;
  • For troubleshooting purposes the resulting address is stored in the Geocoding address property;
  • For troubleshooting purposes the resulting address precision is stored in the Address precession property;
  • For troubleshooting purposes the resulting address similarity is stored in the Address similarity property.

To get the missing geocoding data, you have to check the previously mentioned properties and the customer/supplier properties used for geocoding (street, city, geocoding_needed, inv_addr2, inv_addr3, inv_addr4, country_code) and make the necessary changes either in the precision and similarity limits or customer/supplier address data. 

Adjusting Minimum Address Precision and Similarity Parameters

...