how to create dimension in ssas cube using ssis

• miriyalasrihari

  Ten Centuries

  Points: 1225

  More actions

  January 31, 2011 at 12:40 am

  #142279

  how to create dimension in ssas cube using ssis?

  [font="Verdana"]SRIHARI(:~[/font]

• Koen Verbeeck

  SSC Guru

  Points: 259015

  More actions

  January 31, 2011 at 1:18 am

  #1280277

  miriyalasrihari (1/31/2011)

  ---

  how to create dimension in ssas cube using ssis?

  You create a table in the database and you populate it with data using SSIS.

  You open your cube, and in the DSV, you add this table. Then run the dimension wizard to add it as a dimension.

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