Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Get information from a multi-columns dimension tabble

Hey there, is there any way so that I can filter data off a multi-columns dimension tabble? In the following image I've summed my question up, and what I've got to do is to filter data from my fact ...
  • Ashish_Mathur's avatar
    4 years ago

    Hi,

    You have no option but to use "Unpivot Other Columns" in the Query Editor.  You should thereafter build Dim Tables for Employee,  Area and Function.