Forum Discussion

ashmitp869's avatar
ashmitp869
Icon for Responsive Resident rankResponsive Resident
2 years ago

Help with data modelling as I have different Facts with different granularity ?

Hi , I am struggling to maintain the data modelling with my model. My fact have Revenue , Cost and Invoice Amount with is connected to projects. But my Fact BudgetCodes has multiple entry against ...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi ashmitp869 ,

 

Can you share your measure? I looked into it and I think you can use the Project Db Key in the Project table to get the fields you want step by step. the Project table with the DSR table can get the Budget Cost key and then the DSRDeatails table to get the Actual Use Qty. the other one is the same.

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.