SSAS Series--"06" Multidimensional data (cube creation)

Source: Internet
Author: User

Original: SSAS Series-"06" Multidimensional data (cube creation)

1. File type description

The project definition file (. dwproj), the project user settings (. dwproj.user), the data source file (. ds), the Data source view file (. dsv), the cube file (. cube), the partition file (. partitions), the dimension file (. Dim), A mining structure file (. dmm), a database file (. database), and a DB role file (. role). First boot, souvenir sticker.

Figure Start Interface Souvenir

Figure the contents of the default folder

2. Create data sources, data source views, dimensions, define and deploy cubes

Figure by SDK operator interface

Note that the data source view must select "Use service Account", otherwise the deployment will fail, the SDK does not have detailed instructions.

Figure Data Source simulation information interface

Figure Cube Data browsing

3. Modifying measures, attributes, and hierarchies

A, add a hierarchy of dimensions

It's simple, you just need to drag the mouse to complete the setup work, the settings need to be renamed after completion.

Diagram to set the hierarchy of dimensions

Diagram Setting attribute Relationships

Rigid relationships do not change over time:

Diagram Setting Relationship Properties

B. Add a named calculation

In the data source view, select the table, right-click, and select New named calculation:

Figure Edit Named Calculation

C. Define display folder

Select the dimension values to put in the folder (press the CTRL key to choose multiple), right-click, properties

Figure Setting the AttributeHierarchyDisplayFolder value

D, define the combination of KeyColumns

Figure Setup KeyColumns

Graph combination Values

Figure Setting Display values

E. View changes, deployment takes effect

Figure OLTP Database content update

Need to redeploy after diagram dimension update

Figure Cube Browse

SSAS Series--"06" Multidimensional data (cube creation)

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.