Forum Discussion

tingh's avatar
tingh
Frequent Visitor
1 year ago

Dynamic filtering across multiple fact tables

Hi,    I'm looking for some ideas to achieve dynamic filtering across multiple fact tables based on user selection.   In my model, there are 2 dimensions - Project and Time 3 fact tables - Bud...
Need Help
dk_dk's avatar
dk_dk
Super User
1 year ago

Would you be able to combine the 3 facts into one, and have Budget, Fact and Forecast be distinct columns in that one fact table? I think that would make the filtering easier, because you could just sent conditions that if Fact[Budget] = (BLANK) then the given project does not have a budget...

  • tingh's avatar
    tingh
    Frequent Visitor
    1 year ago

    Thanks for the suggestion. Yeah that could work, I've tested it on a small scale and just need to see how it goes with more data and other tables.