Post reply

SSAS Newbie errors: "no key attribute is defined" & "Granularity is not defined"

  • February 15, 2016 at 4:57 pm

    #146021

    Am working through SSAS tutorial using AdventureWorks2012DW: https://msdn.microsoft.com/en-us/library/hh231701.aspx

    Have deployed Cube (end of Lesson 2) and at end of Lesson 3 encountered many errors. I reversed the creation of a hierarchy trying to get to an earlier state, but am still unable to deploy due to two errors:

    1. Dimension[Customer] :No key attribute is defined

    2. RegularMeasureGroupDimension[Adventure Works DW2014].[Internet Sales].[Customer] : Granularity is not defined.

    I have solved 1 by Right click on Customer Key, and from the drop-down menu selected “Set Attribute Usage”\Key

    What should I be doing to solve 2?

    --Quote me

  • February 15, 2016 at 5:32 pm

    #1858880

    solved. I double clicked on the error for 2 and it returned a window in which I defined granularity. Nice feature in SSAS to direct you to the item that needs fixing by raising an error and leading you to the place where you need to fix!

    --Quote me

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply