2 Replies Latest reply: Sep 9, 2014 2:18 PM by madhuri p RSS

    Data filtering Problem (Master Calendar)

      Hi Everyone,

       

                      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,