I am not sure if this is the correct place for this question. We have a reporting requirement. The OLTP database is SQL Server 2008R2. Number of reports required is 6 and not sure about the number of users to provide access. On an average 20k records
are added per day. Now as the number of reports is just 6, is it worth to create a multi dimensional database (OLAP)? Are there any OLTP reporting tools ? Any help would be appreciated.
View Complete Post