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

[ashmitp869]

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 each project thus can't bring it main Fact as its duplicating.

Same with vDSRBudgetDetails - this has multiple entries thus I have used Brigding table.

In my summary report , I need to do the sum of all Sum(Revenue Amount) and Sum(Extented Amount), Sum(bdcc_value) 

Is my data modelling done correct as I am finding difficulities with measures calculation.

Like I need Sum(bdcc_value) * Sum(Actual Use Qty) . But as it has no relationship. The measure not working.

Please suggest

[Anonymous]

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.