Tags » Data Model

Configuring PowerPivot for SharePoint

This week I was working on generating some reports using Excel 2013, Power Query, PowerPivot and then I wanted to publish them to SharePoint. Unfortunately our server wasn’t ready for it so I went through the process of installing PowerPivot for SharePoint (existing SharePoint) so my data connections in Excel workbooks (Data Models and PowerPivots) could be refreshed correctly. 166 more words


Application Data Model

Well, now the window dressing is in place we turn our attention to the core of the application, the ship data and how we want to manage the information. 1,379 more words


SSAS Multidimensional cube: How to solve duplicate attribute key error when attribute is non key?


In SSAS multidimensional cube, while processing a cube, you get an error/warning for a non-key “price” column that says:

Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: ‘Table Name’, Column: ‘Price’, Value: ’29′.

96 more words
Microsoft Business Intelligence

Change Management Systems - Is There a Better Way?

There is no denying that plant floor automation can dramatically improve efficiency and increase productivity, but there is an unintended consequence of automation that can make it problematic. 1,013 more words

Datawarehouse modelling: Inmon vs Kimball

If you’re into business intelligence, data warehousing and analytics, you will have heard an endless number of references to Bill Inmon and Ralph Kimball. These two figureheads in datawarehousing architecture have produced an immense number of books, articles, training seminars, etc. 636 more words

SQL Server Concepts