/providers/{namespaceID}/{providerID}/PublicDimensionData

This endpoint returns data from the public dimension master data for the specified provider.

Account, generic, date, version and organization public dimensions stored in SAP Datasphere space are supported.

API Request Details

URL

{BaseURL}/providers/{namespaceID}/{providerID}/PublicDimensionData

Request Type

GET

Content Type

application/json

Sample Request

https://your-sac-tenant-url.cloud/api/v1/dataexport/providers/sac_public_dimensions/myProviderID/PublicDimensionData

Sample Response

{ 
    "@odata.context": "metadata#PublicDimensionData", 
    "value": [ 
        { 
            "ID": "BS100", 
            "accType": "AST", 
            "rateType": "Closing", 
            "Description": "Total Assets", 
            "Language": "EN", 
            "scale": 2, 
            "numericShift": -3, 
            "unitType": "CUR", 
            "unitOfMeasure": "", 
            "formula": "IIF([PL030] = 0, NULL, [PL310] / [PL030])", 
            "aggregationType": "", 
            "exceptionAggregationType": "LAST" 
        } 
    ] 
}

Note

When extracting account dimensions, the numericShift property, which corresponds to Scale in SAP Analytics Cloud, is stored as a numeric value. The values are mapped as follows:

  • 0 is mapped to "None"

  • 2 is mapped to "Percent"

  • -3 is mapped to "Thousand"

  • -6 is mapped to "Million"

  • -9 is mapped to "Billion"