SSAS: Aggregate functions at design time for measures in a multidimensional data set

Source: Internet
Author: User
Tags count

Aggregate functions at the time of measurement design in a multidimensional dataset (additive _ semi-additive and non-additive)

In the SSAS series-Implementing the first cube as well as the role playing dimension, measure formatting and the creation of calculated members create a cube from existing dimensions and fact data, while interpreting the role-playing Dimension role playing dimension, calculated members, calculated as The format of the staff and other content. In this article, the main analysis and understanding of the cube in the design process of aggregate functions, corresponding to different categories of measures according to the requirements of the different aggregate function selection will also be different.

Continue using the example created in the previous SSAS article to see two sets of measure dimension groups and different measures in biwork_firstcube.

Select Reseller Sales Amount Right-view Properties aggregatefunction aggregate functions Select Sum aggregation, well understood is a summation operation.

Select Reseller Sales Count to right-click the property, and the aggregate function selects Count, which is created automatically when cube cubes are created.

Compare the structure of the fact table factresellersales and the measures that you can choose to make when creating reseller sales and Internet sales measure groups. Data for all value types like UnitPrice, Productstandardcost, salesamount These three columns create measure groups on the right Fact reseller sales all appear, but one more Fact reseller Sales Count, including a Fact Internet sales count under Fact Internet sales, is clearly counting statistics on the fact table. Therefore, the Count aggregate function is used by default in the reseller Sales Count measure, and the SUM function is used by default for other measures.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.