To my Tessitura geeks out there,
I am looking to start some SSAS and KPI's but before I venture into this jungle I thought I would see if anyone out there has created a SSAS project and has a tessitura specific SSAS database template I could use?
If not are there any suggestions on how to do all of this rather quickly and painlessly?
Many thanks!
Naomi Williams
Database Administrator
Tennessee Performing Arts Center
505 Deaderick Street
Nashville, TN 37243
Phone: 615-782-4021
Naomi,
Several years ago, I also started down this path until T-Stats came along. I no longer need to build one with T-Stats here. I actually spent more than a month or two just designing the fact tables before I even wrote one line of code.
The first question is do you have T-Stats? If so, you could always write your KPI's against their cubes.
If not, What kind of KPI's are you looking for? When I started, I was looking at a full blown data warehouse. You may only need a small segment so building the Data warehouse may not be a big deal.
If you are planning on KPI's from SSAS, I believe you need the Enterprise level of Sql Server. I could be wrong.
I used SSIS for the import of the data. T-Stats uses sql code to do that work. You will need to decide how to import the data into the staging tables.
Depending on your experience with data warehouse design and development, I suggest Ralph Kimball's books. http://www.ralphkimball.com/
Marty Jones
Omaha Performing Arts 1200 Douglas Street
Omaha, Nebraska 68102
P 402.661.8469 | F 402.345.0222
Marty.Jones@omahaperformingarts.org
www.omahaperformingarts.org
For tickets, call Ticket Omaha at 402.345.0606
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Naomi Williams Sent: Wednesday, April 28, 2010 12:17 PM To: Martin A. Jones Subject: [Tessitura Technical Forum] SSAS Database Template for Tessitura
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!
Marty,
I don't have TSTATS matter of fact I was thinking I could do this in place of. We have KPI's all over the place from ticket sales, to subscription sales, to development, to employee performance and a mirage of other things. We also have a need to gather data to report on that we cannot do through Tessitura because of the database structure like segregating subscription sales from ticket sales, inclusive of sales channel, mode of sale and other items. We are a consortium so each organization has a list.
I am thinking I need a full blown data warehouse to accomodate. I'm not sure if I need Enterprise ed of SQL Server for KPI's from SSAS or not I'll have to check into that. I have never used SSAS before so I'm going into unknown waters.
Thanks for the reference to the books, I need all the knowledge I can get right now.
Naomi
Hi Naomi
Hi Naomi,
Good day.
it is always good to learn something new.
you can go to this site and create a new account then download free videos.
http://www.learnmicrosoftbi.com/
multi-dimension cube or matrix are always very hard to think about.
do you know why?
because we always try to keep something that will not allowed in the cube or matrix.
in cube or matrix have only numbers and numbers only.
all the explainations of numbers only exist in dimensions.
So you have to lost something first, then you can get something else.
have fun
Ben