Many companies spend a lot of money, time and effort to build a data warehouse and OLAP cubes, however they start using them to build the same old 2D reports that they were used to from the past. The standard 2D canned reports (Rows and Columns) can be built from any conventional relational database by writing some standard SQL queries. So why use an OLAP (On Line Analytic Processing) cube for such reports?
Business Intelligence reporting includes the usage of "dimensions." To put it simply, a dimension is a way that you want to "slice" your metrics. For example, you may have a metric of revenue that you want to track. You may want to track this for dimensions such as product (i.e. provide a report of revenue by product), by territory, or by time. The time dimension is one of the most often requested dimensions for business intelligence reporting - but it can also be one of the most complex to implement. This post takes a look at how to create an effective time dimension for your BI project.
The complementary paper includes over 12 years of research, recent survey results, and CRM turnaround success stories.
This 60-second assessment is designed to evaluate your organization's collaboration readiness.
Learn how you rank compared to organizations typically in years 1 to 5 of implementation - and which areas to focus on to improve.
This is a sandbox solution which can be activated per site collection to allow you to easily collect feedback from users into a custom Feedback list.
Whether you are upgrading to SharePoint Online, 2010, 2013 or the latest 2016, this checklist contains everything you need to know for a successful transition.