Skip to Content
Former Member
Mar 09, 2017 at 07:52 AM

Possible to get richer metadata from Odata service $metadata endpoint


I have a calculated view that I've made available as an odata service using the following:

service  { 
"dev.views::CV_ORDERS" as "Orders"
     key ("ORDER_ID")
     create forbidden
     update forbidden
     delete forbidden;

The referenced view contains both attributes and measures along with user friendly labels for each of the columns. I'm able to pull up the metadata of the view via the $metadata endpoint in the odata service but it only returns basic properties like the column names and datatypes:

<EntityType Name="OrdersType">
        <PropertyRef Name="ORDER_ID"/>
    <Property Name="ORDER_ID" Type="Edm.String" Nullable="false">
    <Property Name="SOME_ATTR1" Type="Edm.String" MaxLength="100"/>
    <Property Name="SOME_ATTR2" Type="Edm.String" MaxLength="12"/>
    <Property Name="SOME_ATTR3" Type="Edm.Int16"/>
    <Property Name="SOME_MEASURE" Type="Edm.Int32"/>

Is there a way to get at the additional properties of the view such as if a column is marked as an attribute or measure and also the user friendly labels I have defined on the view?

I found a way to get that data by querying directly against the sys_bi tables but am hoping I can get at them directly via odata.

Any suggestions or help would be greatly appreciated.