Microsoft Analysis Services Database

This example discusses how to connect Tableau to a Microsoft Analysis Services database.
  1. Select Data > Connect to Data to open the Connect to Data page.
  2. Select Microsoft Analysis Services.
  3. Follow the steps in the Microsoft Analysis Services Connection dialog box to complete the connection.
    1. Step 1 – Select whether to connect to a cube file on the server or locally and then locate the cube you want to connect to.
      To connect to a remote cube, type the name of a specific server into the text box. If you are connecting to the server via HTTP you can enter the URL as the server name. To connect to a local cube file, select Local cube file and click Browse to navigate to the cube file on your computer.
    2. Step 2 – Provide log in information for the server.
      Specify whether to use Windows NT Integrated security or a specific username and password. If the cube is password protected, you must type your username and password.
    3. Step 3 – Test the connection.
      If the connection is successful, Tableau will alert you. If the connection is unsuccessful, verify that your user name and password are correct. If the connection continues to fail, your computer is having trouble locating the server. Contact your network administrator or database administrator.
    4. Step 4 – Use the drop-down list to select the database that you want to connect to.
    5. Step 5 – Select a cube from the database.
      Microsoft Analysis Services databases can contain multiple tables and views. Specify which table or view within the database you want to connect to. You can also connect to multiple tables or a specific query by selecting the Multiple Tables and Custom SQL options.
    6. Step 6 – Give the connection a name for use in Tableau.
      Specify a unique name for the connection. The default name is automatically generated based.
A completed Connection dialog box for Microsoft Analysis Services is shown below.


Note:
If you are connecting to a Microsoft Analysis Services 2000 data source, you are given the option to enable NonEmptyCrossjoin Optimization. When selected this option ensures that virtual dimensions are shown.

2 comments:

  1. The process undertaken to collect, compile and organize the collected data is referred to as data analysis. In analyzing the already collected and previous data, the researcher has to come up with a summary of the data. This is referred to as secondary research. See more statistical analysis with missing data

    ReplyDelete
  2. Enpersol offers Best Tableau Services, specializing in implementation and dashboarding in pune and indore. We are Best Tableau consultants in India.

    ReplyDelete