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.
Thank you, Gawain. I believe you are correct about the query that is meant to be run in SSMS. Appreciate your reply.