We have a report which generates the query as
Inner join Dimension1 d1 on d1.key=fv.key1
Inner join Dimension2 d2 on d2.key=fv.key2
The where clause filters values(XX and YY) come from user selected report prompts. I want to change these filters to use the keys instead of values coming from the prompts. Something like Key/value pair and also I want those keys to apply to fact key columns (fv.key1, fv.key2) and not Dimension keys(d1.key,d2.key). The reason is that unless filters apply to view directly, the view takes a vary long time to complete. If keys are applied at DB level then view completes in a min.