SSAs multi-dimensional dataset and dimension Creation

Start vs to create an Analysis Services Project, right-click the data source file, and choose create data source. Create your own data source according to the data source wizard. 1:

Click OK, select the data connection, and click Next to enter the simulated information form. In this step, remember that my computer can only select "use service account ", otherwise, the multi-dimensional data set will not be connected to the database in the future. Of course, this depends on the personal computer, because my colleague chose "using a specific Windows user name and password" and still processed successfully. This step depends on your PC. Figure 2:

Next, complete the data source wizard. Next, create a data source view to provide data for creating a multi-dimensional dataset. Right-click the data source view → create a data source view. Follow the data source view Wizard to continue to Step 3:

Define the data source view, that is, use a part of the data warehouse as the cube operation object. The data source view is a metadata UDM, this metadata comes from the view or table defined by the specified table and data source in the project. By storing metadata in the data source view, you can use metadata during development, you do not need to open any connection to the basic source. Next, we will provide operation instructions: select the expected objects from the list of available objects on the left to the list of objects on the right, and then → next, name the view → complete. Double-click the view to go to The View Design page, check whether the relationships between tables in the view have been correctly established. If not, manually create the relationship. Figure 4:

After defining the data source view, you can define a multi-dimensional dataset based on this. Right-click the "multi-dimensional dataset" project and choose "create multi-dimensional dataset" Wizard> "Next"> "select your own creation method" (I selected "use existing table"). Figure 5:

→ "Next" → "select create measurement value group table". Here, the data source view is the data source view created in the previous step, as shown in Figure 6:

→ 'Next' → 'select a new dimension 'Figure 7:

→ 'Next' complete wizard → 'complete '. Now, we have created a multi-dimensional dataset and dimension. Figure 8:

Double-click a multi-dimensional dataset to go to the multi-dimensional dataset design page. The measurement value and dimension figure 9 are displayed:

If the dimensions are incomplete, you can right-click 'properties'> 'edit dimension 'To Go To The Dimension Structure page and add the required dimension, right-click the dimension table field → create Attribute from column. The dimension is automatically added to the dimension attribute list on the right, as shown in Figure 10:

Finally, right-click the solution and right-click the created multi-dimensional dataset 'process'. A prompt is displayed, indicating whether to redeploy the data. Click [Yes] to deploy the data. After the deployment is successful, the "processing multi-dimensional dataset" page is displayed. Click "run" to enter the processing progress form. Here, you can clearly view the processing status of the dataset. The processing status of each stage is displayed in the processing status. After successful processing, you can see the generated Analysis Services Project figure 11 in the Analysis Services Service of your local database:

 

SSAs multi-dimensional dataset and dimension Creation