I built a SQL Server data mart that feeds the Tableau Workbook where I have summarized information related to a production order that shows the estimated vs. actual costs and the variance. If I then click on the production order, I would like that to take to the actual details related to this production order where the data is in an ERP system which uses Oracle database. The reason not to load this detailed data into SQL server data mart is because of the high volume of records and kind of eliminate duplication. Is this type of Drill thru possible with Tableau?
Kumar, you can't build an hierarchy using fields from different datasources connected by data blend.
If you can build the whole data from detail tab in Oracle, you should work only with it and forget your SQL Server datasource in Tableau.