Skip to Content
avatar image
Former Member

dimension data as data source (no measure)

Hello SAP Community,

I'm working with SDK development and I´m new to that subject. Currently I am working on a Google Maps integration.

The integration of the API worked well, but I have problems with data loading.

The Problem:

I try to get the a ResultCellList of geodata (latitude and longitude). This data is saved as dimension data.

My problem is, that I could not find a way to access non-measure data. All the ways to load data I found were based on measure data. Is there any way to access dimension data or is a rebuild of the cube neccessary?


Many kind regards,

Markus

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 22, 2015 at 08:26 AM

    Hi Markus,

    I have already implemented and published an SDK extension open source for that purpose last year. You can check it out starting on my blog entry and find the GitHub repository link to the source files:

    http://scn.sap.com/community/businessobjects-design-studio/blog/2014/12/01/google-maps-and-openstreetmap-component-sdk-development-insights

    Let me know if that answers your questions or if you need further input.

    Regards

    Martin

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Martin,

      I have to go a bit deeper in the code, but it seems to be exactly that what I'm looking for.
      Thanks a lot.

      Regards
      Markus

  • Oct 21, 2015 at 04:54 AM

    Hi Markus,

    You mean you want to only access the dimension instead of measure data.

    { "key": "CITY", "text": "CITY", "axis": "ROWS", "axis_index": 0, "members": [ { "key": "Berlin", "text": "Berlin" }, { "key": "Rio de Janeiro", "text": "Rio de Janeiro" }, { "key": "Tokyo", "text": "Tokyo" }, { "key": "Result", "text": "Overall Result", "type": "RESULT" } ] } ], "locale": "en_US" }

    Consider this is dimension city.The data for this will available as members. For example here, Berlin,Tokyo,Result. So you can simply access the dimension members to get the result as you expected.

    Hope this makes sense. If not or if i misunderstood something on your question, feel free to correct me.

    Thanks,

    Nithyanandam

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Markus,

      There is no separate Meta data JSON for the databound property ResultSet. Which you can find it in Developer Guide. However, I am kind of confused about your requirement. I have not written any code in my previous reply. Just gave you a suggestion of how to get the dimension members. Can you  share your data json??

      Thanks,

      Nithyanandam