Forum Discussion

Shivkanyabyale's avatar
Shivkanyabyale
Frequent Visitor
2 years ago
Solved

I am stuck on budling relationship between date different table

I have say 4 tables Sales register,purchase,salary,production   i have data in day basis in some table and month basis in some table so i have created month column in all table and trying to build relationship with month  i also have status column in all table except production so also bulding relationship with that too ....  i am facing some problem over relations like if i filter on date it is working fine even status is working fine but some filter i have from sales register affecting charts of other table that have no relation with sales i am not sure why filters are working on wrong visual .
I am not sure why filter name of item affecting salary distibution table where logicaly it has nothing to do with sales item to that of salary distribution  likly it is affecting prodiction table visul as slary and production shareing same date for some visuals 

  • see if you can classify your tables as dimension tables or fact tables.  How do they control each other?

     

    Ideally you have a star schema with 1:* single direction relationships.

     

    You may want to add a calendar table to your data model.

2 Replies

  • see if you can classify your tables as dimension tables or fact tables.  How do they control each other?

     

    Ideally you have a star schema with 1:* single direction relationships.

     

    You may want to add a calendar table to your data model.

  • yes i have tried and i have externally risticted working of some flter on some visuls so now it is working fine for me Thanks