Forum Discussion
Issues with Model when fetching data with
There's a data problem and it's causing the links between Master-Transactions to break. To debug this, build some simple table visualisations to test the relationships between each pair of tables in the chain e.g. Master-Contract
, Contract-JobOrder
. If you put one field from each table in the visualisation, you'll see which one is blank and that will be the problem.
-----
For the longer term I don't really like the model. It's not a star schema, it's got many to many relationships and dual direction relationships so have a think about remodelling as well.
Good luck.
Hi HotChilli ,
I updated the query on this topic as,
RLS needs to applied on Master but when we try to bring data from Categories and Transactions in one report table it shows empty. So please suggest if the current model remains the same and UserMap can filter Category too
I also changed the Direction between Transactions and Categories to both and turned on apply security filter on both but still no luck.We have many to many here, For example between UserMap and Master we jave join between LE & Entity cloumns. And in our case one company/vendor can have multiple LE assigned and one LE can be assigned to multiple vendors/companies. How do you suggest to work around on it?
And also for bidirectional relationship,
I had a meeting with MS for one of the issues where the consultant said one of the best practices is to keep direction in both sides so that both can filter each other , and since we don't have to create any reports and just expose the model so the report user might need filter in any direction which is why after consulting with our functional consultant came to the decision of keeping cross filter direction as both. Please advice
