Attribute keys are not available in cube browser

• Anamika

  SSCertifiable

  Points: 6202

  More actions

  February 1, 2009 at 9:24 pm

  #134304

  Hi,

  i've built a cube with one fact table and four dimentsion tables namely factsales, DimProduct,DimStores, DimRetailer and DimCalendar.

  but i'm not able to find out the keys which is there in my dimension tables, say Retailerkey, Storeskey,Calendarkey and productkey.

  i can see that in my cube structure Datasource view but not in browser.

  what is the reason and how can i solve this.

  thanks,

  regards,

  viji

• Dirk Wegener

  Ten Centuries

  Points: 1161

  More actions

  February 6, 2009 at 12:23 am

  #939322

  Open the properties of the attribute in BIDS. Click the ... button of the KeyColumns property. Now change the datatype to BigInt

  http://www.dwexplorer.com
  @dtwegener