Problem with Geo-coodinates colums

[belenbenitez]

I request support, I managed to use the Geo-coodinates colums from the Datasphere and now when I try to view it again from the Datasphere the following message is displayed: Right now, there are no visible columns in the table. Please select the columns you need in the table settings.

The creation of the Location dimension is done as follows:
1. A graphical view called CRM_PropiedadeCroquiCliente_1 with the columns latitude and longitude is available.

2. Created a CRM_PropiedadeCroquiCliente_2 view with Semantic Usage "Dimension"

3. A Calculated Columns was created with Data Type hana. ST_Geometry from CRM_PropiedadeCroquiCliente_2

4. Created a CRM_PropiedadeCroquiCliente_3 view with Semantic Usage "Fact" and with Associations to CRM_PropiedadeCroquiCliente_2 by idparceiro

5. An Analytic Model was created CRM_PropiedadeCroquiClienteFinal_V1

[XaviPolo]

DELETED

[XaviPolo · Accepted solution]

Your steps are correct.
1.- Create the Location field in a Dimension.
2.- Associate the Dimension to the Fact
3.- And in the Analytical Model select the association to the Dimension to publish its fields (including the Location).

I don't understand why you see two Location fields, you should only see one inside the Dimension ‘folder’. Try deleting the one that is out of the Dimension.

Regards,

[belenbenitez · Accepted solution]

Thanks for your help, please delete the dimension that was duplicated but the same message is displayed A question in the SAC Location dimension will only be available for geographic map? because if I use it with a geographical map I can visualize it.

[belenbenitez · Accepted solution]

HI Xavi, Thanks for your help, I deleted the dimension that was duplicated but the same message is displayed A question in the SAP Analytics Cloud, Location dimension will only be available for geographic map? because if I use it with a geographical map I can visualize it.

[XaviPolo · Accepted solution]

in DSP doing a data preview of the dimension (in view and in AM) you can see the Location field and its values, like POINT (7235766.90155 3895303.9634).

In SAC I think that only the Map object can see and use the field.

Regards,

[belenbenitez · Accepted solution]

Hello Xavi Sorry, what is AM? I think that from the Datasphere, the Analytical Model does not usually show the preview of the data as shown in the last image capture I shared, that is why the message is displayed: "Right now, there are no visible columns in the table. Please select the columns you need in the table settings", only from the Semantic Usage "FACT" view the data is displayed (which is the previous view to my analytical model) Best regards

[XaviPolo · Accepted solution]

Yes, AM is Analytical Model. And I can see the object in both previews.

[belenbenitez · Accepted solution]

Hi Xavi, 

OK, thank you so much.

Best regards