Forum Discussion
Schema Advice
I have attacahed my schema for my data.
I am having an issue when i try to bring in Activity_Amt from the Journal_Entry_Line_Item table. I am trying to have the following items in my report
Fact_facility [COID]
Fact_facility [COID_Name]
Department [Dept_Num]
Sub_Functional_Department [Sub_Functional_Dept_Desc]
Journal_Entry_Line Item[Activity_amt]
When i go put in Activity Amt it gives me the total amount and not the dept number total. Any input would be helpful.
1 Reply
Please explain the reasoning for all of your Many-to-Many relationships with bidirectional search filter. Your data model should not have such connections unless you are absolutely positively sure that you need to have them. The ideal connection is a 1-to-Many connection with single filter direction from "dimension" to "fact".
