OLTP database, trying to ease the reporting difficulties

the two servers involved are sql 2014 and sql 2016
Our billing system is an OLTP database and it is very hard to report off of.   I have been reading on OLAP and ssas.  Is there a good manual or starting place for a rookie to try to overcome the reporting issues.
any ideas on should i start with trying to use ssas or creating an olap database from the online transactional database.
jamesmetcalf74Asked:
Who is Participating?
 
Pushpakumara MahagamageVPCommented:
Creating a Data cube and grant access to finance people would be the best option. becouse they are excel experts and they can view data as they wish from data cube.
Read following article and create SSAS Data cude.

https://www.mssqltips.com/sqlservertutorial/4203/sql-server-analysis-services-installation/

https://www.youtube.com/watch?v=ct_hn_e_59k  (I didn't watch entire video)
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
I'm not sure if you really want to go for SSAS for this.
Being hard to report from your OLTP database, it might means that perhaps isn't well designed instead of "not work for an OLTP db".
If you can be more specific with the kind of report are you trying to obtain, it may help us to advice you better.
0
 
jamesmetcalf74Author Commented:
Thanks Guys
0
 
Pushpakumara MahagamageVPCommented:
You are welcome.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.