0 Replies Latest reply on Apr 12, 2013 4:03 PM by Sean Spicer

    OData & Navigation Properties

    Sean Spicer

      I've got an OData feed that I'm developing, and I'd like to use Tableau to look at it.  However, much of the information I want to expose is contained in navigation properties.  When I connect to my feed with Tableau, I don't see any of the navigation properties as Dimensions or Measures.  How can I query/analyze these things?

       

      For example, one of my data structures looks like this:

       

      OBJECT Business

           DIMENSION Name

           DIMENSION Address

          FOREIGN PROPERTY Employees

       

      OBJECT Employee

           DIMENSION First Name

           DIMENSION Last Name

           DIMENSION Birthday

       

      My GOAL is this, using tableau, plot (for each day, how many employees across all businesses have a birthday). 

       

      Can anyone help me do this?  For reference, here is a sample data feed:

       

      When I hit the ODATA service http://localhost/BizDB.svc/Businesses:

       

      <?xml version="1.0" encoding="iso-8859-1" standalone="yes"?>

      <feed xml:base="http://localhost/BizDB.svc/" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns="http://www.w3.org/2005/Atom">

        <title type="text">Businesses</title>

        <id>http://localhost/BizDB.svc/Businesses/</id>

        <updated>2013-04-12T22:49:02Z</updated>

        <link rel="self" title="Businesses" href="Businesses" />

        <entry>

          <id>http://localhost/BizDB.svc/Businesses('516485e36e8f91137c4d57d1')</id>

          <title type="text"></title>

          <updated>2013-04-12T22:49:02Z</updated>

          <author>

            <name />

          </author>

          <link rel="edit" title="Business" href="Businesses('516485e36e8f91137c4d57d1')" />

          <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Employees" type="application/atom+xml;type=feed" title="Employees" href="Business('516485e36e8f91137c4d57d1')/Employees" />

          <category term="BizDB.Business" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />

          <content type="application/xml">

            <m:properties>

              <d:Id>516485e36e8f91137c4d57d1</d:Id>

              <d:Name>Big Biz</d:Name>

              <d:Address>12345 Big Biz Lane</d:Address>

            </m:properties>

          </content>

        </entry>

      </feed>

       

      If I then hit the link http://localhost/BizDb.svc/Business('516485e36e8f91137c4d57d1')/Employees?$top=1

       

      <feed xml:base="http://localhost/BizDb.svc/" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns="http://www.w3.org/2005/Atom">

        <title type="text">Employees</title>

        <id>http://localhost/BizDb.svc/Businesses('516485e36e8f91137c4d57d1')/Employees/</id>

        <updated>2013-04-12T22:54:41Z</updated>

        <link rel="self" title="Employees" href="Employees" />

        <entry>

          <id>http://localhost/BizDb.svc/Employees('1')</id>

          <title type="text"></title>

          <updated>2013-04-12T22:54:41Z</updated>

          <author>

            <name />

          </author>

          <link rel="edit" title="Stage" href="Employees('1')" />

          <category term="BizDB.Employee" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />

          <content type="application/xml">

            <m:properties>

              <d:FirstName>John</d:FirstName>

                          <d:LastName>Doe</d:LastName>

              <d:Birthday>1-1-1960</d:Birthday>

            </m:properties>

          </content>

        </entry>

      </feed>