Sharing queries over an odata feed, using Rapattoni netmagic.


In the last memo, netmagic users shared query within the netmagic community. The queries were designed to run over tables in worksheets that the user, both sharing-user and shared-user, already had –-having downloaded the excel file with the “source” snapshot of listing data. This model works fine, for teams of rea`ltors perhaps. It doesn’t work so well with realtors and homeowners.

So in the next trial, we make a workbook that references a public source – of the snapshot data. That is, we reference the odata feed (of the same data snapshot).

So, as a non-realtor to whom a realtor has granted access to the odata feed (of yesterdays snapshot of listing data, from BARS), we get our own local copy of the source data:

 

image

https://netmagic.sharepoint.com/bi/_vti_bin/ExcelRest.aspx/Shared%20Documents/Barstow.xlsx/Odata/Table_Query_from_Barstow

This process of course avoids having to download an excel file full of data sourced to an ODBC connection (that the typically users will NOT have). Immediately, we see the worksheet fill with the preview rows, and then the odata source is consulted:

image

we can now share to share our data, once we have netmagic/office use odata to sort and filter to look at properties measured in lot square footage.

image

one see then (and note what happens less than perfect data entry is treated this way)

image

we then share our BI query (over an odata source, that tied to a netmagic/sharepoint hosted excel file with table)

 

image

if we sign out (of support170@rapmlsqa.com) and sign into the query tool as niki@rapmlsqa.com

image

we see that niki has access to support170s work, filtering and sorting suitably for their professional conversation.

image

Niki is a power excel user, and loads the data into power pivot (the full cube-oriented data analytics tool that used to come only with high end servers).

image

Advertisements

About home_pw@msn.com

Computer Programmer who often does network administration with focus on security servers. Very strong in Microsoft Azure cloud!
This entry was posted in odata, RETS. Bookmark the permalink.