

Measure to the view, the measure is marked with a caution symbol. Highlighted dimensions are notĭisabled and can still be added to the view. The last example, when we place Sales Quota onto a shelf, the productsĭimensions are highlighted in gray.

To place that measure against a dimension containing products ifĭimensions and measure that can be used together in meaningful waysīy highlighting unrelated dimensions and measures in gray. ForĮxample, you may have a measure for Sales Quota. When you build views in Tableau using a Microsoft Analysis Services Cube you might see some fields highlighted in gray, or you might see a caution symbol on a field in the view with the message, "This measure is incompatible with one or more dimensions in this view." This occurs because it is possible to have measures and dimensions thatĭon’t make a lot of sense when placed in the view together. Select the sheet tab to start your analysis. For example, use a data source naming convention that helps other users of the data source figure out which data source to connect to. (Optional) Select the default data source name at the top of the page, and then enter a unique data source name for use in Tableau. On the data source page, do the following: If you still can't connect, yourĬomputer is having trouble locating the server. If Tableau can't make the connection, verify that your credentials are correct. Specify whether to use Windows Authentication or If the cube is password protected,Īnd you are not in a Kerberos environment, you must enter your user name and password. Specify whether to use Windows Authentication or a specific user name and password. Select how you want to sign in to the server.

If you are connecting to the server using HTTP, you can enter the URL as the server name.Ĭube file, select Local cube file and select Browse to navigate to To connect to a remote cube file, select Server and enter the name of the Remote cube file on a server or to a local cube file. For a complete list of data connections, select More under To a Server. Start Tableau and under Connect, select Microsoft Analysis Services.

Make the connection and set up the data source If the driver is not installed on your computer, Tableau displays a message in the connection dialog box with a link to the Driver Download (Link opens in a new window) page where you can find driver links and installation instructions. You might already have the required driver installed on your computer. This connector requires a driver to talk to the database. Use this connector with Tableau Desktop on a Windows computer. Before you beginīefore you begin, gather this connection information:įor a remote cube file: Server name, or URL if connecting to the server using HTTPĪuthentication method: Windows Authentication or user name and password To a Microsoft Analysis Services database and set up a data source. This topic describes how to connect Tableau
