Forum Discussion
Help with custom multi-filter(?)
hello
U can create a fact table for utilization type and map it to the other table. You can refer below. See below how I solved it. I hope this is what you wanted.
Updated for clarity -
I attempted to solve the problem through relationships, however, sometimes an activity type belongs in more than one Utilisation Type, for example; BD and External Projects need to appear in Productive and Billable categories (eventually I wish to use Utilisation Type to filter my data).
See below for my attempted logic
artfulmunkeey
How are you going to classify the rows in your fact table to cater for the duplicates? In other words, if your fact table has a row for "Business development", how will you know whether it's "Billable" or "Productive"?
It seems to me you will need to create anew column in the fact table to establish each row's "Utilisation Type". You can then establish separate dimension tables for "Activity Type" and "Utilisation type".