.Net Interview Questions and Answers

Search:

QuestPond's Interview Questions & Answers on SSIS, SSAS and SSRS(MSBI)

By : Shiv Prasad Koirala | Jul 22nd, 2014 | Views : 4258 | Comments : 0 Bookmark and Share

How to create Cubes using SSAS?


It's simply a 4 step process.


1. Create a new Analysis service project. Open your Business Intelligence studio or Sql server data tools.

2. Create data source - In the analysis service project you will find couple of folders.
    Datasource represents the storage from where cube will get its data.


a. Right click the datasource project and select new datasource.

b. Enter Server information and select database.(Your data warehouse Database)



c. Enter the impersonation information (Enter the user name and password with appropriate credentials) and click Next



d. Enter Datasource Name and click Finish


3. Create Datasource View - It will let us define what all objects(tables) in datasource are going to be used in cube generation.


a. Right click the "Data Source Views" folder and select new Data source view


b. Select the datasource created in the last step.



c. Select the required tables and click Next



d. Enter Datasource view name and click finish.



4. Create cube


a. Right click the cube folder and select New Cube.


b. Use "Existing tables" option.



c. Select measure tables (Fact tables) from the list (table which contain numbers).



d. Select measure fields in the measure table.



e. Select the dimensions from the list



f. Enter cube name and click finish.


For technical trainings on various topics like WCF, MVC, Business Intelligence, Design Patterns, WPF, TFS and Basic fundamentals feel free to contact SukeshMarla@Gmail.com or visit www.sukesh-marla.com


For more stuff like this, click here. Subscribe to article updates or follow at twitter @SukeshMarla


See following video on SSIS, SSAS and SSRS: -



Click and see here for more step by step learning SSIS, SSAS and SSRS(MSBI).

 
Rate this Article :
1 Star
2 Stars
3 Stars
4 Stars
5 Stars
1 1 1 2 1
 
 
 
 

.NET interview questions 6th edition (Sixth edition) - By Shivprasad Koirala

In this article we will explain .NET interview questions 6th edition (Sixth edition) - By Shivprasad Koirala.... Read More

What is the difference between Stored Procedures and Function (SQL Server interview question with answers)?

In this article we will explain what is the difference between Stored Procedures and Function.For more articles and videos visit us on www.questpond.com... Read More

Explain MVC application life cycle?

In this article we will explain MVC application life cycle.For more articles and videos visit us on www.questpond.com... Read More

C# Design pattern interview questions with answers: - How Singleton is different from Static class?

In this article we will explain How Singleton is different from Static class.... Read More

WCF interview questions and answers: - What is the difference between Service endpoint and Client endpoint?

In this article we will explain What is the difference between Service endpoint and Client endpoint.... Read More

.NET interview questions 6th edition (Sixth edition) - By Shivprasad Koirala

In this article we will explain .NET interview questions 6th edition (Sixth edition) - By Shivprasad Koirala.... Read More

What is the difference between Stored Procedures and Function (SQL Server interview question with answers)?

In this article we will explain what is the difference between Stored Procedures and Function.For more articles and videos visit us on www.questpond.com... Read More

Explain MVC application life cycle?

In this article we will explain MVC application life cycle.For more articles and videos visit us on www.questpond.com... Read More

C# Design pattern interview questions with answers: - How Singleton is different from Static class?

In this article we will explain How Singleton is different from Static class.... Read More

WCF interview questions and answers: - What is the difference between Service endpoint and Client endpoint?

In this article we will explain What is the difference between Service endpoint and Client endpoint.... Read More

Article Categories

Learn in Hindi