Once you upload data to Tableau, it does classify them into dimensions and measures. It is the fastest and easiest way that I can think of. If you want to see directly from your database, then you should contact your DB administrator.
Just make sure that Tableau have identified dimensions and measures correctly. Sometimes it make mistakes depending on the contents of that column.
Luckily for you the genius programmers at InterWorks have made a wonderful tool that does this.
We offer a free 14 day trial and you will be using just a piece of this tool called Data Source Audit. It will let you see per data source how many fields you have and it will tell you if they are a dimension or a measure and even the data type (date, datetime, int, float, etc). Once you install the product use the Data Source Audit on your workbook that you have in question and then you will be able to export the data into Tableau, Excel, or a PDF. The export will have this information that you are after. It's quick and easy to get the total number of Dimensions, Measures by datasource with this fantastic piece of software.
Thanks for the info..
Yes i knew the workbook tool . but there we don't have an option to select list of project i want or list data source i want to check . we have an option to select either all the projects for the environment or only sigle workbook
This scenario is not suitable for me
Is there any other alternative way is there
The datasource resides in a workbook. You can make a workbook with the
datasources in question and then when you run the auditor it will create a
list of all the dimensions and measures - per datasource. Past this I'm
nor sure what you are looking for. In this method we are able to check
multiple workbooks get the information we desire and separate out per each
datasource with using filters on the excel document or the tableau created
On 21 March 2016 at 12:16, sreekanth.upputuri <firstname.lastname@example.org>