cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with Geo-coodinates colums

belenbenitez
Explorer
0 Kudos
234

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.

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

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

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

Caso5.pngCaso10.png

Caso11.png
5. An Analytic Model was created CRM_PropiedadeCroquiClienteFinal_V1

Caso9.png

View Entire Topic
XaviPolo
Active Contributor

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
Explorer
0 Kudos
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
Explorer
0 Kudos
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
Active Contributor
0 Kudos

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
Explorer
0 Kudos
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
Active Contributor
0 Kudos

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

8lkh6Hvjuf.png8UBAuG75bT.png

belenbenitez
Explorer
0 Kudos

Hi Xavi, 

OK, thank you so much.

Best regards