Forum Discussion

Ofri's avatar
Ofri
Regular Visitor
9 years ago

using a live connection with analysis services to fill maps

I have an analysis database (multidimensional) with stores and their sales values. The store dimension has the attributes "store", "longitude" and "latitude". In the calculations of the cube I added two measures for the coordinates:

[Measures].[Longitude] as CDbl( [Store].[Store].Properties("Longitude"))

[Measures].[Latitude] as CDbl( [Store].[Store].Properties("Latitude"))

 

The MDX

 

select { [Measures].[Longitude], [Measures].[Latitude], [Measures].[Sales Value] } on 0
,[Store].[Store].[Store] on 1
from [Sales]

 

returns the correct values and types (alle measures are of type double).

 

How do I visualize the stores on a map in PowerBI-Desktop? How do I configure the properties of a map correctly?

 

Thanks for help!

Need Help

9 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi Ofri,

    Based on your title, you connect SQL Server Analysis database in live connection mode. As I tested, we can't write MDX(the mdx zone is grey out) when get data in live mode as the following screenshot shows.



    If you use the MDX to select data, you will get a table including the following fields.

    StoreName Longitude Latitude SalesValues
           


    If my understanding is right, please put StoreName in Location field, Longitude as Longitude, Latitude as Latitude, SalesValue as Size level.

    Then you will get a similar map like the following screenshot shows. The SalesValue is bigger, the size of dots are bigger.


    Best Regards,
    Angelia

    • Ofri's avatar
      Ofri
      Regular Visitor
      9 years ago
      Hi Angelia

      I thougt it would work this way. But you can't drop measures into Latitude or Longitude. Is there an example with live data?

      Best wishes, Olaf
      • v-huizhn-msft's avatar
        v-huizhn-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        Hi Ofri,

        As I tested, when we connect data in live mode. We still can't use measure into into Latitude or Longitude. You need to use  into Latitude or Longitude value in the levels.

        Best Regards,
        Angelia

  • ashishogr's avatar
    ashishogr
    New Member
    3 years ago

    Any solution to the issue in this thread?? I am facing a similar problem.