analytic Coffee Lovers,
We will meet in Lean Coffee Style Online on Friday 5/3/2019 @ 12:00noon EDT to discuss all things Tessitura Analytics, analytics & data science within the Tessitura Community.
The Agenda of our conversation will be set by the folks who show up related to our topic of interest. I've already set our lean coffee Table web site for this meeting.
We will pick who goes first and how long we want to continue on a particular topic with Lean Coffee rules.
We are going to use Google Meet for our session. The link will be https://meet.google.com/riv-wjpp-rjk.
Please try to Join from a computer with a camera so that we can all see one another. If you must join from a phone:
Phone Numbers (US) +1 629-888-0820 PIN: 137 807 574#
The meet.google.com link will include a full list of phone numbers for all supported countries.
You will have a much better experience on this call if you can fully participate. Having a webcam, and computer audio link seems to make things better. Please feel free to reach out to me with any challenges you might be having in connecting into our conversations. Or join in on this discussion going on right now in our group at https://community.tessituranetwork.com/topical_groups/analytics-coffee/f/discussions/22402/connecting-to-analytic-coffee
Here are the Notes from today's conversation. Thanks all for joining.
analyticCoffee-03May2019.pdf
Just wanted to share my joy. I've been plugging away at the hockeystick graph and I'm starting to crack it using the new BI.VTs and this little piece of code I cooked up. I'm overly proud of it due to being a self taught SQL novice. Looks promising so far. Thanks for the tips all
declare @lastperf datetime select @lastperf = MAX(perf_dt) from BI.VT_ORDER_DETAIL where prod_season_no = 553
Select days_prior, sum(sales) over (order by days_prior rows unbounded preceding)
from ( select (DATEDIFF(DD, @lastperf, order_dt)) as days_prior, sum(paid_amt) sales from BI.VT_ORDER_DETAIL where prod_season_no = 553
group by (DATEDIFF(DD, @lastperf, order_dt))
) t
order by days_prior asc
Does the Keyword trim the view?
Yes. Here are the details:
https://www.tessituranetwork.com/Help_System_v150/Content/Tessitura%20Analytics%20Tech/Suppress%20Unsold%20TKW.htm
Cheers,Chris
What happens if
"Prior to running the Load Data Warehouse job for the first time, add the Suppress Unsold keyword to all appropriate production elements." One did not add the keywords?
Is there a process to apply these changes after the Warehouse has been put into operations?
P.S. I can open a TASK ticket when we are ready to look at this in detail.
Hi Tom,
The keyword application will be fully reflected after the next FULL load, scheduled weekly in RAMP. In the meantime, performances with seating that's refreshed during the nightly incremental will like see the change applied then.
Best,Chris
Woh! We max out at 132,779 rows over about 30 seconds, but ProdSeason 553 is a 5 performance run of a 889 seat theatre so it's a lot smaller that what you're pulling.
select * from BI.VT_ORDER_DETAIL where prod_season_no = 553 returns 1753 lines of data in about 2.5s
This little select above returns 119 rows of calc