Output/SQL: Constituent Info, Order Details to include Initiator

Hi Charles,

You might also be interested in looking at the Reporting View: BI.VT_ORDER_DETAIL? It has most of what you're after in one place. BI.VT_CUSTOMER also provides easy access to customer information in one place. These reporting views are enhanced as needed with every version release.

https://community.tessituranetwork.com/tessitura_software_forums/f/tessitura_shared_reports-9/18887/tessitura-analytics---new-views

Best,
Chris

What is the best way to bulk extract the BI views for the organizations who are on RAMP who would like to do advanced analytics based on this data?

Hey Tom,

Great question! Was nice to meet you at TLCC.

I have been wondering the same. We are still on v14 with plans to upgrade to v15 in the coming months. What I learned about Tessitura Analytics at the conference was encouraging, but I also see the need to tap directly into the data to develop ad-hoc analysis models with whatever flavor of BI tool one chooses. I'm wondering if there are limitations currently due to security on RAMP. I'm wondering if other RAMP-based orgs have utilized an in-between cloud solution--maybe Azure?

We went fully live on Tess this past August and are still learning our way around the platform.

Hey Tom,

Great question! Was nice to meet you at TLCC.

I have been wondering the same. We are still on v14 with plans to upgrade to v15 in the coming months. What I learned about Tessitura Analytics at the conference was encouraging, but I also see the need to tap directly into the data to develop ad-hoc analysis models with whatever flavor of BI tool one chooses. I'm wondering if there are limitations currently due to security on RAMP. I'm wondering if other RAMP-based orgs have utilized an in-between cloud solution--maybe Azure?

We went fully live on Tess this past August and are still learning our way around the platform.

Hi Tom and Charles,

I'm stepping out of my depth a bit, but if you are able to write a custom report that pulls data from a BI view, can it then be scheduled to run and save as a delimited file to your FTP server location, (this assumes you're not including sensitive customer information.) Then pick it up from there?

Chris

Has anyone tried using OData calls to SSRS reports?  See this description.  This looks like it should work with Microsoft's Power Query/ Power BI

https://docs.microsoft.com/en-us/sql/reporting-services/report-builder/generate-data-feeds-from-a-report-report-builder-and-ssrs?view=sql-server-2017

However, I'm not clear how many other tools support ODATA?

In doing a quick look I see that R's CRAN repository has this.

https://cran.r-project.org/web/packages/OData/OData.pdf

Which means that most other tools that support R Libraries might also support this.  

The question is how performant, something like this might be.

Looks like there might be some Python Tools as well.

https://www.odata.org/libraries/

Anyone want to sit down with me and see if we can figure out how to make this happen?