Forum Discussion
How do I retrieve values from non-related table | Lookupvalue help?
I am creating a project management table that shows project forecasted hours (planned hours), project actual hours worked, and a column for the difference. The forecast hours and actual hours tables...
Anonymous - You have two fact tables. Yes they are not related directly to each other, but there can be using Bridging Dimension like "Worker" and "Calendar". There table will apply filter context to the two fact tables. You need to create tables for each other dimension - role, project. Then just find the Actual and Plan columns, and create a measure table.
Anonymous - You have two fact tables. Yes they are not related directly to each other, but there can be using Bridging Dimension like "Worker" and "Calendar". There table will apply filter context to the two fact tables. You need to create tables for each other dimension - role, project. Then just find the Actual and Plan columns, and create a measure table.