Post reply

creating attribute relationships

  • March 8, 2012 at 1:46 am

    #269592

    Hi

    I have the dimGeography table from the adventureworks database and i am trying to create attribute relationships so i can create a hierachy.

    as soon as i create the first relationship that isnt related to the Geography Key (which is [postal code] to [city]) my solution fails to deploy. I get one of 2 errors and neither say very much.

    Server: The operation has been cancelled

    or

    Internal error: The operation terminated unsuccessfully.

    is there something i am missing when doing this?

    all i do is right click in the attribute relationships pane and create new relationship.

    Thanks in advance

  • March 9, 2012 at 6:48 am

    #1457152

    What happens when you try to process the dimension?

  • March 9, 2012 at 6:53 am

    #1457156

    i get 2 errors and a warning

    Errors and Warnings from Response

    Internal error: The operation terminated unsuccessfully.

    Server: The operation has been cancelled.

    Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_DimGeography', Column: 'City', Value: 'Augsburg'. The attribute is 'City'.

    thanks for the reply

  • March 9, 2012 at 6:57 am

    #1457161

    dunne.neal (3/9/2012)

    i get 2 errors and a warning

    Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_DimGeography', Column: 'City', Value: 'Augsburg'. The attribute is 'City'.

    thanks for the reply

    That part is the key... must be something in your key relationship causing these duplicates

  • March 9, 2012 at 7:59 am

    #1457214

    Hi

    there is a duplicate in the city field but they are two cities with the same name from 2 different states

    Is there a way of taking this city field out of the key in the dimention editer or making sure that the key coves both city and state fields?

    sorry i am brand new to this

    Thanks again

  • March 9, 2012 at 8:06 am

    #1457220

    You should be able to specify 2 columns (City and Province/State) as the key "column" for the attribute. In the properites pane, click the ellipses [...] button next to the key and go from there.

    Steve.

  • March 9, 2012 at 8:44 am

    #1457244

    thanks mate got it working

    does every attribute need a key?

    and is there a way of setting the same key on every attribute?

Viewing 7 posts - 1 through 6 (of 6 total)

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