Forum Discussion
Unable to filter a stylecode
I have a data model with a Y2_Sales table containing sales data, another Y2_Style table with all item information, and a final Y2_Style_color table containing item information at color level. Tab...
If you look at the arrows on your joins you can see which table is filtering another. In your case, Y2_Style filters the Y2_Style_color table and the Y2_Sales. You would need to have Y2_Style_color filtering Y2_Style in order for it to also filter the Y2_Sales table. Perhaps try creating one dimensio table that includes everything from Y2 Style AND color from Y2_Style_color. Then, in that table, concatenate style and color with an underscore between the two field. Then, in your fact table, do the same. This will be your key - join on that.