I'm looking for some ideas on how you handle custom report writing in your organization as well as what you think are the pros and cons of your chosen model. So, for example, does 1 person in IT handle all custom reporting needs or do you have a power user in each department that can write reports, but use IT to vet them and move them into the Production system? Or something else entirely?
We're tossing around ideas and trying to balance what we expect to be a big desire for more custom reporting quickly vs. the security concerns around having non-IT folks access the database.
Thanks!
Kjersten SchladetzkyProgram Manager, American Museum of Natural History
Cool we have some prototypes in this areas as well. Are you at TLCC 2014. If so I’d like to meet up.
--Tom
…
718.724.8135
tbrown@BAM.org
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Troy NelsonSent: Monday, August 18, 2014 4:43 PMTo: Thomas BrownSubject: Re: [Tessitura Technical Forum] Report Writing - Who does it?
Hi Kjersten,
One thing that is a boon for ad-hoc reporting is the BI-model called tabular. Starting in SQL 2012, this model is table based and can be accessed via Excel, SSRS, or through sharepoint as Power-view presentation. We've deployed it here in SMM, but as with something new, one must maintain it too.
Troy
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!