3 Replies Latest reply on Nov 17, 2012 5:40 AM by Russell Christopher

    SSAS Dimension calculated members in Tableau

    Viswanath Sankar

      Hi,

       

      I have a calculated member called Top 10 products in my product dimension (SSAS). This stores the value of Top 10 products for each measure. Could anyone tell me how I can view this member in Tableau? When I drag the Product attribute on rows, it does not show the calculated member.

       

      My requirement is to show data for all products, Top 10 products and Total Products in a table. i.e. One row for each product and a row for Top 10 Products and a row for Total Products. I would be also interested to know if there is a way to accomplish this without having to calculate this in SSAS and dsiplaying in the report.

       

      Thanks

      Vishy