Browsed by
Month: March 2016

Analysis Services: Solving Hierarchy Errors of Uniqueness

Analysis Services: Solving Hierarchy Errors of Uniqueness

Multidimensional Cubes provide speed when it comes to retrieving aggregations that are important to business decisions. Being able to slice or group the measures by dimension attributes helps with a quick analysis and flexible/interactive reporting. Configuring these attributes as hierarchies has some details that are not at first obvious. The error message when these problems exist is not extremely helpful for someone new to cubes. Let’s look at creating a Date hierarchy with Year, Quarter, Month and Day. Our cube…

Read More Read More