Create and use Excel Pivot Table report based on data cube using SQL Server 2008

Practical - 5
Create and use Excel Pivot Table report based on data cube using SQL Server 2008.
Download Practical
Following are the Steps to create an Excel Pivot Table report

1.      Start The Microsoft SQL Server.


2.      To connect from Excel to SQL Server Analysis Service (SSAS) in Excel go to File > Data and select From Other Sources. After that, select the From Analysis Services option. What we are doing is connecting to a Multidimensional SSAS Database using Excel.


3.      Enter the name of the server and the authentication where the Analysis Server is installed.


4.      Select the Analysis services.

5.      Save Data Connection File.

6.      Select The PivotChart and PivotTable Report and Existing worksheet.


7.      Sample shows the sales statistics of the Automatic Responses and Fact Call Centre Count.


Comments

Post a Comment

Popular posts from this blog

Study of DB Miner Tool

Image
Practical - 9 Study of DB Miner Tool. Download Practical Introduction DBMiner, a data mining system for interactive mining of multiple-level knowledge in large  relational databases, has been developed based on our years-of-research. The system  implements a wide spectrum of data mining functions, including generalization,  characterization, discrimination, association, classification, and prediction. By incorporation  of several interesting data mining techniques, including attribute-oriented induction,  progressive deepening for mining multiple-level rules, and meta-rule guided knowledge  mining, the system provides a user-friendly, interactive data mining environment with good  performance. A data mining system, DBMiner, has been developed for interactive mining of multiple-level  knowledge in large relational databases. It is based on studies of data mining techniques and  experience in the development of an early system prototype, DBLearn. The system  implements a
Read more

Study of WEKA tool

Image
Practical - 6 Study of WEKA tool. Download Practical Introduction: Weka is open source software under the GNU General Public License. System is developed at the University of Waikato in New Zealand.”Weka”stands for the Waikato Environment for Knowledge Analysis. Weka is a collection of machine learning algorithms for data mining tasks. The algorithms can either be applied directly to a dataset or called from your own Java code. Weka contains tools for data pre-processing, classification, regression, clustering, association rules, and visualization. It is also well-suited for developing new machine learning schemes. Weka has extensive help facilities built in and comes with a comprehensive manual. Weka supports several standard  data mining  tasks, more specifically, data preprocessing,  clustering ,  classification ,  regression , visualization, and  feature selection . All of Weka's techniques are predicated on the assumption that the data is available as one
Read more

Create calculated member using arithmetic operators and member property of dimension member

Image
Practical - 4 Create calculated member using arithmetic operators and member property of dimension member. Download Practical Calculated members are members of a dimension or a measure group that is defined based on a combination of cube data, arithmetic operators, numbers, and functions. For example, you can create a calculated member that calculates the sum of two physical measures in the cube. Calculated member definitions are stored in cubes, but their values are calculated at query time. Follow the Steps to create new calculate measure 1.       Open Cube Designer for the Analysis Services Tutorial cube, and then click the Calculations tab. 2.       On the toolbar of the Calculations tab, click New Calculated Member. A new form appears in the Calculation Expressions pane within which you define the properties of this new calculated member. The new member also appears in the Script Organizer pane. 3.       In the Name box, change the name of the calculate
Read more