SSAS 2008 - dimension colmun not visible in cube browser?

• KM CoC

  Valued Member

  Points: 60

  More actions

  November 3, 2010 at 7:45 pm

  #149179

  Hi, I have one dimension and one fact table in SQL 2008 server...

  i.e. DimEmployee (Columns : EmployeeID, FirstName, LastName, DateOfBirth, Addrss, PostCode, MobileNumber, Gender)

  FactEmployeePay ( Columns : EmployeeID, Amount)

  When I create SSAS 2008 cube on those two tables (Relationship is EmployeID colmun) , deploy/process project/cube and then I go to "Cube Browser", but in dimension Employee table I can not see any columns other than EmployeeID. Why in this simple cube I can not view other dimension columns like FirstName, LastName,....

  Any idea for SSAS 2008? Thanks.

• amit_gupta01

  SSChasing Mays

  Points: 605

  More actions

  November 3, 2010 at 11:19 pm

  #1246386

  By default, it will give only key column. You need add required columns in SSAS 2008 by editing dimension.

  Thanks,
  Amit G
  http://www.msbiconcepts.com