Select dimension by slicer RRS feed

  • Question

  • I would like to provide users a way to dynamically select the dimension by which they analyse data in a pivot table. In a simple example, my fact table has 3 columns: product type, colour, volume. The pivot table consolidates the volume, and a slicer allows the user to display the sum of volume either by product type or by colour.

    The solution I have come to so far involves creating a table with a single column that contains all the single values of product type and colour. There are 2 relationships between the fact table and this lookup table: one active on the product type column, one inactive on the colour column.

    A 3rd disconnected table provides a way to select which of the 2 relationships is the active one for the consolidation metric. The example is available here.

    Would anyone have a different/better/simpler solution to this problem? 

    Tuesday, August 18, 2015 5:00 PM


All replies