3 Replies Latest reply on Nov 30, 2017 10:31 AM by AB Commendatore

    Show full data with SSAS cube aggregations and details in relational database.

    D KV

      If I connect Tableau to SSAS cube to get the aggregations, how would I show full data report related to the filtered values in dimensions.
      Example: If I have a "paid amount" measure that is tied to Category, Product and Time dimensions. A user filters Nov 2017 in the Time dimension, C1 for Category dimension, and All Products for Product dimension, it would show the measure values as $ 1234.99. Now I want to see all the transactions that made up this number, that are stored in a fact table with transaction level detail. How do I pass the chosen dimension values to a relational query to display on the detail (drill down) report? How do I provide a link to save this detail data in excel?

       

      Thanks in advance.