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

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 calculated measure to [Total Amount].

4.      On the Metadata tab in the Calculation Tools pane of the Calculations tab, expand Measures and then expand Fact Internet Sales to view the metadata for the Fact Internet Sales measure group.

5.      Drag SalesAmount from the Metadata tab in the Calculation Tools pane into the Expression box in the Calculation Expressions pane.

6.      In the Expression box, type a plus sign (+) after [Measures]. [Sales Amount].

7.       In the Format string list, select "Currency".

8.      In the Non‐empty behavior list, select the check boxes for Unit Price and Sales Amount then click OK.

9.      On the toolbar of the Calculations tab, click Script View, and then review the calculation script in the Calculation Expressions pane.

Fig 1 Defining Calculated Members



Fig 2 Shows Calculation scripts

Browsing the New Calculated Members

Drag and drop the Calculated Measure.


Fig 3 Browsing the new calculated members

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