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,