degenerative dimension in cube

• ps_vbdev

  SSCarpal Tunnel

  Points: 4060

  More actions

  October 19, 2016 at 4:49 am

  #151476

  Hi

  newish to Data warehousing and even newer to cube development. Ive built my sales dw and when building the FactOrder table ive included the orderid as a degenerative dimension. I did this thinking it would be pulled through into the cube and so i could see the orderid in the pivot table in excel, which would make checking the cube against the source data easier. I'm now finding that this won't be the case, only keys and measures are processed by the cube anything else it ignores. Obvioulsy have loads to learn but is there a way i can get this orderid into my pivot table?

  Thanks

• Martin Schoombee

  SSCoach

  Points: 19128

  More actions

  October 20, 2016 at 9:13 am

  #1907688

  Yes, create a cube dimension with the fact table as its source and add the required attributes.