Hi all,
I am new to my position and I am trying to follow instructions for our monthly reporting from my predecessor. Can you access the TX_CUST_MEMBERSHIP and edit with SQL in analytics? Can you download the TX_CUST_MEMBERSHIP information from Tessitura? For our report I need to calculate the number of memberships with a different "memberships created" and "memberships expired' according the SQL parameters that were included in the notes left. However, the instructions did not include how to extract the information from the TX_CUST_MEMBERSHIP table. Any help or thoughts would be appreciated. Thank you!
So...you can't edit with SQL in Analytics (to my knowledge) and in any event Analytics has membership information downloaded nightly into it's own set of tables, from tables like TX_CUST_MEMBERSHIP. Is it possible that the notes include a query that is meant to be run in SSMS (SQL Server Management Studio)?
That said, membership initiation and expiration dates are all available in Analytics, so maybe depending on what you're after you won't need SQL.
One thing of note: the underlying tables related to memberships in the SQL database change significantly between v15 and v16. So if you do end up going the SQL query route, if your test and live are on different versions, you'd want different versions of the query in question. That said, as Gawain noted, memberships information is in Analytics in both versions and is likely to be a simpler route to take, depending on exactly that you are trying to do.
Thank you, Gawain. I believe you are correct about the query that is meant to be run in SSMS. Appreciate your reply.
We are live in v15 and our test environment is v16. I appreciate this information and I will be sure to double check the versions. Thank you for your reply.