Saturday, 8 June 2013

Creating SSAS Cube in SQL Server 2012

  • Open "SQL Server Data Tools". 
  • Create New Project “Analysis Services Multidimensional and Data Mining”. 
  • Add Data source. 
  • Create Data Source View. 
  • Create Dimensions 
      • Select Dimension Attributes 
      • Create Hierarchies 
  • Create Cube 
      • Select Dimensions 
      • Select Measures 
  • Deploy Cube 
  • Process Cube 
 
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)