Cube Level key missing

• radha.k.ds

  SSC Journeyman

  Points: 79

  More actions

  September 9, 2011 at 5:29 am

  #243521

  Hi all

  I am getting error when I process the cube

  Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'Cube_entities_f_transaction', Column: 'currency_rate_skey', Value: '-1'. The attribute is 'Currency Rates Skey'.

  I created Named Query in DSV and there it is showing the attribute key and when i process the cube the above error i am facing can somebody give me any suggestions for these issuue

• wildh

  SSCarpal Tunnel

  Points: 4370

  More actions

  September 13, 2011 at 1:22 am

  #1380433

  This message is refering to a 'value' not the fact that a key is missing. You DSV is showing the 'key' is there but can it handle the value of -1?

• aks27

  SSC Journeyman

  Points: 78

  More actions

  September 14, 2011 at 3:46 am

  #1381135

  Try To to Process the Individual dimension, that is related to the DSV View , Then Process the Entire Cube....It should work!...

  aks27
  MCP, MCDBA(2005), MCTS(BI)