How to identify whether a dimension is a database dimension or cube dimension ?

• Shadab Shah

  SSCarpal Tunnel

  Points: 4759

  More actions

  June 13, 2014 at 4:13 am

  #309141

  How can we distinguish whether the dimension is a database dimension or a cube dimension ??

• stevefromOZ

  SSC-Forever

  Points: 43646

  More actions

  June 13, 2014 at 4:47 am

  #1721401

  In what context??

  As a general statement, all dimensions are database dims but not all database dims are cube dims.

  Steve.

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  June 13, 2014 at 5:17 am

  #1721411

  Shadab Shah (6/13/2014)

  ---

  How can we distinguish whether the dimension is a database dimension or a cube dimension ??

  Open up visual studio and go to the cube. If the dimension is added to the cube, it's a cube dimension.

  When browsing an SSAS cube with Excel, the only dimensions you see are cube dimensions.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP