Hello all,
We have a need to pull a report/query that includes the following data:
I've tried lists an output sets but not all fields are available. Would this better as a SQL query? If so, what are the primary tables that contain this data? I've looked at the "T_" tables, via SSMS, and view tables. But, I think the need for the "initiator" has me hung up.
Any suggestions?
Thanks,
Charles
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
Chris WallingfordDirector, Business IntelligenceTessitura NetworkOffice +1 888.643.5778 ext 553chris.wallingford@tessituranetwork.com
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?
Thanks, Chris.
I did take a look at the BI View tables but wasn't sure about the recency of the data. I appreciate you including the link to the new views. Much appreciated!
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.
The BI Views query the live Tessitura database tables, so they'll produce up-to-the-moment data.
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?