This content has been marked as final. Show 2 replies
7 Master tables and one Transaction Table in my database.I have created common Calendar.
I have Connected all the Master tables with Transaction table by using Key fields.
Common calendar is also connected to Transaction table. when i am filtering using month dimension ,data is filtering only for the records in Transaction table for master tables.I need complete data in Master table.
Ex: I have company table if i m filter using master table i m getting 11579 company names.
same expression ,if i do filtering in Transaction table i m getting around 7000 Company names.
Any Suggestions would be greatly Appreciated.
please find snapshot,